All data imported to and exported from Storage has to be in the CSV format.
In many cases, our extractors and writers take care of the necessary conversion, but sometimes you have to be aware of the supported formats — for example, when you are loading data manually.
Storage accepts CSV files in the format defined by RFC 4180 Specification. This is basically compatible with CSV exports from OpenOffice Calc, MS Excel, and Google Drive.
|line without enclosure||second column|
|column with enclosure “, and comma inside text||second column enclosure in text “|
|column with backslash \ inside||column with backslash and enclosure "|
|column with \n \t \||second col|
col1,col2 line without enclosure,second column "column with enclosure "", and comma inside text","second column enclosure in text """ "columns with new line",columns with tab column with backslash \ inside,"column with backslash and enclosure \""" column with \n \t \\,second col
A CSV file in this format can be exported from
Because Microsoft Excel does not support UTF-8 encoding very well, it is a bit tricky to
export data correctly. There are a
number of options,
but without using any non-standard Windows tools, the quickest is to save the Excel sheet as
Unicode Text (*.txt)
This will produce a tab-delimited file in UTF-16 encoding, which you can convert in Windows
Notepad. Simply open the file, and without making any modifications, save it with
UTF-8 encoding (and .csv extension):
The resulting file
import-data.txt.csv can now be imported into KBC Storage as a tab delimited file.
Note: as along your data do not contain any non-ASCII characters, you can simply save them as CSV.
When you export a table from Storage, the same format is used for import:
The above format is again compatible with many applications; you can
Note: The rows are exported in random order and there is no way to specify ordering of rows in the exported file.
The easiest way to import the CSV file exported from KBC into Microsoft Excel is by starting Excel and opening a blank workbook. Then use the Data – From Text function and select the exported file:
An import wizard will start. On its first screen, make sure you have selected the delimited file and Unicode UTF-8 encoding:
On the next screen, make sure that only the comma delimiter is selected:
However, using this method, Excel is not able to import new lines contained in table cells. If you need that, you have to use a more complicated approach.