This documentation page assumes that you already have a SeekTable account.
How to import CSV file
CSV file is a simplest data source in SeekTable: it is enough to click on Upload Data, choose a local file,
and wait until file is uploaded. That's all.
No setup needed; all parameters are detemined automatically:
- CSV separator: comma, semicolon, pipe or tab.
- File encoding: UTF-16, UTF-8, Windows-1252, Windows-1251/KOI8-R (Cyrillic), Windows-1253 (Greek), ISO-2022-JP, ISO-2022-KR, ISO-2022-CN and others.
- First row should contain column names. If your CSV file doesn't contain headers row you need to add it.
- Known data types: string, number, date.
- For number columns sum/average/min/max measures are suggested.
- For date columns 3 dimensions (year, month, day) are suggested.
- Columns with unique values (like ID) are excluded from dimensions. You can add them explicitely if needed.
CSV file may be compressed with zip or gzip, and this is only option if you want to upload large CSV file greater than upload limit (50Mb).
Uncompressed CSV size might be up to 500Mb; SeekTable works fine with files of this size and pivot table generation should not take more than 5-10 seconds.
Refresh CSV data
If you saved some pivot table reports you might need to refresh them by uploading newer version of CSV file. This is possible in the following way:
- Determine ID of CSV-based cube you want to refresh: it is present in the address bar, for example:
In this case cube ID is
- Rename new CSV file: use ID as file name. For example:
feb3828c57474791a5ee92b83d4195e0.zip (if CSV file is zipped)
- Upload renamed file in a usual way (with Upload Data button).
- Instead of creating new cube SeekTable will replace old CSV file with a new version. All saved reports will be refreshed.
Note: Refresh is possible only if new CSV contains all columns (with the same names) present in old CSV file (new columns are ok).
Analyze very large CSV file
In case if you want to create a pivot table by CSV file that exceeds upload limit (even zipped) you still can do that in one of the following ways:
- Download trial version of PivotData Microservice,
run it on your computer and configure for your local CSV file(s) as data source.
Pivot table generation by 1GB file might take up to 10-15 seconds. As alternative,
you can convert CSV file to SQLite database file
and configure it as data source for the microservice (you can add some indexes to significantly improve reports generation speed).
- Import CSV file into SQL database, and then use this DB as a data source in SeekTable.
Hint: ClickHouse engine is very fast, and it can provide access to many-GB CSV file as database table (without import) with table engine = FILE.