HELP FILE

How do I import stored data into LastPass using a generic CSV file?

    If LastPass does not support importing from your current password manager via the on-screen instructions, you may be able to import using a generic CSV file. Before proceeding, please check that your current password manager has an option to export to a CSV file.

    Attention: While you can import and store an unlimited capacity of items in your LastPass vault, you may encounter an import issue or failure to import if you are importing 200 or more items at once.

    Generic CSV file overview

    If you use your own spreadsheet instead, it is important that the title of the columns match the format used in the examples within our sample template. Fill the columns with the values you’d like for each entry (leave blank if the value is not relevant).

    Important: To import using your own CSV file, you must use lowercase text for all column headers.
    Tip: On Mac computers, please be sure you edit your content in your Mac's native TextEditor app or another text editor app, as reformatting issues can occur if you use Microsoft Excel.
    Your CSV import file for a combination of sites and secure notes should include the following columns (in all lowercase text):
    • url – typically the login URL, but you can use http://sn to create a Secure Note
    • username – the username used for the site entry
    • password – the password used for the site entry
    • extra – can be either the "notes" section of a site entry or the body of a secure note
    • name – the name to identify the site entry or secure note in your vault
    • grouping – the folder where you would like the item to be stored in your vault
    • fav – enter a 1, if the entry should be added as a Favorite but by default the value will be 0 (indicating that it should not be added as a Favorite)
    • totp – enter the TOTP code generated for your site entry (learn more about this feature)

    About importing only sites

    To import only site data, you must define at least the following values:
    • url
    • username
    • password
    • extra
    • name
    • grouping
    • fav = 1 or 0
    • totp
    To ensure accuracy of your columns, please see our generic CSV sample import format in our template.
    Important: To import using your own CSV file, you must use lowercase text for all column headers.

    About importing only secure notes

    If you use your own spreadsheet instead, it is important that the title of the columns match the format used in the examples within our sample templates, and that you leave the "username" and "password" columns blank.

    Important: To import using your own CSV file, you must use lowercase text for all column headers.
    To import only secure note data, enter the values as follows:
    • url = http://sn
    • username = leave blank
    • password = leave blank
    • extra
    • name
    • grouping
    • fav = 1 or 0
    Note: Secure note imports are limited to 45,000 characters.

    Import using the new experience

    The new import experience takes place on the same browser tab of your LastPass vault.

    1. Log in to LastPass and access the Import page by doing either of the following:
      Login method Instructions
      LastPass browser extension
      1. Select inactive LastPass icon in your web browser toolbar, then enter your email address and master password and click Log In.
      2. Select active LastPass icon then go to Account Options > Advanced > Import.
      LastPass website
      1. Go to https://lastpass.com/?ac=1 and enter your email address and master password, then click Log In.
      2. Select Advanced Options > Import in the left navigation.

      Your vault displays the Step 1/3. Where are your passwords now? page.

      Note: If you see a different page, follow instructions below in Import using the previous experience.

      Import page

    2. Select Other.

      Your vault displays the Step 2/3. Export & upload page.

    3. Under Upload the exported file to LastPass, choose from the following:
      • Drag and drop the CSV file containing the passwords exported from your current password manager.
      • Select browse your computer. Browse for the CSV file on your computer, select it, and click Open.

      Your vault displays the items found in the CSV file.

      Troubleshooting: If incomplete items are detected (entries are missing a username, password, and/or URL), select next to the affected item (under the Data Status column), then enter the missing information and select Save.

    4. By default, all items are selected for import. If desired, make the following changes:
      • De-select items you don't want to import.
      • If you want to create duplicate items (by importing items with the same username, password, and URL that already exist in your vault), enable the Select all duplicates setting at the bottom of the list.
    5. Select Import All.

      Items to be imported

    Results: Your data has now been imported into your LastPass vault.

    Import using the previous experience

    The previous import experience opens in a new browser tab.

    1. Log in to LastPass and access the Import page by doing either of the following:
      Login method Instructions
      LastPass browser extension
      1. Select inactive LastPass icon in your web browser toolbar, then enter your email address and master password and click Log In.
      2. Select active LastPass icon then go to Account Options > Advanced > Import.
      LastPass website
      1. Go to https://lastpass.com/?ac=1 and enter your email address and master password, then click Log In.
      2. Select Advanced Options > Import in the left navigation.

      The Import page opens.

      Note: If you see a different page, follow instructions in Import using the new experience.

      Import page in previous experience

    2. Use the drop-down menu to select Generic CSV file.
    3. Select Choose file, then select your desired CSV file and click Open.
    4. When prompted with the warning about items being imported directly into a shared folder as unsupported, click OK.
    5. Click Upload.

      The items found in the CSV file are displayed.

    6. Choose from one of the following options:
      • Select the data you want to import, then click Import Selected.
      • Click Import All to import everything in your CSV file.

      Note: If you want to exclude items with the same username, password, and URL that already exist in your vault, enable Remove duplicate items.
      Note: Incomplete items (entries that are missing a username, password, and/or URL) will be omitted from the import (this is indicated by a note in the Notes column).

      Items to be imported

    Results: Your data has now been imported into your LastPass vault.
    Related Articles