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

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

Note: This requires installation of the binary component.

  1. Click the LastPass icon in your web browser toolbar.
  2. Navigate to one of the following (based on your view):
    • Go to More Options > AdvancedImportGeneric CSV File.
    • Go to Account OptionsAdvanced > ImportGeneric CSV File

      Note: If you are prompted to copy/paste the data instead of selecting a file on your computer, please install the Binary Component via the LastPass Universal Installer for your specific device.

  3. Select your desired CSV file, then click Import.

    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.

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. Click More Options in the left navigation.
  3. Go to AdvancedImport.
  4. Use the drop-down menu to select Generic CSV file.
  5. Select your desired CSV file, then click Import.

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?