Convert TableGoogle Workspace add-on
Tips for Better Text to Table Results
Use clear headers, consistent separators, quoted values, and Table Editor review to reduce cleanup after conversion.
A few small changes to the source text usually produce a cleaner table on the first attempt.
On this pagePrepare the source
Prepare the source
- Put the desired column names in the first row; Text to Table does not invent headers.
- Use the same separator on every row.
- Wrap values containing a comma or another active separator in double quotes.
- Keep the Markdown separator row intact when copying a Markdown table.
- Remove unrelated introductory or closing text when you want one simple table.
Choose the safest workflow
Swipe sideways to see all columns
| Situation | Recommended workflow |
|---|---|
| Clean CSV, TSV, or Markdown table | Leave Open in Table Editor off, then click Convert selection |
| Inconsistent rows or uncertain headers | Turn Open in Table Editor on before converting |
| Existing CSV, TSV, or TXT file | Start without a selection, then choose From File or From Google Drive |
| Screenshot, photo, or scanned page | Use Image to Table instead |
Check carried-over instructions
The sidebar keeps Text-to-Table instructions for repeated work. Before converting a different kind of content, check the collapsed instructions note and clear or replace it so an earlier rule does not shape the new table.
If the result looks wrong
- Too many columns: check for unquoted separators inside cell values.
- Only one column: make sure each row uses the same recognizable separator.
- Wrong headers: move the desired column names into the first row.
- Uneven rows: add missing values or review the result in Table Editor.
- Mixed Markdown output: use direct insert when you need headings and lists as well as tables.
Review before applying
Table Editor is the safer choice for important tables. Turn on Open in Table Editor before converting, check the header row, scan for shifted values, apply a style if needed, and only then click Insert Table or Update Table.