Skip to main content

Reformat

Standardize dates, phone numbers, or any other text to a consistent format directly in Google Sheets. For example, you can reformat product names before you include them in your catalog.

Run the bulk tool​

Prerequisites

  1. Select Extensions > GPT for Sheets and Docs > Open.

    Open GPT for Sheets

  2. In the sidebar, select Bulk tools, and click Reformat.

    Select Reformat
    info

    If you open the Bulk tools for the first time, you are prompted to grant additional permissions. These permissions are required for GPT for Sheets to write in your spreadsheets.

    1. Click Sign-in with Google. A Sign in with Google window opens.
    2. Select the Google account with which you have installed GPT for Sheets.
    3. Click Allow to grant GPT for Sheets the required permissions.

  3. Set up your bulk tool run.

    Setup Reformat
    FieldDescriptionExample
    1Column name row
    (optional)    		If your column names aren't in the first row, select the number of the row that contains the column names. The bulk tool will run on the rows below this one.2
    2Reformat each cell in columnSelect the column that contains the text to reformat.A: Name
    3ToDescribe the format to which you want to convert the text.
    Color | Model | Size (S, M, or L)
    4Put results in columnSelect the column to put the results in. Cells in this column won't be overwritten with the results if they contain text.B: Standard format
    5Reformatting instructions
    (optional)    		Enter specific instructions for the reformatting.
    Use title case

  4. Run the Reformat bulk tool starting from the first empty cell in the results column:

    1. Select a specific number of rows to run or select All rows.

    2. Click Run rows.

      Run Reformat tool
      info

      GPT for Work saves the setup in its bulk tool run history. You can reuse the setup by selecting it from History.

      Bulk tool History

You have set up and run the Reformat bulk tool. If needed, try improving the results.

Reformat results

Improve results​

Try different models​

Find out which models work best for different use cases in our AI models overview. You can try different models by selecting them in the model switcher.

info

The model selection is a spreadsheet setting. It applies to all bulk tool runs and all GPT function executions in the current spreadsheet.

Set Creativity to 0​

Ensure Creativity is set to 0. This setting helps the AI follow instructions more closely.

Creativity level
info

Creativity is a spreadsheet setting. It applies to all bulk tool runs and all GPT function executions in the current document.

Provide reformatting instructions​

You can improve reformatting quality by providing specific instructions that help the AI more closely follow your requirements for formatting rules and consistency.

You can define the following types of instructions for the AI:

  • Reformatting instructions are defined for the current bulk tool run.
  • Global instructions can also be defined in the spreadsheet settings and apply to all bulk tools and GPT functions in the current spreadsheet.

If both and global instructions are defined, the AI uses both as a combined set of instructions. For consistent results, make sure both sets of instructions are aligned and do not contradict each other.

For example, omit the global instructions and only define reformatting instructions:

Set instructions

What's next​

Try another bulk tool.

On this page