Kexi/Handbook/References/Supported File Formats/Comma-separated Values Format: Difference between revisions
(Created page with "<languages/> <translate> ===Comma-separated Values Format (CSV)=== <!--T:2--> <!--T:3--> '''Kexi''' is capable of importing and exporting data from/to a variety of Comma-sep...") |
m (KEXI uppercase) |
||
| Line 5: | Line 5: | ||
<!--T:3--> | <!--T:3--> | ||
''' | '''KEXI''' is capable of importing and exporting data from/to a variety of Comma-separated values formats (CSV files). Most spreadsheet and database applications can import and export in this format, making this an appropriate format to migrate textual data between different applications. | ||
<!--T:4--> | <!--T:4--> | ||
''' | '''KEXI''' also supports a number of options that can be configured before performing import: | ||
<!--T:5--> | <!--T:5--> | ||
| Line 38: | Line 38: | ||
<!--T:14--> | <!--T:14--> | ||
On importing ''' | On importing '''KEXI''' shows preview of imported data. Most suitable set of options is auto-detected by '''KEXI''' based on provided CSV file. | ||
<!--T:15--> | <!--T:15--> | ||
Latest revision as of 02:29, 20 December 2024
Comma-separated Values Format (CSV)
KEXI is capable of importing and exporting data from/to a variety of Comma-separated values formats (CSV files). Most spreadsheet and database applications can import and export in this format, making this an appropriate format to migrate textual data between different applications.
KEXI also supports a number of options that can be configured before performing import:
- data type for each column,
- other field delimiters such as tabs,
- different text quotes,
- given number of records can be skipped if needed,
- duplicated delimiters can be skipped,
- values from the first row can be used to set column names,
- text encoding (UTF-8 is the default),
- date format (defined by the operating system is the default),
- stripping leading and trailing blanks off of the text values.
On importing KEXI shows preview of imported data. Most suitable set of options is auto-detected by KEXI based on provided CSV file.