DATA IMPORT / MAP. PREVIEW. REVIEW.

Your files.
Ready for your tables.

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

Import workflow showing a meaningful fictional customer file, worksheet controls and destination mappingsView full size ↗
Current development build · Harbour & Field Supply · Fictional demo records

CHOOSE HOW TO READ THE FILE

The right worksheet.
The right columns.

Open Browse data → Import / Export → Import data, or find Import data with Ctrl+K. Select a destination for each file and review its interpretation.

Read it deliberately

Choose the Excel worksheet and header row. For delimited text, set delimiter, encoding and explicit NULL tokens.

Keep the mapping

Map source fields to destination columns, exclude fields deliberately and save reusable mapping templates.

See the destination

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.

Set the order.
Follow each file.

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.

Bring the files. Keep the decisions.

Free for everyday SQL. 40 days of Pro included automatically for new Windows users. Optional Pro is £7.50/month.

Check download availability ↗
Download SQL OceanAlways free