ChatGPT for Excel: Setup and Use for Accountants 2026

Add ChatGPT to Excel, learn what it reads in a workbook and use it for formulas and reconciliations while client identifiers stay out of the chat.

Published
Updated

ChatGPT for Excel is OpenAI’s add-in for building and editing workbooks in Excel. You can also upload a copy to ChatGPT for analysis and download a revised file.

What ChatGPT for Excel Does

The add-in opens a ChatGPT sidebar in Excel. Ask it to explain a formula across tabs, add a reconciliation sheet or build a workbook from a blank one. Name the tabs to change and review the edits in Excel.

ChatGPT can also read an uploaded Excel file, analyse its data and return a downloadable workbook based on your instructions or the copy you supplied. Download and open the result to inspect it.

Your original stays separate. Sidebar chats and regular ChatGPT conversations have separate histories.

ChatGPT’s upload limit for spreadsheets is about 50 MB, depending on row size. The analysis tool can’t fetch a workbook’s external data on its own. In the add-in, treat VBA and macros as areas that need manual review.

Word uses the same Microsoft add-in. Its sidebar drafts and edits document text, while the Excel sidebar works with cells and formulas.

How to Add ChatGPT to Excel

Use Excel on the desktop or web and a ChatGPT account on a supported plan. If your practice manages Microsoft 365, check that it lets your account install the add-in or has assigned it to you.

  1. Open Excel and choose Add-ins from Home.
  2. Search for ChatGPT. Select the listing by OpenAI and add it.
  3. Open ChatGPT from the Excel ribbon. Sign in with the account that holds your plan and select your practice workspace if you use one.
  4. Put the number 25 in cell A1 of a blank workbook. Ask ChatGPT to read A1 without editing it. Confirm that the sidebar returns 25 and the cell still contains 25.

If the add-in is missing from the store, a Microsoft 365 admin can upload OpenAI’s manifest under Integrated apps and assign the add-in to your group. Follow OpenAI’s Excel installation instructions.

If the sidebar opens but access is refused, check the account and workspace first. In a ChatGPT workspace that uses role permissions, the administrator may also need to enable ChatGPT for Excel and Google Sheets.

OpenAI’s add-in uses your ChatGPT sign-in. Some third-party add-ins ask for an OpenAI API key, a credential for the developer service. Those add-ins can have their own terms. OpenAI API billing is separate from ChatGPT.

Free Access and Price

Yes, ChatGPT for Excel is available on ChatGPT Free with limited use. Go also has limited access. Plus and Pro include the add-in within the plan’s allowance for AI tasks.

Business, Enterprise, Edu and K-12 also include access under their workspace usage terms. Business and Enterprise admins can monitor use and buy credits for additional access. Large workbooks or multi-step edits can draw more from the allowance.

See OpenAI’s ChatGPT pricing page for current subscription prices. OpenAI’s business and education rate card sets out usage charges where they apply.

Formulas ChatGPT Can Write and Explain

To get a formula you can check, name the sheet and input ranges. Tell ChatGPT which cell needs a result. Describe what should happen when a value is blank or missing.

Ask for the formula and an explanation of each part before asking ChatGPT to put it in the workbook. The examples below use fictional values and can be entered in Excel by hand.

Look Up a Code Across Sheets

On Accounts, enter A110 and A120 in A2:A3, paired with Sales and Rent in B2:B3. Ask for a formula on Review that takes A2 and returns the account label.

=XLOOKUP(A2,Accounts!$A$2:$A$3,Accounts!$B$2:$B$3,"Missing",0)

The first range holds the codes and the second holds the labels. The 0 requests an exact match. Enter A120 in Review!A2 and expect Rent. Try A999 and expect Missing.

Sum an Account by Period

On Ledger, put period numbers 1, 2, 2, 2 in A2:A5, codes A120, A120, A110, A120 in B2:B5 and amounts 80, 120, 60, 30 in C2:C5.

Ask for a formula on Ledger that adds amounts for the period in E2 and the code in F2.

=SUMIFS(C2:C5,A2:A5,E2,B2:B5,F2)

Excel adds from C only when both tests pass. With period 2 and code A120, expect 150 from 120 + 30. The earlier period and the other account stay outside the sum.

Clean Up an Imported Reference

Ask for a formula that removes extra spaces from A2, including non-breaking spaces pasted from another file, and converts the reference to upper case.

=UPPER(TRIM(SUBSTITUTE(A2,UNICHAR(160)," ")))

SUBSTITUTE swaps non-breaking spaces for ordinary spaces. TRIM removes leading and trailing spaces and reduces runs of internal spaces to one. UPPER converts the letters. A padded inv 007 returns INV 007.

Client Workbooks and What ChatGPT Can Read

The Excel add-in sends prompts, attachments and relevant parts of the workbook to OpenAI for processing. OpenAI says some add-in logs can be kept for 30 days. Microsoft can also have access under its Marketplace terms.

A file uploaded to a regular ChatGPT conversation sends the workbook copy along with your prompt. Regular chats stay in your account until you delete them or a workspace retention policy removes them.

Deleting a chat leaves files saved separately in Library or Space. Delete those copies separately. In Enterprise, Edu and Healthcare workspaces, saved files follow the workspace’s retention policy. See OpenAI’s chat and file retention policy.

On personal plans, OpenAI can use eligible content for training according to your data settings. Business, Enterprise and Edu content is excluded from training by default. See OpenAI’s model training policy.

The Tax Practitioners Board says a registered tax practitioner needs the client’s permission to disclose information about their affairs to a third party, unless a legal duty requires disclosure. See TPB guidance on AI and confidentiality.

Keep client workbooks out of personal ChatGPT accounts. Turning off training leaves the practice responsible for getting the client’s permission to share the workbook where required.

For a formula question, describe the columns and use made-up rows. If you need a file, create a fresh copy with tax file numbers (TFNs) and bank details removed.

Replace names and identifiers throughout the file. Check comments, hidden tabs and file names too.

Tax Genie applies the same principle to its own onboarding forms. It removes every TFN before AI reviews the client’s answers.

Accounting Tasks and Prompts for ChatGPT in Excel

Run these prompts on fictional data or in a permitted workbook copy. Give the assistant a named output area for every change and leave source tabs untouched.

Reconcile Two Lists

Compare Bank!A2:B80 with Cashbook!A2:B90. Column A is the payment reference and B is the amount. List unmatched references from both sheets. Flag any amount difference or repeated reference separately.

Check an agreed pair and an unmatched entry from each sheet by hand. Confirm that a repeated reference appears as an exception even if the amounts agree.

Explain an Inherited Workbook

Trace Summary!F12 through Working!B2:F40 and Inputs!B2:B8. List the cells used, the assumptions and any references outside these ranges. Leave the workbook unchanged.

Follow the formula in F12 back to one source cell. Check if a link crosses into another workbook that the assistant cannot inspect.

Build a Loan Amortisation Table

Use Terms!B2:B5 for principal $12,000, annual interest 6%, 12 monthly payments and end-of-month timing. Assume a fixed rate and zero fees. Build the schedule on a new tab and show the payment formula.

Check that the first month’s interest is $60. Opening balance plus interest less payment must equal the closing balance. Confirm the final balance is zero before rounding or explain any cents left by rounding.

Flag Duplicate Entries

In Ledger!A2:D200, A is invoice reference, B is supplier code, C is invoice date and D is amount. Flag every repeated supplier and invoice reference on a separate tab. Keep each source row.

Check one known duplicate and one invoice reference reused by a different supplier. The second case should stay unflagged.

Draft a Variance Note

In Variance!A2:D8, B is budget, C is actual and D is actual less budget. Draft a note for the largest absolute variance. State the amount and direction. Use only the supplied figures.

Recalculate the difference. A budget of $6,000 and actual spend of $6,400 is $400 over budget. Check that the note leaves the cause open until you have evidence for it.

Check the Workbook Before You Rely on It

Keep the original workbook unchanged. Test each new formula on a row with a known answer and on a likely exception, such as an unmatched reference or an empty amount.

Compare totals and record counts with the source. If a reconciliation differs, trace the unmatched rows until you can explain the difference. Reopen a saved copy to check that formulas still work and new tabs contain the intended results.

The practitioner who signs the work decides the tax treatment and checks every figure sent to the client. Keep the workpaper that shows how you checked the result.

One client form. One finished return.

Your client completes one guided form. Tax Genie checks it, chases mistakes and sends the details to your engagement letter and tax software.

See how Tax Genie works

Made for Australian accounting firms

Tax GenieSee how Tax Genie works