Table Editor
Create, review, clean, format, update, and append table data in Google Docs, Google Sheets, or Google Slides.
Table Editor is the review workspace for converted text, selected tables, imported files, and new blank tables. Edit values, clean and sort rows, format columns, apply styles, and preview the result before it changes your file.
On this pageOpen Table Editor
Open Table Editor
- Converted text: open the caret beside Convert selection, turn on Open in Table Editor, then run the conversion.
- Existing table: select the table and click Edit table on the Home screen with the shared Instructions box empty.
- New table: run Text to Table without a selection, then choose From Text, From File, From Google Drive, or Empty Table.
- Extensions menu: choose Edit & Format Table for the current table selection.
Edit table with instructions is a different path
If the shared Instructions box contains text, Edit table creates an AI change preview in the sidebar instead of opening Table Editor. Review the highlighted cells and choose Apply update or Cancel. In Docs and Slides, a clean row-only deletion can update the selected table in place while preserving the remaining rows’ formatting; other structural AI changes can still insert a replacement table.
Edit, clean, and format the table
- Edit cells directly or paste a block of values into the grid.
- Add or remove rows and columns.
- Apply bold, italic, underline, text color, fill color, alignment, and borders.
- Open Tools to transpose the table, delete empty rows or columns, deduplicate rows, change case, or find and replace values.
- Sort rows by a selected column with standard ascending or descending order, or use AI Sort when the desired order depends on meaning.
- Use Column Format to apply number, currency, percent, or date formatting to a selected column and preview the change before applying it.
- Use Undo and Redo for grid, formatting, and supported AI changes.
- Use AI Assist for an instructed change or AI Polish for a quick cleanup when AI access is enabled.
Apply a table style
Open Styles to preview built-in and saved custom styles. Selecting a style updates the editor grid before anything is applied to the host file.
Start from text, a file, or a blank grid
When no table data is supplied, Table Editor opens a start screen instead of an empty editing canvas.
- From Text: paste delimited or loosely structured text.
- From File: upload a CSV, TSV, or TXT file from your computer.
- From Google Drive: choose a CSV, TSV, or TXT file from Drive.
- Empty Table: choose at least two rows and two columns for a blank grid.
- For text and file sources, the next step accepts optional AI instructions or a target-format preset before the grid opens. Empty Table skips that step.
File limits
Table Editor supports local and Google Drive CSV, TSV, and TXT files up to 5 MB.
Insert or update the result
- For a converted or new table, click Insert Table to insert the reviewed result.
- For a selected existing table, click Update Table to update it in place when the host and table shape allow it.
- If an existing table cannot be updated safely in place, the add-on inserts the edited result as a new table.
- In Google Sheets, use Append to Sheet to match columns by header name and add the editor rows to an existing sheet. Unmatched columns are shown before confirmation.
- Cancel closes the editor without applying the pending changes.
Table size changes
Adding or removing rows or columns while editing an existing table can require the add-on to insert a new table instead of updating the original in place.