# CSV Import

## 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. {% code title="myimport.csv" overflow="wrap" %} ```csv Folder,Title,Login,Password,Website Address,Notes,Shared Folder,Custom Field1 Name,Custom Field1 Value,Custom Field2 Name,Custom Field2 Value ``` {% endcode %}

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

{% hint style="info" %} Custom fields begin with the name in the 8th field, (column H). The custom field value goes in the next field (column I). {% endhint %} * 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. {% code overflow="wrap" lineNumbers="true" fullWidth="true" %} ``` Business,Twitter,marketing@company.com,password,https://twitter.com,Some interesting notes!,,API Key,"131939-AAAEKJLE-491231$##%!",Date Created,2018-04-02 Subfolder1,Twitter,craig@gmail.com,xwVnk0hfJmd2M$2l4shGF#p,https://twitter.com,,Social Media\Customer1#edit#reshare Subfolder2,Facebook,craig@gmail.com,TycWyxodkQw4IrX9VFxj8F8,https://facebook.com,,Social Media\Customer2#edit#reshare ,Google Dev Account,mydevaccount@gmail.com,"8123,9fKJRefa$!@#4912fkk!--3",https://accounts.google.com,"Google Cloud ID 448812771239122 Account Number 449128 This is multi-line",Shared Accounts#edit#reshare,2FA Phone Number,+19165551212 ``` {% endcode %} To import this file as "login" records: ``` keeper import --format=csv --login-type test.csv ``` The resulting vault will look like this:

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	user@example.com	liu.W241Q<q$RGl9r;N1	www.google.com	main google account	TeamFolder	$oneTimeCode	otpauth://totp/?secret=ABC123ABC123ABC123ABC123ABC123	$type	login	$host	10.0.0.1	$url	www.example.com

All Field Types that can be used as Custom Field Name $oneTimeCode

More advanced import options are available using the [JSON Import](/en/keeperpam/commander-cli/command-reference/import-and-export-commands/json-import.md) format described in the next section. --- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://docs.keeper.io/en/keeperpam/commander-cli/command-reference/import-and-export-commands/csv-import.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.