a apiary.
← All tools

CSV & Data / BROWSER UTILITY

CSV to SQL INSERT

Map delimited columns to escaped SQL INSERT batches for five database dialects.

Processed locally in your browser. Your data is not uploaded.

First row contains headers. Choose delimiter, columns, names and types explicitly. Empty-to-NULL means exactly empty cells. Oracle uses INSERT ALL; other dialects use multi-row VALUES. Batches: 1–100 rows; total: 2,000 rows, 50 columns. Dates remain text for explicit database conversion; raw expressions are unsupported. SQL is generated, never executed.

Processed in your browser. Input limit: 100,000 characters (XPath: 50,000); output limit: 1,000,000 characters; query and regex limit: 2,000 matches. Larger inputs should be split into smaller files.

Read locally as UTF-8. Maximum 100,000 characters (XPath: 50,000). Files are not sent anywhere.

First row contains headers. Read columns again after changing source data or delimiter.

IncludeColumn nameValue typeEmpty to NULL

Send output to…

Transfers stay in memory on this site. The destination does not run automatically. Copy is available if the new tab is blocked.

Good to know

First row contains headers. Choose delimiter, columns, names and types explicitly. Empty-to-NULL means exactly empty cells. Oracle uses INSERT ALL; other dialects use multi-row VALUES. Batches: 1–100 rows; total: 2,000 rows, 50 columns. Dates remain text for explicit database conversion; raw expressions are unsupported. SQL is generated, never executed.

Example: Use Try an example for fictional Record and Code values.