table.data — 4 tools ● LIVE
Input · CSV EDITABLE
NETWORK PAYLOAD: 0 BYTES · PROCESSING: LOCAL
Output · TABLE LIVE
PASTES INTO EXCEL / SHEETS AS A TABLE
Data rows0EXCL. HEADER
Columns0FIELDS PER ROW
Total fields0ROWS × COLS
Delimiter,COMMA

Developer Tools · Group 18 of 19

CSV & TSV.

Paste a table and it renders before you lift your fingers — a real spreadsheet with a pinned header, click-to-sort columns and quoted fields handled properly. Then hit Copy as table and paste straight into Excel, Google Sheets, Word or an email — it lands as a real table, not a blob of text. Flip to a formatter to normalize quoting, trim fields and ship clean output. Nothing is uploaded, nothing is stored.

  • Tools04
  • Delimiters, · tab
  • Copyas table
  • Backendnone
  • Costfree
In order, 01 → 04

Two delimiters, seen, tidied, copied.

( 01 )

Turns a wall of comma-separated text into a real table the moment it lands. The header row pins to the top, zebra striping keeps rows readable, and clicking any column header sorts — numerically when the column is numbers, alphabetically otherwise. Then Copy as table puts two formats on your clipboard at once: a tab-separated version for Excel and Google Sheets (it lands as real cells) and a styled HTML table for Word, Docs and email. This is a real parser: quoted fields keep their embedded commas, so "Armstrong, Neil" stays in one cell.

Example · view, sort, copy as table

name,missions "Armstrong, Neil",3 Buzz Aldrin,2

a live 2-column table → click "missions" to sort → Copy as table → paste into Excel and it arrives as cells, not text.

Use it for inspecting exportsspreadsheet reviewpasting into Sheetsdata QA

The same live table, reading tabs instead of commas. Because tabs almost never appear inside real data, TSV sidesteps most of CSV's quoting headaches, which is why it's the default for bioinformatics files, database exports and log dumps. Same pinned header, same click-to-sort columns, same Copy as table — paste into Excel or Google Sheets and it arrives as a proper grid, ready to work with.

Example · tabs, no quoting needed

gene count expressed BRCA1 1240 true TP53 980 true

a clean 3-column table — click "count" to sort numerically, then copy it straight into a sheet.

Use it for bioinformaticsDB exportslog datawide tables

Takes messy, machine-spit CSV and makes it consistent and import-safe. It parses properly, squares up ragged rows to a uniform column count, and re-emits with normalized quoting — minimal by default (only fields that need quotes get them), or quote-every-field for importers that like it explicit. Toggle trim to strip stray whitespace from every field, and sort rows to order the body by the first column. Embedded quotes are doubled correctly on the way out.

Example · trim + normalize

name, role ,missions "Armstrong, Neil", Commander , 3 Buzz Aldrin,LM Pilot,2

name,role,missions "Armstrong, Neil",Commander,3 Buzz Aldrin,LM Pilot,2 ← trimmed, quoted only where needed

Use it for cleaning exportsnormalizing before importdiffinghandoffs

The same normalization for tab-separated data: uniform column counts, trimmed fields, consistent quoting and optional row sorting. Useful when a tab-delimited export arrives with ragged columns or stray spaces that break a downstream import — run it through once and every row has the same shape, ready for the next step of the pipeline.

Example · squaring up ragged rows

id name score 1 Ada 99 2 Grace 97 extra

id name score 1 Ada 99 2 Grace 97 ← every row now has the same shape

Use it for pipeline prepragged exportsdata cleaningimports

Table rules · parsing understands quoted fields, doubled quotes ("" → "), embedded delimiters and newlines inside quotes · rows are padded to a uniform column count on output · the viewer's sort is display-only and never touches your input; Copy as table copies the sorted view · Copy as table puts a tab-separated version and a styled HTML table on the clipboard together — spreadsheets take the tabs, rich editors take the table · the formatter quotes minimally by default, or quotes every field with the toggle · trim strips leading/trailing whitespace from each field · sort rows orders the body by the first column · everything runs locally — your table never leaves the tab

The privacy promise

Paste any table. We couldn't see it even if we wanted to.

This page has no backend and no database. Every row parsed, every column sorted and every cell copied just now happened inside your own browser tab — your data never traveled a single centimeter of cable. Even the clipboard write happens locally. Close the page and it's gone for good.

✕ SERVER · DATABASE · LOGS · ANALYTICS
  • Databasenull
  • Backendnone
  • Rows uploaded0
  • Session logs0
Questions

Asked often, answered plainly.

( 02 )
How does Copy as table work?

It puts two formats on your clipboard at once: a tab-separated plain-text version and a styled HTML table. Paste into Excel or Google Sheets and the tab-separated version lands as real cells you can immediately work with; paste into Word, Google Docs or an email and the styled HTML table comes through with its header row. One click, and whichever format the destination understands is the one it gets.

What's the difference between CSV and TSV?

The delimiter. CSV separates fields with commas, TSV with tabs. Because commas appear constantly inside real data — names, numbers, sentences — CSV needs quoting rules to keep fields intact; TSV sidesteps most of that since tabs rarely appear inside fields, which is why it's popular for data exports, bioinformatics and logs. The viewers and formatters here handle both identically, just with a different separator.

How are quoted fields handled?

With a real parser, not a naive split on the delimiter. Quoted fields can contain commas, tabs and even newlines; doubled quotes ("") become a literal quote; and the closing quote is tracked correctly. On output, the formatter re-quotes any field that contains the delimiter, a quote or a newline, so nothing leaks out of its column.

Does sorting change my data?

In the viewer, sorting is display-only — it reorders the rendered table without touching your input, and Copy as table copies whatever order you're currently looking at. In the formatter, the Sort rows option genuinely reorders rows (by the first column) as part of the output. Numeric columns sort numerically, everything else alphabetically.

Is my data saved anywhere?

No. Stack has no backend and no database. Every parse and render happens inside your browser tab and vanishes the moment you close or refresh the page. Even the clipboard write is local. Nothing is logged, because nothing is ever collected.