# Import Text File (.csv, .xls, .tsv)

## Import Instructions Keeper can import your logins and passwords from a text file (.csv, .xls., .tsv). 1. To begin, from the **Account Dropdown Menu**, click **Settings**.

2. Click **Import > Import** (next to "Use Another Source").

3. From the dropdown menu, select **Text File (.csv, .xls, and .tsv)**, then click **View Instructions**. Keeper's CSV import method supports advanced structure including folders, subfolders, shared folders and any number of custom fields.

4. Once you have created the export file per the instructions, drag-and-drop the file onto Keeper's "Drop a File Here" window or browse for the file on your computer. Check the box if your file includes column headers, otherwise, the first row will be treated as data.

5. Once you have imported your credentials using one of the methods above, you can customize how you would like the information to appear in your vault in the field mapping screen. Here you'll see standard field names across the top that “map” to the data below for each Keeper record. To adjust these mappings: * Click any field to open a dropdown menu * Select the appropriate field name from the list. Repeat this process across each column as needed * Click **Next** to finalize your selections.

6. Next, a summary screen will display a preview of your vault, showing the folder structure of your imported records. Here you can adjust the folder structure and click into individual records to preview their details before finalizing the import. Click **Confirm Import** to complete the import process.

Once the import is complete, we highly recommend that you delete any unencrypted password files from your computer and disable any old password managers.

## Troubleshooting * If you only wish to share some of the folders, you will need to split the CSV file into two separate files prior to importing each accordingly. * If you are getting corrupted characters in the import, ensure that the CSV file was saved/exported using UTF-8 or Unicode encoding. *** ## Advanced Field Mapping Keeper's CSV import method also supports advanced structure including **Folders**, **Subfolders, Shared Folders, and any number of Custom Fields (CustomFieldName,CustomFieldValue).** {% code title="Order of fields in CSV File" overflow="wrap" fullWidth="true" %} ``` Folder,Title,Login,Password,Website Address,Notes,Shared Folder,CustomField1Name,CustomField1Value ``` {% endcode %}

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	Google 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

• To specify Subfolders, use backslash "\\" between folder names\ • To make a Shared Folder specify the name or path to it in the 7th field 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 Type can be defined using custom field name $type

Here is a list of all possible field types (including custom fields):

**Example 1: Create a regular folder at the root level with 2 custom fields** ``` My Business Stuff,Twitter,marketing@company.com,123456,https://twitter.com,These are some notes,,API Key,5555,Date Created,2018-04-02 ``` **Example 2: Create a shared subfolder with edit and re-share permission, inside a regular folder** ``` Personal,Twitter,craig@gmail.com,123456,https://twitter.com,,Social Media#edit#reshare ``` **Example 3: Create a shared folder with edit and re-share permission on the outside and a nested folder tree underneath.** ``` Personal\Financial\Home,Chase,craig@gmail.com,123456,https://chase.com,,Family Records#edit#reshare ``` In this 3rd example, the outer shared folder is called "Family Records" and underneath is a folder tree. The record is added to the nested folder 3 levels down. To preview the import structure, drag and drop the file into the Import screen and click **Next**. ## Notes for Managing Folders and Subfolders A Folder, Subfolder (nested folder) and Shared Folder are objects that are created independently of records. Folders are often used to categorize records of a similar type. Keeper's implementation of folders is powerful and flexible and includes ease-of-use functionality such as drag-and-drop. * A folder is a container of records and record references (shortcuts). * A shared folder is a container of records, with flexible user and team sharing capability. * A folder can be made up of personal records, shared records or other regular subfolders. * Subfolders can be either shared or personal. * You can create an unlimited number of folders and shared folders. * A shared folder can be made up of an unlimited number of subfolders, each subfolder beneath a shared folder retains the permissions of the parent. * There is no limit to the folder tree depth. * Folders and subfolders contained within shared folders will inherit the permission of the shared Folder. * A shared folder with just one user (nothing shared to anyone) is still a Shared Folder. * A shared folder does not have to be shared with anyone else. ## Record Permissions The permissions of records within a Shared Folder can be individually controlled with the following two permissions: * **Can Edit -** when this permission is enabled, the record can be edited by **any user** with the shared folder. * **Can Share** **-** when this permission is enabled, records can be shared by **any user** with the shared folder. Keeper also supports advanced JSON structured file formats. We recommend using JSON files for import and export of structured data instead of CSV files. This is described in the [JSON Import page.](https://docs.keeper.io/en/user-guides/import-records-1/import-json) ## Commander CLI Import The [Keeper Commander CLI](https://docs.keeper.io/keeperpam/commander-cli/command-reference/import-and-export-commands/import-export-commands) supports more advanced import capabilities with CSV and JSON files.