Guides

Convert Table

Text to Table Settings

Learn which Text to Table settings affect output mode, AI behavior, and how conversions open from the Extensions menu.

Open Text to Table settings in: Extensions > Text To Table Converter > Language & Settings

These options affect how conversions open and when AI is used.

Output Mode

Output Mode controls what happens when you run Text to Table from the Extensions menu.

  • Open in Table Editor: converts the text, then opens the result in Table Editor
  • Standard Insert: converts the text and inserts the table immediately

Remember Output Mode

Turn on Remember Output Mode if you want the Extensions menu to keep using your preferred output mode.

The sidebar still gives you both choices directly:

  • primary button for Standard Insert
  • caret (▼) for Open in Table Editor

AI Options

  • Always use AI: uses AI for all Text to Table conversions, even when the input already looks structured
  • AI Permissions: controls whether AI use is Allow, Ask, or Deny
  • Enable AI Refinement: runs an optional second AI pass for more cleanup and structure improvements

AI Refinement Options

These options matter only when Enable AI Refinement is turned on.

  • Table Orientation Preference: helps the AI decide whether the data should be organized horizontally or vertically
  • Date & Time Formatting: standardizes detected dates and times
  • Number Formatting: standardizes detected number formats
  • Data Cleaning: can trim whitespace, remove currency symbols, and normalize case
  • Correct Spelling & Grammar: cleans up cell content during refinement

Tip: If you keep AI permissions on Ask, the add-on will prompt you before AI is used.

Google Sheets Option

In Google Sheets™, you can also choose how inserted tables are formatted after conversion.

Related Links