Yes. The Target toggle above the tabs controls all three tools — pick Excel 365, older Excel, or Google Sheets, and the formulas, macros, and pivot suggestions all adjust to match.

If your Excel has dynamic arrays and XLOOKUP (most Microsoft 365 installs), pick Excel 365. If you’re on Excel 2016/2019 or unsure, pick 2016/Legacy so the formula avoids newer functions that would show a #NAME? error.

No — Google Sheets can’t run VBA at all. Switch the Target toggle to Google Sheets and the VBA/Script tab automatically switches to writing Google Apps Script instead, which is Sheets’ own automation language.

It’ll be logically correct, but if you didn’t mention exact columns or sheet names it uses placeholders like A2, B2:B100, or “Sheet1”. Swap those for your real references before running it.

#NAME? usually means you’re on Legacy Excel but the formula used a 365-only function — regenerate with Legacy selected. #REF!/#VALUE! usually means a range doesn’t line up with your actual data — check that every reference points to the right column.

Yes — describe the slabs, thresholds, or conditions in plain English and it’ll draft nested IF, IFS, or lookup-table formulas, or a VBA/Apps Script macro if you need it automated. Tax rules change often, so always double-check the generated logic against the current year’s rates before filing anything.

No. Typed requests are only used to generate that one result. An uploaded sheet is parsed entirely in your browser — only a small column summary and sample, not your full file, is sent along with an analysis request. “Clear all” wipes everything on this page instantly.