Convert TableGoogle Workspace add-on

Text to Table Input Types

Prepare comma-separated, tab-separated, Markdown, quoted, or loosely structured text for a clean table conversion.

Text to Table works best when each record follows the same pattern. The first parsed row becomes the header row, so include the column names you want in the final table.

Separated text

Use one consistent separator throughout the selection. Commas, tabs, semicolons, and pipes are common choices.

CSV

Name,Team,Location
Alice,Design,Taipei
Bob,Support,Kaohsiung

Pipe-separated text

Name | Team | Location
Alice | Design | Taipei
Bob | Support | Kaohsiung

Values containing commas

Wrap a value in double quotes when a comma belongs inside one cell.

Quoted CSV value

Name,Notes
David,"Primary contact, available mornings"

Markdown tables

Keep the separator row directly below the header. Bold and italic Markdown inside cells can be preserved where the host supports it.

Markdown table

| Customer | Order | Milk |
| --- | --- | --- |
| Alice | Latte | Oat |
| Bob | Americano | None |

Loosely structured text

Notes and copied email content can be converted even without a reliable separator. Results depend on how clearly the records and fields can be identified, so use Table Editor to review the conversion before applying it.

AI permission may be needed

The add-on can request AI processing when local conversion cannot find a consistent structure. Your AI permission setting controls whether that processing is allowed, denied, or confirmed each time.

Files

CSV, TSV, and TXT files use the same separator detection as pasted text.
XLSX workbooks are loaded into Table Editor for review.
Local uploads and Google Drive files are supported.
The maximum file size is 5 MB.