Supported import formats
Spreadsheet formats
Data formats
Document formats
Specialized formats
How to import
1
Drag and drop
Drag any supported file directly into your workbook. Sourcetable auto-detects the format and imports the data.
2
Upload button
Click the upload button in the toolbar or sidebar to browse and select files.
3
AI chat
Attach a file in the AI chat to analyze it without importing to the grid. You can also ask the AI to import it.
4
Google Drive
Connect your Google Drive and import files directly from your cloud storage.
5
URL import via AI
Paste a URL in the AI chat and ask it to import the data. The AI fetches, parses, and loads the data.
Auto-detection
When you import a file, Sourcetable automatically detects:- Character encoding — UTF-8, Latin-1, Windows-1252, and other encodings
- Delimiters — comma, semicolon, tab, pipe, or custom delimiters
- Headers — whether the first row contains column names
- Data types — numbers, dates, currencies, percentages, text
- Date formats — US (MM/DD/YYYY), European (DD/MM/YYYY), ISO (YYYY-MM-DD), and other formats
Large file handling
Sourcetable uses DuckDB for streaming large files that exceed memory:- Files over 1,048,576 rows are handled with streaming queries
- Parquet files up to 10 GB can be processed directly
- The AI automatically selects the best approach based on file size
Exporting data
Export your workbook or specific sheets:AI-powered export
Ask the AI to export specific subsets or transformations:- “Export only the rows where revenue is over $10,000 as CSV”
- “Create a PDF summary report of this quarter’s metrics”
- “Export this sheet as JSON with nested objects for each department”