Convert SQL to TSV

Want to convert SQL file to TSV file?

If you want to export SQL Server to TSV, see this page: SQL Server to TSV.

If you want to export SQLite to TSV, see this page: SQLite to TSV.

Try Withdata Data File Converter, a desktop SQL to TSV converter for Windows, MacOS, and Linux, Convert SQL to TSV, Easy and Fast.

• Can run in GUI mode, Step by Step, just a few mouse clicks.
• Can run in Command line, for Scheduled Tasks and Streams.
• Convert files locally and privately, avoid uploading large SQL file(s) to online services.
• Support Windows, Linux, and macOS.

Download DataFileConverter
Windows 64 bit
Windows 32 bit
Linux .deb (For Debian, Ubuntu) 64 bit
Linux .rpm (For Red Hat, Fedora, SUSE) 64 bit
MacOS 64 bit

Convert SQL to TSV

Choose SQL file -> Set TSV file -> Convert SQL to TSV

“Start a New Convert” for “SQL to TSV”.

Select From “File” “SQL” To “File” “TSV”.

1. Open source SQL file.

Support large SQL file ( > 4GB ).

Source SQL file’s content is like this:

2. Config target TSV file.

3. Set rows options.

4. Convert SQL to TSV.

After converting, you can view the output TSV file.

---

More about SQL to TSV converter

See Video: Convert SQL file to TSV file in a few clicks

See also:

• Merge multiple SQL files into one TSV
• Batch convert SQL files to TSV files

SQL → TSV reference

Type mapping

Value kind	in SQL	in TSV
Int	INT	1234
Bigint	BIGINT	9007199254740993
Decimal	DECIMAL(p,s)	1234.56
Float	DOUBLE PRECISION	1.234e+10
Text	VARCHAR(n)	unquoted; a tab in the value splits the column
Long text	TEXT / CLOB	unquoted; newlines break the row
Date	DATE	2026-09-18
Datetime	TIMESTAMP	2026-09-18 14:30:00
Binary	BLOB / BYTEA	not representable
Boolean	BOOLEAN / SMALLINT	TRUE / FALSE
JSON	JSON / TEXT	the whole JSON value as-is (its own quotes stay)

Dialect differences

Both SQL and TSV are file formats, so what differs below is how each one chooses to represent a value.

Property	in SQL	in TSV
identifiers	Two competing conventions: single-quoted literals and diale...	Rarely used, which is exactly why tabs in data break it
dates	Depends on the dialect: DATE literals, TO_DATE(), or plain ...	Conventional text: 2026-09-18 or 2026-09-18 14:30:00
binary	Dialect-specific: X-quoted literal, 0x hex, or decode()	Not supported - must be encoded
separator	Statement terminators (;)	Tab
encoding	No declaration	No declaration - UTF-8 works only with a BOM
typing	Types belong to the target database, and they differ betwee...	None - every field is text
shape	Statements; a dump usually means CREATE TABLE plus INSERT rows	Flat table, optional header row
ceiling	No formal limit, but a single INSERT statement has to fit i...	No formal limit

Convert SQL to TSV the easy way

Use the SQL to TSV converter — an offline desktop app for Windows, macOS and Linux. Nothing to upload, large files and batch runs supported (free trial).

New to the format? Read what a TSV file is (and how it differs from CSV).