Settings

The Settings dialog lets you customize the add-on to fit your workflow. You can change the display language, manage AI permission, and set default options for various tools.

To open the settings:

1. Navigate to Extensions > Text To Table Converter in the main menu.
2. Click Settings.

You can also click the gear icon at the top of the sidebar.

Changes are not saved automatically. Click Save Changes at the bottom of the dialog when you are done. Some groups only appear in certain apps, as noted below.

Language Options#

Control the language of the add-on's interface and set a default for the translation feature.

• Interface Language: Sets the display language for the add-on menus, dialogs, and the sidebar.
  • Default: English
  • Available in the Settings dialog: English, German, Spanish, French, Ukrainian, Hindi, Traditional Chinese, Simplified Chinese, Japanese, and Afrikaans (10 languages).
  • The language (globe) button in the sidebar offers all 13 languages, including Portuguese (Brazil), Indonesian, and Vietnamese.

• Translation Language: Sets the target language for Extensions > Text To Table Converter > Selection Conversions > Translate > Translate using language from settings, so your most used translation language is one click away.
  • Default: Spanish
  • Available Languages: 48 languages.

AI Permissions#

This group is labelled AI Permission Options in the dialog. It controls how the add-on uses Artificial Intelligence for features like converting unstructured text to a table, summarizing, fixing grammar, and translating.

• Allow (Default): Automatically permits the use of AI for all relevant features without asking for confirmation. This is the default setting.
• Ask: The add-on will show a pop-up confirmation dialog each time a feature requires AI, giving you control over every operation.
• Deny: Prevents all AI-powered features from running. You can still use features like converting CSV-formatted plain text to tables.

Text to Table Options#

Configure how the add-on converts messy text into tables and where the result goes.

• Always use AI: When checked, forces the add-on to use AI for all text-to-table conversions, even for clearly structured text like CSV. Default: off.

• Enable AI Refinement: This master switch controls a second, more detailed AI processing step. Default: off.
  • Enabled (Slower): The AI performs a second pass to analyze the initial table structure, reformat data, and correct text based on the options below. This provides higher quality results for complex data.
  • Disabled (Faster): The add-on uses a single, faster AI pass to structure the text. This is quicker but does not apply the detailed formatting options.

• AI Refinement options: These settings appear when Enable AI Refinement is turned on and only take effect while it is on.
  • Table Orientation Preference: Guides the AI on how to interpret the data structure (Auto-Detect, Row-Based, or Column-Based).
  • Date & Time Formatting: Standardizes any detected dates and times into a consistent format.
  • Number Formatting: Standardizes any detected numbers, for example, by ensuring a consistent decimal or thousands separator.
  • Data Cleaning: Applies automated cleanup rules:
    • Trim Whitespace: Removes leading/trailing spaces from every cell.
    • Remove Currency Symbols: Strips out symbols like $, €, £, etc.
    • Case Formatting: Changes the capitalization of text in cells.
  • Correct Spelling & Grammar: Instructs the AI to fix typos and grammatical errors in the cell content.
  • Default Output Mode: Choose Standard Insert to put the table straight into the file, or Open in Table Editor to review it first. Default: Open in Table Editor. This dropdown is shown inside the AI Refinement options.

• Output Format (Google Sheets™ only): Normal Table or Tabular Format. Default: Normal Table.

Text To List Options#

Fine-tune how the add-on converts text into lists, including the visual style and how AI refines the output.

• List Style: Determines the bullet or numbering format for the created list. The options adapt to the application you are using (Google Docs™, Slides™, or Sheets™). Default: Solid Bullet in Docs and Sheets, and Disc, Circle, Square in Slides.

• AI Refinements: These options control how AI can improve the content and structure of your lists. They only apply when the add-on uses AI for conversion (either for messy text or when 'Always use AI' is enabled).
  • Always use AI: When checked, forces the add-on to use AI for all text-to-list conversions, even for simple text that is already separated by line breaks. Default: off.
  • Correct Spelling & Grammar: When checked, the AI corrects spelling or grammar mistakes in the generated list items. Default: on.
  • Make list items grammatically parallel: When checked, the AI rephrases list items to follow a consistent grammatical structure (for example, all items start with a verb). Default: off.

Table To Text Options#

This group is labelled Table to Text Options in the dialog. It configures the output when you convert a table back into plain text.

• Delimiter for Table to Text: The character used to separate cell data in each row when using the 🔡 ➜ 🔤 Selected Table to Text feature. This is useful for creating CSV-like data to use in other applications. Default: Comma.
  • Available Delimiters: A wide range including Comma, Tab, Semicolon, Pipe, and more.

Slides Export Options#

This group appears in Google Slides™ only.

• Image Format for Slides Export: The format used by Export All Slides to PNG/JPG. Choose PNG (Recommended) or JPG (Smaller file size). Default: PNG.

See Export All Slides to PNG/JPG for the full workflow.

LaTeX Equation Options#

This group is labelled Equations (LaTeX) Options in the dialog. It customizes the default behavior and appearance of the equation tools.

• Block Delimiter: The characters that wrap a "display" or block-level equation. Default: $$...$$.
  • Other Option: \[...\]

• Inline Delimiter: The characters that wrap an inline equation that flows with your text. Default: $...$.
  • Other Option: \(...\)

• Block Equation Height: Sets the default height in points (6 to 96) for block-level (centered) equation images. Default: 16.

• Inline Equation Height: Sets the default height in points (6 to 96) for inline (in-text) equation images. Default: 11.

• Insert as Multi-line Code: When checked, inserts the LaTeX source code formatted across multiple lines for better readability. Default: off.

• Format block equations using a table layout: When checked, block equations are placed inside a borderless table. This allows for clean alignment of equation numbers. When unchecked, equations are inserted as simple centered paragraphs. Default: on.

• Show number on new block equations: When checked, automatically adds a sequential number to new block equations. Requires the table layout. Default: on.

• Numbering Alignment: Aligns the equation number to the left or right of the equation. Requires numbering. Default: Right.

• Equation Number Format: Defines the characters used to enclose the equation number, for example (1). Default: (1).

• Add bookmark for cross-referencing: When checked, adds a Google Docs bookmark to the equation number, allowing you to create in-document links to it. Requires numbering. Default: on.

Reset Settings#

If you want to revert all options back to their original factory state, click the Reset to Default button at the bottom of the settings dialog.