Convert TableGoogle Workspace add-on
Text to Table Settings
Choose the default output workflow and control when Text to Table can use AI or apply an additional cleanup pass.
Open Extensions > Text To Table Converter > Language & Settings. For most users, the output mode and AI permission are the only settings that need attention.
Output mode
| Setting | Use it when |
|---|---|
| Open in Table Editor | You usually want to inspect or format the conversion before applying it. |
| Standard Insert | Your source text is predictable and speed matters more than preview. |
Menu versus sidebar
The Extensions menu follows the saved output mode when Remember Output Mode is enabled. The sidebar always keeps both choices available.
AI controls
- AI Permissions: allow AI, deny it, or ask before each use.
- Always use AI: send every conversion through AI, even when the text already has clear separators.
- Enable AI Refinement: run an additional cleanup pass after the initial conversion.
Recommended starting point
Leave Always use AI off. Clear CSV, TSV, and Markdown tables can be converted locally; allow AI only when inconsistent text needs help finding rows and columns.
Refinement options
These options apply only when AI Refinement is enabled.
- Prefer a horizontal, vertical, or automatically detected orientation.
- Standardize dates, times, and number formats.
- Trim whitespace, normalize case, or remove currency symbols.
- Correct spelling and grammar inside cells.
Google Sheets formatting
In Google Sheets, choose whether a directly inserted table is left plain or receives header styling and borders.