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 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:

  1. Determine ID of CSV-based cube you want to refresh: it is present in the address bar, for example:
    https://www.seektable.com/cube/feb3828c57474791a5ee92b83d4195e0
    In this case cube ID is feb3828c57474791a5ee92b83d4195e0.
  2. Rename new CSV file: use ID as file name. For example:
    mydata.csvfeb3828c57474791a5ee92b83d4195e0.csv
    mydata.zipfeb3828c57474791a5ee92b83d4195e0.zip (if CSV file is zipped)
  3. Upload renamed file in a usual way (with Upload Data button).
  4. 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: