All free flows

CSV Cleanup & TSV Export

Remove empty and duplicate rows, then export a clean tab-separated table.

Cleanup and TSV export run locally in your browser. No files or generated output are uploaded. Reset or exit clears the session.

This flow needs JavaScript. If it does not load, refresh the page and try again.

About this flow

Prepare a table for a tab-separated import: remove entirely empty rows, keep the first exact duplicate, and export TSV. Choose the actual source delimiter and inspect the intermediate CSV or TSV before downloading the final TSV.

Limitations

  • The first row remains the header. Whitespace-only rows are retained; exact duplicate comparisons preserve case and whitespace.
  • The final TSV quotes every cell and uses CRLF line endings. Quoted tabs and newlines remain part of their original cells.
  • Final formula protection preserves complete bounded signed decimal/exponent numbers and adds an apostrophe to formula or control-prefixed expressions. CSV/TSV imports may infer types; import identifier columns as text. Protection OFF retains literal expressions with spreadsheet execution risk.
  • Original and downstream inputs must fit the 5 MiB processing limit; a final TSV may grow up to 20 MiB.
  • Use UTF-8 text with a consistent number of fields per row. Ragged rows and malformed quoting fail before processing; blank physical lines in a multi-column table must be represented as correctly shaped empty records.
  • A table may contain up to 50,000 data rows, 500 columns and 500,000 cells. Processed files quote every cell and use CRLF record separators.