Comment on page
CSV Import
Automatic migration of passwords from a CSV file
Keeper Commander supports .csv text file import using comma separated values. CSV import files can contain data for certain fields, folders, subfolders, shared folders and default shared folder permissions.
Use this order of fields shown below with commas separating each value (and no spaces around the commas). Not all fields are required; some can be left blank.
myimport.csv
Folder,Title,Login,Password,Website Address,Notes,Shared Folder,Custom Field1 Name,Custom Field1 Value,Custom Field2 Name,Custom Field2 Value
Position | Column | Value | Description / Format |
|---|---|---|---|
1 | A | Folder | FolderName\Subfolder (optional) |
2 | B | Title | Name of the record (required) |
3 | C | Login (Username) | sampleuser |
4 | D | Password | samplepassword |
5 | E | Website Address (URL) | domain.com/login |
6 | F | Notes | notes about this account (optional) |
7 | G | Shared Folder Name | SharedFolderName (optional) |
8 | H | Custom Field 1 Name | $oneTimeCode |
9 | I | Custom Field 1 Value | otpauth://totp/?secret=ABC123ABC123ABC123ABC123ABC123 |
10 | J | Custom Field 2 Name | $type |
11 | K | Custom Field 2 Value | login |
| | | |
Custom fields begin with the name in the 8th field, (column H). The custom field value goes in the next field (column I).
- To specify subfolders, use backslash "\" between folder names
- To set shared folder permission on the record, use the #edit or #reshare tags as seen below
- Enclose fields in quotes for multi-line or special characters
- Ensure files are UTF-8 encoded for support of international or double-byte characters
Below is an example csv file that showcases several import features including personal folders, shared folders, subfolders, special characters and multi-line fields.
1
Business,Twitter,[email protected],password,https://twitter.com,Some interesting notes!,,API Key,"131939-AAAEKJLE-491231$##%!",Date Created,2018-04-02
2
Subfolder1,Twitter,[email protected],xwVnk0hfJmd2M$2l4shGF#p,https://twitter.com,,Social Media\Customer1#edit#reshare
3
Subfolder2,Facebook,[email protected],TycWyxodkQw4IrX9VFxj8F8,https://facebook.com,,Social Media\Customer2#edit#reshare
4
,Google Dev Account,[email protected],"8123,9fKJRefa$!@#4912fkk!--3",https://accounts.google.com,"Google Cloud ID 448812771239122
5
Account Number 449128
6
This is multi-line",Shared Accounts#edit#reshare,2FA Phone Number,+19165551212
To import this file as "login" records:
keeper import --format=csv --login-type test.csv
The resulting vault will look like this:
CSV Import Sample
Here is a list of some record types (you may have more if you have custom record types, or less if you are restricting some record types):
Record types can be listed as a custom field value when the custom field name is $type
Below is a list of all possible field types (including custom fields). You can use these as a custom field names such as
$oneTimeCode as shown below.Folder | Title | Login | Password | Website Address | Notes | Shared Folder | Custom Field1 Name | Custom Field1 Value | Custom Field2 Name | Custom Field2 Value | Custom Field3 Name | Custom Field3 Value | Custom Field4 Name | Custom Field4 Value |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Folder1\subfolder | My Login Account | liu.W241Q<q$RGl9r;N1 | main google account | TeamFolder | $oneTimeCode | otpauth://totp/?secret=ABC123ABC123ABC123ABC123ABC123 | $type | login | $host | 10.0.0.1 | $url |
All Field Types that can be used as Custom Field Name $oneTimeCode
More advanced import options are available using the JSON Import format described in the next section.
Last modified 1mo ago