Working with CSV
Skyvia uses CSV files for data-related tasks. CSV files may use different format options to define the file structure. This article highlights the possible CSV formatting by describing each CSV option separately.
CSV separator is used to divide the fields in the row from each other.
- Comma (,) — most commonly used;
- Semicolon (;);
- Slash (/);
- Vertical bar (
Text qualifier is a character that encloses values in the CSV files. It defines the stating and the ending points of the values.
- empty string
- single quotation mark (‘)
- double quotation mark (“).
The field value may contain a comma. The comma may be recognized as a field separator. Text qualifier will define this comma as a part of the value, not the separator.
Row delimiter is a character or a set of characters that separates data rows in the CSV files:
CRLF — a carriage return-line feed combination. Is used in Windows OS. The default value for Export packages and Query Advanced Export in Skyvia. CR — carriage return (MAC pre-OSX). LF — line feed (Linux, Mac OSX).
When importing a CSV file, Skyvia tries to detect the Row Delimiter automatically.
The CSV file locale name determines locale settings including DateTime format, number format, string collation, currency format, etc.
If you export the CSV file with the default locale value “English (United States)” the date-time field value will match PC regional settings and have the following format:
If we select another locale value, for example, “English (Canada)”, we get the same date values in the following format:
The locale also dictates the delimiter used between data values in the CSV file.
If you select the locale, which uses a comma as a decimal separator, the CSV file data values will be separated by a semicolon.
The default locale value in Skyvia is determined by the browser settings (preferred language). Check Data Types and Limitations for more information.
This option determines how the source values will be interpreted in the CSV file. By default, Skyvia uses UTF-8 which can encode all of the possible character code points in Unicode.
If the source field value contains special characters from different languages, you can select the UTF-8 code page value, and keep all the values in the result CSV file.
If you select another option, Cyrillic (Windows) , only the Cyrillic characters will be parsed in the result file:
CSV Opportunities in Skyvia
Importing, Extracting from CSV Files
Exporting, Loading to CSV Files
CSV files could be used as the Target for Export and Data Flow packages. CSV files could be downloaded manually to your PC or automatically to the available storage services. You can also download query results into a CSV file in Skyvia Query.