Developer Resources

How to create a 1Password compatible CSV file

You can create and edit a CSV file to import data into 1Password from other programs.

Tip

1Password has built in support for importing data from several password managers.

Get started

CSV (comma-delimited text) files are a simple, efficient way to import information into 1Password in bulk. Each record in a CSV file corresponds to an item in 1Password. A CSV file can contain multiple records, but each file can only contain records for one type of item. Here’s one with two Login items:

Bank,https://bank.com/,wendy,8Q396b9D68,123 Front Street
Twitter,https://twitter.com/,wappleseed,68nV99oLHhzX,

All records in a CSV file must have the same number of fields. In the above example, the record for “Twitter” doesn’t contain any notes, but it still has an empty field in the same position as the notes field of the first record.

1Password.com can only import Login items. 1Password for Mac can import Logins, Credit Cards, Software Licenses, and Secure Notes.

After you create your CSV files, import them into 1Password.

Item types and fields

Login

title,website,username,password,notes,custom field 1,custom field 2, custom field …

Example record:

Amazon.com,https://amazon.com/,wendy_appleseed,password123

Custom fields are optional. They will appear in a section called Other Fields when you view the Login item in 1Password.

Credit Card

title,card number,expiry date (MM/YYYY),cardholder name,PIN,bank name,CVV,notes

Example record:

VISA,1234 5678 9012,05/2018,Wendy Appleseed,1234,TD,123,Limit: $1000

Software License

title,version,license key,your name,your email,company,download link,software publisher,publisher's website,retail price,support email,purchase date,order number,notes

Example record:

1Password,4,ABCD-123-4567,Wendy Appleseed,,,agilebits.com/download,AgileBits,agilebits.com,$49.99,support@1password.com,,,Awesome app!

Secure Note items

title,text of note

Example record:

A Tale of Two Cities,"It was the best of times, it was the blurst of times"

The text of the note should be enclosed in quotation marks if it contains commas, line breaks, or other punctuation.

Published: