Export QuickBooks Invoices to Excel (Online & Desktop)

Last updated June 2026.

QuickBooks does not let you export a single invoice straight to Excel. Instead, you run an invoice report and export the whole list. In QuickBooks Online, open the Invoice List report, set your date range, then choose Export to Excel. In QuickBooks Desktop, open the report and use the Excel dropdown to send it to a worksheet. The catch most people hit: the standard invoice list drops the line items, so to keep product and service detail you export the Sales by Customer Detail report filtered to invoices instead.

Below are the exact steps for both QuickBooks Online and QuickBooks Desktop, how to keep your line items, and what to do when the spreadsheet comes out missing data.

Export methods at a glance

How to export invoices from QuickBooks Online to Excel

QuickBooks Online exports a report of invoices, not a single document. The fastest route is the built in Invoice List report.

1. In the left menu, select Reports.
2. In the search box, type Invoice List, then open the report when it appears.
3. Click Filter or Customize to set the date range, a specific customer, or the invoice status you want.
4. Select the Export/Print dropdown in the upper right of the report.
5. Choose Export to Excel. The .xlsx file downloads to your computer.
6. Open the file. If the columns look empty, click Enable Editing to leave Excel's Protected View and reveal the full report.

If you would rather start from the sales screen, hover over Sales, click All Sales, change the type to Invoices, set your dates, then export. You get the same list either way.

How to export invoices from QuickBooks Desktop to Excel

QuickBooks Desktop sends reports to Excel through an Excel dropdown built into the report toolbar, which gives you a bit more control over formatting.

1. Open QuickBooks Desktop and go to the Reports menu.
2. Type Invoice List in the search box and press Enter, or open the Reports Center and double click the report you want.
3. Set the Report period (date range) and any filters such as customer or item.
4. Select the Excel dropdown at the top of the report.
5. Choose Create New Worksheet to open a fresh workbook, or Update Existing Worksheet to refresh a file you already built.
6. If you see a message that the report has too many columns, click Advanced, uncheck Space between columns, then click OK.
7. Click OK or Export to send the report into Excel.

The workbook opens in Excel 2016 or later, Mac Office 365, or Apple Numbers 3.5 and up. Once it is open you can sort, filter, and build PivotTables on the data like any other spreadsheet.

How to export invoices with line items to Excel

This is the part that trips up most people. The standard invoice list shows one row per invoice with the total only, not the individual products or services on each line. To get every line, switch reports.

1. Go to Reports and open Sales by Customer Detail.
2. Click Filter, set Transaction Type equals Invoice, then run the report.
3. Adjust the date range and the columns so you can see product or service, quantity, rate, and amount.
4. Select Export to Excel (Online) or the Excel dropdown (Desktop).

You now have the invoice header data plus every line item in one spreadsheet, which is what most people actually mean when they ask to export their invoices. If you only need totals by customer or by month, the plain Invoice List report is lighter and faster.

Getting PDF and scanned invoices into Excel

Exporting works when an invoice already lives inside QuickBooks. The harder problem is the stack of vendor invoices that arrive as PDFs, email attachments, or paper scans and were never entered. You cannot export what you never recorded, and retyping dozens of bills to get them into a spreadsheet is exactly the manual work most teams are trying to cut.

That is where invoice OCR fits. It reads a PDF or scanned invoice and turns it into structured rows you can open in Excel or CSV, with the header fields and every line item, no typing. From there you can analyze the spend or load it into your books.

• Use our invoice PDF to Excel converter to turn a folder of vendor PDFs into clean spreadsheets in seconds.
• When you need every product line and not just totals, invoice line item extraction captures quantity, rate, and amount per row.
• Ready to push the data into your accounting file? Follow how to import PDF invoices into QuickBooks or import invoices into QuickBooks from a spreadsheet, and see the full convert invoices to QuickBooks workflow.
• Comparing tools first? Start with our invoice OCR software overview.

Invoices are not the only finance documents you will want in a spreadsheet. To pull transactions off PDF bank statements, a bank statement to Excel converter does the same job for statements, and you can send those statements straight into your accounting file with a PDF bank statement to QuickBooks (.QBO) converter. For expense receipts, receipt OCR software turns photos and PDFs into the same kind of Excel rows.

Can I export an invoice to Excel from QuickBooks?

Not a single invoice on its own. QuickBooks exports a report of invoices rather than one document, so you run the Invoice List report (or Sales by Customer Detail for line items) and export that list to Excel. To share one invoice, save it as a PDF instead, or use invoice OCR to convert a PDF invoice into Excel rows.

How do I export multiple invoices from QuickBooks at once?

Run an invoice report and export the whole report. In QuickBooks Online open the Invoice List report, set your date range, then choose Export to Excel. In QuickBooks Desktop open the same report and use the Excel dropdown. The export already includes every invoice in the date range, so there is no need to handle them one at a time.

Does QuickBooks export invoice line items to Excel?

The standard Invoice List report does not include line items; it shows one row per invoice with the total. To export line item detail, run the Sales by Customer Detail report, filter Transaction Type to Invoice, then export to Excel. That report keeps the product, quantity, rate, and amount for each line on every invoice.

Why is my QuickBooks invoice export missing data in Excel?

The most common cause is Excel's Protected View, which opens downloaded files in a locked state. Click Enable Editing to reveal the full report. If line items are missing, you exported the Invoice List report instead of Sales by Customer Detail. In QuickBooks Desktop, a too many columns warning can also blank cells until you uncheck Space between columns.

Can I convert a QuickBooks invoice to Excel automatically?

Yes. For invoices already in QuickBooks, schedule or rerun the report export. For the PDF and scanned invoices that never reached QuickBooks, an invoice OCR tool converts them to Excel or CSV in bulk, capturing headers and line items, so you can analyze the data or import it into QuickBooks without manual typing.