Importing CSV, JSON, and Excel files — automatic type detection, preview, and per-user quotas
Upload CSV files with automatic delimiter detection and column type inference. Preview the data before import. Map columns to database types and load directly into DuckDB for analysis.
Import JSON files — both flat arrays of objects and nested structures. Nested objects are flattened into columns. Arrays of objects become separate tables.
Import .xlsx and .xls files. Each worksheet becomes a separate table. Automatic type detection for dates, numbers, and text.
Admins can set per-user limits: maximum number of files held by upload, and maximum size of a single upload file. These are configured in Admin → Setup → Limits. The system also supports soft deletion — old uploads can be discarded via the bin icon in the update history.
| Format | Extensions | Stored In | Type Detection |
|---|---|---|---|
| CSV | .csv, .tsv | DuckDB | Automatic |
| JSON | .json | DuckDB | Automatic |
| Excel | .xlsx, .xls | DuckDB | Automatic |