Rules for formatting imported text files
Despite widespread adoption, unfortunately, there is no single standard that defines how a CSV file should be created. We have tried to adopt the most universal standard used, and for the most part, if you create your CSV files using popular spreadsheet applications such as Microsoft Excel, Open Office, or Apple Numbers, you should be able to import the files without too much difficulty.
For data sourced from other locations, you may need to modify data from some applications in a text editor before importing to ensure it conforms with the following rules.
We support importing any of the following files:
- Comma-separated values (CSV) files with ASCII or UTF-8 encoding (see below)
- Tab-separated values (TSV) files with ASCII or UTF-8 encoding (see below)
Imported files must have one of the following file extensions:
Internal file rules
- The file can include a single header line of text that provides a label for each column.
- This is optional, but recommended, as it will make it easier to configure import settings.
- This line must observe the same rules as listed below for data lines
- One record is entered per line.
- Newlines within a record are allowed, provided the field is surrounded by straight double quotes (see below).
- The fields within each record must be delimited with either commas or tabs.
- You must be consistent with this choice throughout the file. Do not switch between commas and tabs, as only one will be recognised.
- Each record should contain the same number of fields/delimiters.
- It is acceptable to leave some fields empty, but their delimiters should remain intact.
- Any field values that include delimiters (comma or tab, depending on what is used) or new lines must be included in straight double quotes (").
- It is best practice, but not required, to enclose all fields with these quotes
- Curly quotes must not be used when surrounding values.
- Any double quotes within field values must be escaped by placing a second double quote next to the first. For example, the text value:
She said "It's me!"Would need to be written as:
"She said ""It's me!""
Converting to UTF-8 format
Mac OS X
- Hold down the Alt key and click on the File menu.
- Choose Save As…
- In the save dialog, change the Plain Text Encoding dropdown, choose Unicode (UTF-8).
- Open the file in Notepad++.
- Click on the Encoding menu, and choose your current file encoding by choosing Encode in XXX.
- Open the Encoding menu again, and choose Convert to UTF-8.
- Save the file (you can use Save As and change the file name if you wish).