Read it deliberately
Choose the Excel worksheet and header row. For delimited text, set delimiter, encoding and explicit NULL tokens.
DATA IMPORT / MAP. PREVIEW. REVIEW.
Choose how each file is read, map its columns and inspect the rows that will arrive. Keep the destination visible throughout.
Current development features · Public download coming soon
View full size ↗CHOOSE HOW TO READ THE FILE
Open Browse data → Import / Export → Import data, or find Import data with Ctrl+K. Select a destination for each file and review its interpretation.
Choose the Excel worksheet and header row. For delimited text, set delimiter, encoding and explicit NULL tokens.
Map source fields to destination columns, exclude fields deliberately and save reusable mapping templates.
Preview mapped and converted rows with warnings and errors. Export a validation report to review the preview findings.
Changing file interpretation resets the preview. Changed source files need reload and review before importing. Defaults, triggers and database constraints still apply at execution.
SEVERAL FILES. ONE JOB.
Add and reorder CSV, TSV or Excel files with independent destinations and mappings. Review the job, then explicitly import the reviewed files.
Single CSV/TSV import is included in Free. Excel and multi-file jobs are Pro. Supported targets are PostgreSQL, MySQL, SQL Server and SQLite; MySQL requires InnoDB for transaction guarantees. Limits: 20 files / 128 MiB per job; 16 MiB, 50,000 rows, 256 columns and 1,000,000 cells per file. The destination preview shows the first 25 rows; execution validates all rows.
Free for everyday SQL. 40 days of Pro included automatically for new Windows users. Optional Pro is £7.50/month.
Check download availability ↗