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.
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
| Situation | Recommended workflow |
|---|---|
| Clean CSV, TSV, or Markdown table | Direct insert |
| Inconsistent rows or uncertain headers | Open in Table Editor |
| Existing CSV, TSV, TXT, or XLSX file | Start without a selection, then choose From File |
| Screenshot, photo, or scanned page | Use Image to Table instead |
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. Check the header row, scan for shifted values, apply a style if needed, and only then click Insert Table or Update Table.