Last checked by the TextEditor.com team
How to use the table editor
The grid works like a small spreadsheet. Click a cell and start typing, or press Enter to change what is in it. Your table saves in this browser as you work. Nothing is sent to our server.
- Open or pasteDrop a CSV or Excel file on the page, or copy cells in Excel and press Ctrl+V in the grid.
- EditChange cells, sort, move rows, find and replace, or remove duplicate rows.
- ExportPick a format, then copy the result or download a file.
Only the rows you can see are drawn on the screen. That keeps the grid fast with a file of 5,000 rows and 20 columns, or more.
Turn any table into Markdown, HTML or a text table
Copy a table from a web page, a spreadsheet or a GitHub file and paste it below. The editor finds the format by itself. Pick the format you want to see it in.
Text tables use box drawing lines. They line up in any font where every letter has the same width, like in code, a terminal or a plain text email. See more of these lines among the box drawing characters.
How a table looks as plain text
A CSV file is plain text. Each line is a row, and a comma splits the cells. When a cell has a comma, a quote or a line break in it, the cell goes inside double quotes. A quote inside the cell is written twice. These rules come from RFC 4180.
This editor opens CSV files too. For CSV work, like a wrong separator or broken letters from the wrong text encoding, the CSV editor has more tools.
What each format keeps
| Format | Open | Save | What is kept |
|---|---|---|---|
| CSV, TSV | Yes | Yes | The text of every cell. One sheet per file. |
| Excel .xlsx | Yes | Yes | Values of every sheet. Formulas, colors and column widths are dropped. |
| Excel .xls (Excel 97 to 2003) | Yes | As .xlsx | Values of every sheet |
| OpenDocument .ods | Yes | As .xlsx | Values of every sheet |
| HTML table | Paste | Copy | Text, header row and line breaks. Merged cells are split into single cells. |
| Markdown table | Paste | Copy | Text and the header row. Number columns are aligned right. |
| Text table with lines | No | Copy | Text, lined up with box lines in four styles |
Excel files are read with the free SheetJS library, which runs in this page. The file is never sent to a server. To copy part of a table, select the cells and tick "Only the selected cells" in the Export panel.
Why there are no formulas
This is a table editor, not a spreadsheet. A cell holds text, and a sum like =A1+A2 stays as typed. When you open an Excel file, each formula cell keeps the last value Excel worked out. A note tells you how many formula cells the file had.
That keeps the numbers you see the same as in the file. But if you change a number, totals will not update. Make those changes in Excel, LibreOffice or Google Sheets instead.
The status bar still helps with quick checks. Select some cells with numbers, and it shows their sum and average.
Keyboard shortcuts
| Keys | What they do |
|---|---|
| Arrow keys, Tab | Move to the next cell. Hold Shift to select more cells. |
| Type, Enter or F2 | Typing replaces the cell. Enter and F2 change what is in it. |
| Alt + Enter | A line break inside a cell |
| Esc | Stop editing and keep the old text |
| Delete | Clear the selected cells |
| Ctrl + C, V | Copy and paste cells, also to and from Excel and Google Sheets |
| Ctrl + Z, Y | Undo and redo |
| Ctrl + F | Find and replace in the table |
| Ctrl + K | Every tool in one list. Type to find one. |
| Ctrl + S, O | Save the file, or open one |
On a Mac, use Cmd in place of Ctrl. On a phone, tap a cell and change it in the box above the grid.
More table tools
- Edit a CSV file
a,b,cThe CSV editor puts each value in its own cell. - Make a Markdown table
| a | b |Fill in a grid and copy the table as text. - Check and format JSON
{"a":1}The JSON editor explains each error and the line to fix. - Put lines in orderc b a → a b cSort lines from A to Z, by number or at random.