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.

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 this template. Fill the columns with the values you’d like for each entry (leave blank if the value is not relevant).

Note: 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:

  • 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)

About importing only sites

To import only site data you must define at least the following values:

  • url
  • username
  • password
  • name
  • extra
  • grouping
  • fav = 1 or 0

To ensure accuracy of your columns, please see our generic CSV sample import format in our template.

About importing only secure notes

Note: Secure note imports are limited to 45,000 characters.

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

It is important to leave the username and password columns blank. Please refer to the secure note sample import formats in our template.

Import using the LastPass web browser extension

  1. Click the inactive LastPass icon in your web browser toolbar.
  2. Enter your username and Master Password, then click Log In.
  3. If prompted, complete steps for Multifactor Authentication (if enabled).
  4. Click the LastPass icon in your web browser toolbar.
  5. Navigate to one of the following (based on your view):
    • Go to More Options > AdvancedImport.
    • Go to Account OptionsAdvanced > Import.
  6. Use the drop-down menu and select Generic CSV File.
    • If you have the binary component installed, click Import, then select your desired CSV file and click Open.
    • If you do not have the binary component installed, copy the contents of your generic CSV file, then paste it into the Content field and click Upload.
  7. When prompted with the warning about items being imported directly into a shared folder as unsupported, click OK.
  8. 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.

Your data has now been imported into your LastPass Vault.

Import from within the LastPass Vault

  1. Log in to LastPass and access your Vault by doing either of the following:
    • Go to https://lastpass.com/?ac=1 and log in with your username and Master Password.
    • In your web browser toolbar, click the LastPass icon LastPass then click Open My Vault.
  2. If prompted, complete steps for Multifactor Authentication (if enabled).
  3. Click More Options in the left navigation.
  4. Go to AdvancedImport.
  5. Use the drop-down menu to select Generic CSV file.
    • If you have the binary component installed, click Import, then select your desired CSV file and click Open.
    • If you do not have the binary component installed, copy the contents of your generic CSV file, then paste it into the Content field and click Upload.
  6. When prompted with the warning about items being imported directly into a shared folder as unsupported, click OK.
  7. 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.

Your data has now been imported into your LastPass Vault.

Autofilling after import

Once imported, you might notice that some websites do not autofill right away. This is because LastPass needs to “see” the website in order to capture the exact username and password fields, as they differ from website to website. When you visit the website for the first time after importing, use the Field icons to force fill the credentials and log in. It will autofill every time after that.

Related

How do I import passwords from other sources into LastPass?