Import & Export

CSV Import

Import data from a CSV file into a new table or append to an existing one.

Into a new table

1. Click Import in the toolbar
2. Upload your CSV file
3. TinyTables auto-detects columns and data types
4. Review the column mapping; adjust names and types if needed
5. Click Import to create the table with all data

Into an existing table

1. Open the target table
2. Click Import in the toolbar
3. Upload your CSV file
4. Map CSV columns to existing table columns
5. Unmapped columns can be skipped or added as new columns
6. Click Import to append rows

Import tips

• Headers required: the first row must be column headers
• UTF-8 encoding: use UTF-8 for international characters
• Date formats: ISO 8601 (2026-01-15) works best; other formats may need manual mapping
• Select fields: values must match existing options exactly (case-sensitive)

CSV Export

Export your table data to a CSV file.

1. Click Export in the toolbar
2. Select columns: check which columns to include (default: all)
3. Preview the first few rows
4. Click Download to save the CSV file

Export respects your current view settings. If you have filters or sorts applied, only the visible/filtered data exports.

Excel (XLSX) Export

Export to Excel format:

1. Click Export → Excel
2. Same column selection and preview as CSV
3. Download as .xlsx file

Excel export preserves formatting and data types better than CSV for numbers, dates, and multi-select values.