Data workbench

TSV Editor, Formatter & Validator

Edit tab-separated data in a clear grid, find uneven rows, clean columns, and export a consistent TSV locally.

Local by defaultYour input stays in this browser tab.
TSV Editor, Formatter & Validator Processed locally
Input0 B
Table actions
Editable gridNo rows match this view.

Basics

Understanding the format

TSV is a plain-text table format in which tab characters separate fields and line breaks separate records.

Tabs reduce the need to quote values containing commas, but embedded tabs, newlines, and quotes still need correct escaping.

What it does

What this tool does

The TSV workspace uses the same reliable table engine as the CSV editor with tab-safe defaults, direct cell editing, diagnostics, cleanup, and export.

Tab-aware grid

Paste from spreadsheets and inspect each tab-delimited field.

Structure checks

Locate uneven records, missing cells, and ambiguous headers.

Table cleanup

Sort, filter, trim, fill, truncate, transpose, and edit cells.

Predictable export

Download UTF-8 TSV with explicit line-ending control.

How to use

How to use it

  1. Add TSV

    Paste tab-separated text, open a .tsv file, or load the sample.

  2. Parse

    The tab delimiter is selected by default; review row and column counts.

  3. Correct data

    Edit the grid or run focused cleanup actions, with one-step Undo.

  4. Export

    Copy or download the normalized TSV and test it in the destination application.

Errors & limits

Common errors and limits

Spaces instead of tabs

Columns that look aligned may contain spaces and parse as a single field.

Missing trailing values

Rows ending early are reported so they can be filled deliberately.

Embedded tabs

Values containing tabs must be quoted to remain one field.

Review

A visually aligned text file is not necessarily TSV. Confirm that real tab characters separate fields, and review applications that replace tabs with spaces.

FAQ

Frequently asked questions

What is the difference between CSV and TSV?

They use the same table model but CSV normally uses commas while TSV uses tab characters.

Can I paste from Excel or Google Sheets?

Yes. Copied spreadsheet ranges usually arrive as TSV and can be edited directly.

Are empty cells preserved?

Yes. Empty fields remain present and can be filled or exported unchanged.

Is the file uploaded?

No. Parsing and editing happen locally in your browser.