Spreadsheet Sync access in QuickBooks Online: plan, role, and spreadsheet limits
Spreadsheet Sync in QuickBooks Online is limited by plan and user role, and Excel and Google Sheets do not do the same jobs.
QuickBooks Online users keep asking the same three things about Spreadsheet Sync. Some cannot find the feature anywhere in their menus. Others install it and discover that Google Sheets cannot do what Excel does. A third group cannot get the add-in to install at all. The accepted guidance, maintained by Intuit, covers all of it, plus a few traps worth knowing.
The purpose is straightforward. Data moves between the books and a spreadsheet so you can analyse figures, build custom report layouts, update records in bulk, and compare several companies in one place. The limits show up before any of that work begins.
Who can open Spreadsheet Sync?
Availability is the first constraint. The tool serves QuickBooks Online Advanced subscribers and firms on QuickBooks Online Accountant. On other plans it never appears, and the software stays quiet about the reason, so users often blame a glitch.
Permissions add a second gate. An admin has to grant access before colleagues can use anything. The qualifying roles are primary admin, company admin, and standard all access. If the primary admin role has changed hands, settle that first, because the gatekeeper has to exist before access can flow.
Accountants sit in a special position. The firm needs client access to the file, and that client must be on the Advanced plan. Once connected, the accountant counts as a company admin inside the client’s account, with the access that implies.
Excel and Google Sheets are not equal here
This split surprises people more than anything else. Excel carries the full toolkit. Connected to Microsoft 365 Excel, you can build a custom financial report, reshape it, push bulk edits back into the books, and collaborate in the sheet in real time.
Google Sheets is deliberately narrower. In Sheets you can run reports, including multi-company reports, and the capability stops there. Creating and updating stay on the Excel side. Anyone hunting for the update controls in the Sheets add-on will not find them, and the accepted answer frames that as intended rather than broken.
Reports and multi-company runs are the one place the two platforms meet. Everything beyond that belongs to Excel. Plan the workflow around the spreadsheet you actually have, not the one a demo showed.
How is the add-in installed?
For Excel, start inside QuickBooks Online Advanced. Open Settings, select Spreadsheet Sync, and follow the download and install steps. Two requirements trip people up. The add-in expects Microsoft 365 Excel rather than an older standalone copy. It also refuses to cooperate when Internet Explorer 11 is the default browser, so Edge is the practical prerequisite. A trust prompt appears near the end, and accepting it completes the installation.
Two other routes lead to the same installer. From the Reports menu, the option to create a new report in a spreadsheet kicks off the setup. You can also open Spreadsheet Sync from Reports and choose to run a report in Excel. Either way, the same add-in downloads.
Google Sheets takes a different path. Open a sheet, go to Extensions, then Add-ons, then Get add-ons, search for Spreadsheet Sync, and install it from there.
Signing in and switching companies
First launch asks for your QuickBooks sign-in. Where one login covers several companies, the add-in asks which one to load. Checking that choice early saves confusion later, because every report and update acts on the selected company.
Signing out sits behind the person icon inside the add-in menu. In Sheets, you reach the same controls by launching the add-on from the Extensions tab first.
Three checks that settle most cases
Nearly every reported problem traces back to three questions. Is the plan Advanced or Accountant? Is the role primary admin, company admin, or standard all access? Does the spreadsheet match the task, meaning Excel for creating and updating, Sheets for running reports? A standard user on a Plus plan, for instance, will see nothing no matter how often the page reloads.
When those line up, the tool behaves. The remaining failures usually point at the environment. An aging browser or an unsupported copy of Excel will stop the add-in before it starts. We would add one practical note: pick the company before building anything, since that choice drives everything the spreadsheet touches.