When creating or editing an Import task, importing data from a CSV file, or an Export package you can specify CSV options.
You can specify the following parameters:
A column separator. Can be a comma (,), a semicolon (;), a slash (/), or a vertical bar (|). By default, comma is used as a column separator. You can also enter a custom value to this box.
A character that encloses values in the CSV files. Can be an empty string (no text qualifier), a single quotation mark (‘), or a double quotation mark (“). The text qualifier is used to differentiate your field data from your delimiter. For example, when CSV file column values contain commas, and commas are used as CSV separators, values must be enclosed in the text qualifier characters, to avoid parsing commas in values as the end of the value.
A character or character combination that separates data rows in the CSV files. Can be set to the following values:
CRLF — a carriage return-line feed combination. Default value for Export packages.
CR — carriage return.
LF — line feed.
When importing a CSV file, Skyvia tries to detect the Row Delimiter automatically.
The CSV file locale name, which determines locale settings, including datetime format, number format, string collation, currency format, etc. Default locale value is determined by the browser settings (preferred language). Check Data Types and Limitations for more information.
The CSV file character encoding.
In the Import task editor, the Columns section displays the data columns found in your CSV file. Here you can explicitly specify the data type of these columns and check whether these columns were recognized correctly. If the columns were not recognized correctly, probably it means that CSV Separator, Code Page, or Text Qualifier settings are incorrect. For example, let’s look at the following screenshot:
We can see that only one column is detected, and its name includes names of several actual columns separated with the semicolon. Columns were not correctly detected because Skyvia uses comma as CSV separator by default, and we used semicolons in CSV Separator. After we set the CSV Separator parameter to comma, the columns are detected correctly:
Column type can be automatically detected only when mapping target object column to a source column. When using expressions, you need to either specify the column types manually or use the data type casting functions in expressions. Otherwise, column values are considered strings.