Icon of Summarize AI Function: A simplified blue list with 3 bullet points on white paper


Get a clear summary from a spreadsheet range with any data using ChatGPT

Ideal for use in domains like market research, academic studies, or financial analysis; this function uses ChatGPT to summarize columns of customer reviews, lengthy reports, or even complex datasets, providing quick insights without the need to sift through your Google Sheets tables.


Expected Output:
Mid-size summary of this range
=SUMMARIZE_X(A2:A50, TRUE,  {"act_like", "Customer Service Analyst"})

Expected Output:
Summary of the A2:A50 range in bullet point from a Customer Service Analyst perspective
=SUMMARIZE_X(Sheet2!B5:D20, FALSE, {"mode", "extensive"; "act_like", "Financial Analyst"; "extra_instructions", "Focus on quarterly trends"; "output_language", "Most popular language in the region " & Regions!B5})

Expected Output:
Detailed summary with a focus on quarterly trends from the perspective of a financial analyst, using language prevalent in the region from cell B5 of the Regions sheet.
=SUMMARIZE(FILTER(A2:G100, D2:D100 > 7), FALSE, {"mode", "balanced"})

Expected Output:
Provide a balanced summary of the user's reviews with a rating over 7.
Arguments List
=SUMMARIZE_X(range, [as_bullet_points],[options])
=SUMMARIZE_Y(range, [as_bullet_points],[options])
Options List
Particular object at the end of a formula which contains optional parameters values in the form {"parameter_name",value; "next_parameter_name",value}
For Example: {"output_language","French"; "extra_instructions","Remember this info: " & A1; "act_like","Data Analyst"}
Sidebar Option
Due to Google Sheets' limitations, a specific feature may not be available for Smart Formulas. However, this feature can be accessed through a Smart Function in the Websheet AI sidebar.