The QuickBooks Power Query Connector Is Gone (And Excel Never Had It): Real Alternatives

Guide · Updated July 2026 · ~11 min read

You opened Excel, went to Data > Get Data, and hunted for a QuickBooks option a colleague swore existed. Or you inherited a Power BI report that pulled QuickBooks Online into a model, and now it's dead. Either way you need QuickBooks numbers in a spreadsheet, repeatably, and the connector everyone talks about isn't there.

One correction first, because it changes which fixes are worth trying.

First: there was never a QuickBooks connector in Excel

The connector people mean was called QuickBooks Online (Beta), and Microsoft's own capability table listed its supported Products as "Power BI (Semantic models)" — Power BI only. Release State: "Beta, under deprecation". Capabilities Supported: "Import".

So Excel users did not lose a QuickBooks connector; Excel never had one. If you've been searching Get Data > From Online Services and coming up empty, that's not a broken install. It shipped in Power BI Desktop, it was Beta throughout, and it's gone from there too. Microsoft documented that it "uses the QuickBooks ODBC driver", which "is shipped with Power BI Desktop" — a plausible reason it never crossed over, though Microsoft never said so.

What actually happened, and when

There's no Microsoft blog post announcing this that we could find; the documentation and its source history are the only record.

• 2025-06-04 — a deprecation note is added to Microsoft's Power Query documentation for the connector.
• June 2025 — per that notice, it "will not be shown in the Power BI service".
• July 2025 release — the entry is "removed from Power BI Desktop".
• August 2025 — the connector is "planned to be deprecated starting from" this month.
• 2025-10-31 — Microsoft deletes the Learn article: page removed, row deleted from the connector index, redirect added.

As of 26 July 2026 that URL returns a 301 to the general connector list, and "QuickBooks" appears nowhere in the current list of all Power Query connectors. Scrubbed, not merely flagged. Microsoft's recommendation, verbatim: "We recommend you transition off existing connections using this connector and don't use this connector for new connections."

Three things Microsoft did not say, despite what you'll read elsewhere: it announced no phased plan with separate "new connections blocked" and "scheduled refresh disabled" milestones (that phrasing is from vendor blogs); it neither announced a replacement nor ruled one out; and nothing confirms the connector actually stopped working in August 2025, only that it was planned to. Scheduled refresh failing on an existing semantic model is the natural consequence — reported by vendors and users, not stated in the notice.

Below are five routes that exist. Prices were read from vendor pages on 26 July 2026.

Route 1: Manual export to CSV or Excel (free, but static)

1. Run the report in QuickBooks Online, then use the export icon in the report toolbar and choose the Excel option. For the ledger itself, see getting the QuickBooks general ledger into Excel.
2. Save the file into one stable folder — the same path every month.
3. In Excel, use Data > Get Data > From File > From Folder and point Power Query at the folder, not a single file.

Step 3 is what separates a workable process from a miserable one: if every export lands in `C:\Finance\QBO Exports`, next month's file drops in and one Data > Refresh All rebuilds everything downstream.

QBO exports are report layouts, not tables, so two things need cleaning every time:

• A title block and merged header rows at the top. In the Power Query Editor use Home > Remove Rows > Remove Top Rows, then Home > Use First Row as Headers.
• Amounts stored as text, especially parentheses negatives and currency symbols. Right-click the column, choose Change Type > Using Locale, set Data Type to Decimal Number and pick the locale the export came from. Cleaning in the grid instead:

=IF(TRIM(A2)="","",IFERROR(VALUE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(TRIM(A2),"$",""),",",""),"(",""),")",""))*IF(LEFT(TRIM(A2),1)="(",-1,1),NA()))

It strips the currency symbol, separators and brackets, then flips the sign when the original started with (. Anything it can't convert returns #N/A rather than a silent zero, so a bad row shows up in your total instead of hiding in it. Power Query for beginners, cleaning messy data and merging Excel files cover both patterns in detail.

Pros: free, no IT approval, any QBO plan. Cons: a snapshot — no refresh without a human. Power Query on Excel for Mac supports far fewer sources than on Windows, so plan the folder-combine step on Windows.

Route 2: QuickBooks Spreadsheet Sync (Intuit's own Excel answer)

The closest thing to an official Excel-native connector, and actively maintained — Intuit's "Get started with Spreadsheet Sync" article was updated 26 May 2026, the "Install and open Spreadsheet Sync" article on 20 July 2026.

The catch is who can use it. Verbatim from Intuit: "Only QuickBooks Online Advanced, QuickBooks Online Accountant, or Intuit Enterprise Suite admins can open and manage Spreadsheet Sync." So it's admin-gated on top of tier-gated, and unavailable on Simple Start, Essentials or Plus. Also verbatim: "Spreadsheet Sync works with Excel Office 365. It won't work with older Excel versions."

Opening it from QuickBooks Online Advanced: go to Reports > Spreadsheet sync (Take me there), select Run report in Excel, then in Excel select Spreadsheet Sync from the ribbon on the Home tab and choose Get Started > Sign in. If the tab isn't there yet, install it from Settings (gear icon) > Spreadsheet Sync.

Pulling a report: Run report > Select company > Select report > choose your data > Run report. Writing back is the genuinely useful half: Create or edit records > Select company > Select a record type > Add new records to QuickBooks or Edit QuickBooks records and sync back > Get template, fill it, mark the row Yes, then Sync to QuickBooks > Sync. For the journal side of that specifically, see importing journal entries into QuickBooks Online from Excel.

Pros: first-party, Excel-native, reads and writes, no third party in the loop. Cons: hard tier gate, admin gate, Office 365 Excel only. Intuit's steps describe user-initiated Run report and Sync to QuickBooks actions; we could not verify scheduled or background refresh, so plan for manual. Nor could we verify from Intuit's text whether it costs anything on top of a qualifying subscription — blogs assert it's included; confirm with Intuit.

Route 3: Third-party connectors and ODBC drivers

If you're not on a qualifying QBO tier — or you need the data in Power BI too — this is the mainstream commercial answer. Prices are from the vendors' own order pages.

CData sells three relevant SKUs, each a Desktop License with Server pricing by quote:

• Power BI Connector for QuickBooks Online — $499/yr (1 desktop, 1 data source; additional sources 40% off). You may see $1,999/yr for this in search snippets; that figure is wrong.
• ODBC Driver for QuickBooks Online — $499/yr. This is the one that gives you Data > Get Data > From Other Sources > From ODBC in Excel.
• Excel Add-In for QuickBooks Online — $599/year Starter Edition, up to 3 desktops, Windows Excel only.

Coupler.io, hosted, lands QuickBooks data into a destination on a schedule: Free $0; Starter $32/mo; Active $132/mo; Pro $259/mo; Agency and Enterprise custom, 25% off annually ($24, $99, $199 a month). The free plan is 1 source, 1 destination, manual refresh, 100 rows per run — enough to see the shape of your data, not to run on.

Skyvia: Free $0; Basic $99.79/mo; Standard $199/mo; Professional $499/mo; Enterprise custom. Free gives 10,000 records a month, daily scheduling, and 2 scheduled integrations that expire after 30 days.

Pros: refreshable, vendor-supported, serves Power BI and Excel, no code. Cons: recurring cost that scales with rows and refresh frequency, plus another vendor holding an OAuth grant to your ledger. We have not verified whether any of the three write back — treat them as read paths unless the vendor says otherwise.

Route 4: Roll your own against the QuickBooks API in Power Query

It works for a demo and it's painful in production. QuickBooks exposes the QuickBooks Online V3 REST API over the OAuth 2.0 authorization code flow: register an app for a Client ID, Client Secret and Redirect URL, request the com.intuit.quickbooks.accounting scope, send the user through a browser authorization, then exchange the returned code for tokens. Every call also carries the Realm ID.

Then the wall. The access token is valid for one hour, and Intuit's SDK documentation states flatly that this cannot be changed. The refresh token lasts about 100 days, but QuickBooks returns a new refresh token roughly every 24 hours and expires the previous one. That rotation is the killer: the new token must be persisted somewhere writable every time, and Power Query is functional and side-effect-free. Web.Contents sends any headers you build, but a query cannot write the new token back for the next refresh. So you hand-paste a token into a parameter every day or two — impossible for a team — or you stand up an external store that the query reads and a script writes, at which point you've built a small integration platform and Route 3 was cheaper.

If you try it, keep the token in a query parameter rather than the query text and pass Authorization: Bearer via the Headers option of Web.Contents.

Pros: free, no vendor, full control over which fields you pull. Cons: token rotation makes unattended refresh genuinely hard; budget developer time. We could not verify Intuit's rate limits or endpoint paths from a primary source, so build against the official QuickBooks Online API reference.

Route 5: An Excel add-in that reads the ledger and posts back

The gap none of the four routes fully closes: ledger data in the sheet you're already working in, pulled on demand, with corrections going back the other way without a CSV round trip.

HISAB 360 is one product built for that shape — a Windows Excel add-in (VSTO) with an AI chat panel docked in Excel. You describe what you want in plain English and it writes and applies the work in the live workbook: formulas, Power Query M, PivotTables, Power Pivot measures, charts, VBA. It connects to QuickBooks Online, Xero, Zoho Books, Odoo, FreshBooks and Sage with read and write where the API allows, pulling invoices, bills, payments, journals and reports into a range, and posting or updating invoices, bills, payments and journal entries back. It also matches bank statement lines against ledger rows and pulls tables out of PDF statements. More in ERP reconciliation and write-back and connecting QuickBooks and Xero to Excel. Unlike Route 2 it isn't gated to QBO Advanced; unlike Route 4, it handles OAuth token rotation for you.

The honest limitations. Windows desktop Excel only — not Mac, not Excel for the web. It's a paid product with a limited free trial credit allowance, not a free tool: Own AI (bring your own provider key) $7/month or $60/year, HISAB AI Basic $10/month, HISAB AI Plus $20/month, perpetual licence $199, top-ups $4.99 and $12.99. Pulls happen when you ask — no scheduled or continuous background sync. Connecting still requires OAuth authorisation. And because it writes to your ledger, review every posting before approving it and reconcile afterwards. See pricing and features.

Decision table

What we'd actually do

• On QBO Advanced or Accountant? Spreadsheet Sync — first-party and it writes back. Start there before paying anyone.
• On Plus or Essentials? Manual export into a folder-combine Power Query. Built once, it's a five-minute month-end.
• Need genuine scheduled refresh? CData at a fixed annual cost, or Coupler.io / Skyvia hosted. For a dead semantic model the ODBC driver is the closest swap.
• Reconciling and posting corrections from Excel? An add-in like HISAB 360, with the Windows-only and paid caveats above.

Whatever you pick, put the raw pull on its own sheet, never type over it, and build calculations on top with structured references. Excel skills for accountants and Excel automation for finance teams go deeper.

Frequently asked questions

Try HISAB 360 on your own workbook

HISAB 360 is an AI assistant inside Excel for accountants and finance teams — it writes macros, Power Query and formulas from plain English, and connects two-way to QuickBooks, Xero, Zoho Books, Odoo, FreshBooks and Sage. The 15-day trial is the full product, no card required.