Comment on page

CSV Import

Automatic migration of passwords from a CSV file

Commander CSV Record Import

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.