Import Data
Import local files into BigQuery with automatic schema detection.
Supported Formats
| Format | Extensions |
|---|---|
| CSV | .csv (auto-detects delimiter) |
| Excel | .xlsx, .xls (multi-sheet support) |
| JSON | .json (arrays or NDJSON) |
| Parquet | .parquet |
How to Import
- Drag and drop a file anywhere in Querylab.io
- Right-click a dataset → Import CSV
- Command Palette (
Cmd/Ctrl+K) → "Import Data"
Workflow
- Select file - drop or browse
- Review schema - columns and types detected automatically
- Edit columns - rename, change types, reorder
- Configure - choose destination, write mode, partitioning
- Import - uploads directly to BigQuery
Write Modes
| Mode | Behavior |
|---|---|
| Create | New table (fails if exists) |
| Append | Add rows to existing |
| Overwrite | Replace all data |
Cost
BigQuery Load Jobs are FREE.