Convert TSV to MySQL SQL

How to convert a TSV file to MySQL

A TSV file is a CSV with tabs instead of commas — common from spreadsheet exports, mysqldump --tab, and data pipelines. SQLified detects the tab delimiter automatically and writes a clean CREATE TABLE + INSERT script you can run in any MySQL client, with no file access required.

1. Drop your TSV onto the converter above (.tsv, .tab, or tab-delimited .txt).
2. Review the schema. SQLified infers MySQL types and adds an auto-increment key. Adjust types, nullability, rename columns, or set your own primary key.
3. Generate the SQL — a CREATE TABLE plus batched INSERT statements.
4. Run it in MySQL Workbench, the mysql CLI, or phpMyAdmin.

What the generated SQL looks like

CREATE TABLE IF NOT EXISTS `events` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `event` TEXT NOT NULL,
  `occurred_at` DATETIME NOT NULL,
  `value` DECIMAL(18,2) NOT NULL,
  PRIMARY KEY (`id`)
);

INSERT INTO `events` (`event`, `occurred_at`, `value`) VALUES
('login', '2026-01-04 08:12:00', '0.00'),
('purchase', '2026-01-04 08:15:30', '49.99');

Identifiers are backtick-quoted, and when your data has no key, SQLified adds an AUTO_INCREMENT id so every row is uniquely identified.

MySQL type inference

• Whole numbers → INT / BIGINT (by range).
• Decimals → DECIMAL(18, n).
• Dates and timestamps → DATE / DATETIME.
• true/false → TINYINT(1).
• Everything else → TEXT.

Large files and max_allowed_packet

MySQL refuses any statement bigger than max_allowed_packet (commonly 4–64 MB). A single giant INSERT for a big tab-delimited export hits that wall. SQLified batches the output into 1,000-row statements, so each stays well under the limit and even multi-million-row files import without tuning.

Frequently asked questions