Getting your data out of QuickBooks® and spreadsheets

The QuickBooks®-plus-spreadsheets setup is honest: the books in QuickBooks, and quotes, jobs, or orders in a workbook someone built years ago. When it stops scaling, the move to a real system starts the same way every migration does — with three things: access to the raw data, a way to export it to CSV or Excel, and a layout that says what each column means.

The spreadsheet side already is the export. QuickBooks takes a little more know-how.

QuickBooks Desktop

Lists come out easily

• File → Utilities → Export → Lists to IIF Files exports your Chart of Accounts, Customers, Vendors, and Items as tab-delimited text that opens straight in Excel. Know its limit: IIF exports lists only — never transactions, and it drops some fields, so treat it as a starting point.
• The Customer, Vendor, and Item Centers each have their own Excel export button, and those exports carry more fields than IIF does.

Transactions come out through reports

Any report exports to Excel or CSV from its Excel button. For history, the workhorses are Transaction List by Date and Transaction Detail — set the date range to All, customize the columns first (the export only carries what's on screen), then export. Two traps:

• CSV exports cut off around 32,700 rows, and older .xls exports cap at 65,536. If your history is bigger — and after a decade it is — export in date-range chunks: a year at a time works.
• Reports flatten transactions. The link between an invoice and the payment applied to it doesn't survive a report export — which usually doesn't matter for a migration, where open balances are what count.

If you run QuickBooks Enterprise, it includes an ODBC driver that exposes lists and transactions as queryable tables; Pro/Premier users can get the same via the third-party QODBC driver. For most shops the reports route is simpler.

QuickBooks Online

• Settings (gear) → Tools → Export Data produces a zip of Excel files with your lists and main reports — Intuit's built-in everything-at-once export.
• Every report has its own Export to Excel / CSV, and each list page (Customers, Vendors, Products & Services) has an export icon. For transaction history, run Transaction List by Date for All Dates and export it.
• There's no raw database access and no local file — QBO data lives in Intuit's cloud. If you're cancelling the subscription, do your exports first: post-cancellation access is limited.

The spreadsheet side

Your workbook needs no extraction — it needs shape. What makes workbook data convertible:

• One row per record — one quote, one job, one order line per row, not merged cells and section headers
• Consistent columns — the same thing in the same column on every row and every tab
• A key — some column (part number, customer name, job number) that ties rows to the QuickBooks side

Don't spend weeks cleaning it first. A converter can handle messy; what it can't handle is ambiguous. A one-page note saying what each column means — the table layout, in effect — is worth more than a month of manual tidying.

Then prove it moved correctly

Whatever comes out, verify what goes in: record counts first, then tie out open order value, A/R and A/P balances, and open POs against your old reports. The full verification routine is here.

QuickBooks® is a registered trademark of its owner. Its use here is for identification only and implies no affiliation or endorsement.