Excel GPT is a chat assistant for spreadsheet formulas. Say what you want worked out and which columns hold your data, and it replies with a formula to copy, a step-by-step walk-through and a small example. It covers Excel and Google Sheets. Excel GPT is independent and not affiliated with Microsoft.
A few details make the first answer right, so start your message with them.
Lookups with XLOOKUP or INDEX and MATCH, conditional totals and counts with SUMIFS or COUNTIFS, nested IF tests, date maths, text clean-up, and FILTER, UNIQUE and SORT. When a function is missing from older Excel, it offers a version that works there.
Share the broken formula and the error it shows, such as #N/A, #VALUE!, #REF! or #SPILL!, and describe the cells it points at. Excel GPT lists the likely causes in order and suggests a fixed formula to try.
It has no way to open, edit or save a file, and it never sees your sheet. It works only from the text you paste or the layout you describe, so use made-up sample values rather than real customer or payroll data, and test each formula on a copy first.
Write a Notion formula · Turn a question into a SQL query · Ask AI Chat anything
Hi, I'm Excel GPT. What should your sheet work out? Say which column holds what, and if you're on Excel or Google Sheets. You can also paste a formula that shows an error and I'll help you repair it.