How to Export Item Data from QuickBooks Desktop

If you use QuickBooks Desktop to manage your accounting, there will be times when you need to get your data out of the software — into Excel, a CSV file, or another system entirely.

Maybe you need to analyze your item list in a spreadsheet. Maybe you are migrating to a new platform. Maybe your accountant needs a copy of your inventory data for a review. Or maybe you simply want a clean backup of your products and services outside of QuickBooks.

Whatever the reason, QuickBooks Desktop gives you several ways to export item data — and knowing which method to use for which situation saves you significant time and frustration.

This guide walks you through every method to export item data from QuickBooks Desktop, step by step, with clear instructions you can follow right away.

Why You Might Need to Export Item Data from QuickBooks Desktop

Item data in QuickBooks Desktop includes your products, services, inventory items, non-inventory items, and other charges. This data drives your invoices, sales receipts, purchase orders, and financial reports.

Here are the most common reasons accounting professionals and business owners export item data from QuickBooks Desktop:

Analysis in Excel. QuickBooks Desktop's built-in reporting is useful, but Excel gives you more flexibility for sorting, filtering, pivot tables, and custom calculations. Exporting your item list to Excel lets you analyze pricing trends, inventory levels, and product performance in ways QuickBooks alone cannot easily support.

Data backup. Keeping a copy of your item data outside of QuickBooks is smart practice. If your company file gets corrupted or lost, an exported copy of your item list helps you recover faster. As covered in QuickBooks Desktop backup best practices, maintaining external copies of key data is an essential part of any accounting data protection strategy.

Migration to another system. If you are moving to a new accounting platform or a different version of QuickBooks, you will need to export your item list to import it into the new system.

Sharing with your accountant or team. Sometimes the fastest way to share a snapshot of your item data is through an exported Excel or CSV file — especially when the recipient does not have direct access to your QuickBooks file. There are better ways to do this permanently, which we cover in the Qbox section below.

Bulk updates. Exporting your item list to Excel, making bulk price changes, and then importing it back is much faster than editing items one by one inside QuickBooks.

What Types of Item Data Can You Export?

QuickBooks Desktop allows you to export the following types of item data:

• Inventory items — products the business buys and sells, with quantity tracking
• Non-inventory items — products bought or sold but not tracked in inventory
• Service items — services billed to customers
• Other charge items — shipping, handling, and miscellaneous charges
• Subtotal, group, and discount items — used in invoices and sales forms
• Sales tax items and sales tax groups — tax rates applied to transactions

All of these appear in your QuickBooks Item List and can be exported using the methods below.

Method 1 — Export the Item List to Excel Using the Item List Screen

This is the fastest and most direct method to export your item list from QuickBooks Desktop.

1. Go to Lists in the top menu bar
2. Select Item List
3. At the bottom of the Item List screen, click the Excel button
4. A dropdown appears with two options:
• Export all items — exports your complete item list
• Import items from Excel — for importing, not needed here
5. Select Export all items
6. In the Export window, choose Create a new worksheet to export to a new Excel file, or Update an existing worksheet if you want to update a file you have already exported before
7. Click Export
8. Excel opens automatically with your complete item list

Your exported file will include item names, descriptions, types, rates, accounts, and any other fields associated with each item. This method is the quickest way to get a full copy of your item data into Excel in just a few clicks.

Method 2 — Export Item Data Using the Item Listing Report

This method gives you more control over which fields and columns appear in your export — making it ideal when you need specific data for analysis or review.

1. Go to Reports in the top menu bar
2. Select Lists from the dropdown
3. Choose Item Listing
4. QuickBooks generates a report showing all items with default columns — item name, description, type, price, and account
5. To customize the columns, click Customize Report at the top left of the report window
6. In the Modify Report window, go to the Display tab
7. In the Columns list, check the fields you want to include — useful options include Cost, Preferred Vendor, On Hand quantity, and Reorder Point
8. Uncheck any columns you do not need
9. Click OK to update the report
10. At the top of the report, click the Excel dropdown
11. Select Create New Worksheet
12. Click Export

This method is especially useful when you need to export QuickBooks Desktop item data with specific fields for inventory reviews, pricing audits, or sending to a vendor.

Method 3 — Export Lists to IIF Files Using File Utilities

QuickBooks Desktop also lets you export your entire item list as an IIF (Intuit Interchange Format) file. This format is designed for importing lists into another QuickBooks company file — making it the right method when you are setting up a new company file or migrating data between files.

1. Go to File in the top menu bar
2. Select Utilities
3. Choose Export
4. Select Lists to IIF Files
5. A window appears showing all exportable list types. Check Items (you can also select other lists at the same time if needed)
6. Click OK
7. Browse to the location where you want to save the file
8. Give the file a name and click Save

The IIF file saves to your chosen location. You can open it in a text editor or Excel. When you are ready to import it into another QuickBooks file, go to File → Utilities → Import → IIF Files in the new file and select your saved IIF.

Note: Export each list separately rather than combining multiple lists in one export. Exporting very long combined lists can sometimes cause issues. For more on managing QuickBooks Desktop files across multiple users and locations, see how to share QuickBooks files with your team — which covers the broader file management challenges that come with multi-user QuickBooks Desktop setups.

Method 4 — Export Item Data as a CSV File

If you need a CSV file instead of an Excel workbook — for example, to import into a non-Microsoft system — QuickBooks Desktop supports CSV export too.

1. Run the Item Listing report following the steps in Method 2
2. Customize the columns as needed
3. Instead of clicking the Excel dropdown, look for the Export button or use the Excel dropdown and select Create New Worksheet
4. In the Send Report to Excel window, select Create a comma separated values (.csv) file
5. Click Export
6. Name your file and choose a save location
7. Click Save

The CSV file opens in Excel or any spreadsheet program, or can be imported directly into another software system.

This is the correct approach when the destination system requires CSV format — common for inventory management tools, ERP systems, and certain data migration workflows.

How to Customize Your Item Export for Better Analysis

A clean, well-structured export saves you time when you open the file in Excel. Here are a few tips to get the most useful output:

Select only the columns you need. A report with 20 columns when you only need 6 creates unnecessary cleanup work. Use the Customize Report function to check only the fields you will actually use.

Apply filters before exporting. If you only want active items, or only inventory items, apply those filters in QuickBooks before exporting. The Filters tab in the Modify Report window lets you narrow down by item type, account, or status.

Sort before exporting. Click any column header in the report to sort by that field before exporting. This saves sorting time once the file is in Excel.

Use descriptive file names. Name your exported files with the date and item type — for example, "Item_List_Aug2026.xlsx" — so you can track versions easily over time.

Common Issues When Exporting QuickBooks Desktop Item Data

Excel export limit. QuickBooks Desktop has a row limit on Excel exports based on older Excel format constraints. If you get an error about too many rows, try exporting in smaller batches by filtering the item list first, or save as a CSV file which does not have the same row limit.

Missing columns in the export. If your exported file is missing columns you expected, go back to Customize Report and confirm those fields are checked in the Display tab.

Excel is not installed or outdated. QuickBooks Desktop exports directly to Excel. If you get an error related to Excel, make sure Microsoft Excel is installed and up to date on the same computer.

IIF file not importing correctly. If an IIF file fails to import into another QuickBooks company file, open the IIF in a text editor and check for any unusual characters or formatting issues. QuickBooks Community forums are a reliable source for specific error codes during IIF import.

Exported data looks different from what you see in QuickBooks. This usually means the report date range or filters were set differently from what you expected. Go back, reset the report, and re-export. For related QuickBooks Desktop navigation tips, QuickBooks Desktop keyboard shortcuts can help you move through reports and lists faster during data export tasks.

How Qbox Helps You Share and Manage QuickBooks Desktop Data

Exporting item data is useful for one-time snapshots and analysis. But if your team or your clients need ongoing access to the same QuickBooks Desktop file — not just a static export — a better approach is to share the live file directly.

Qbox is accounting collaboration software built specifically for QuickBooks Desktop users. Instead of exporting data and emailing files back and forth, Qbox lets your entire team access the same QuickBooks company file from anywhere — securely and in real time.

QuickBooks Desktop File Sharing With File Locking

Qbox syncs your QuickBooks Desktop files automatically between all authorized users. When one user opens the file, Qbox locks it so no one else can write to it at the same time. The moment they close the file after making changes, Qbox syncs the updated version instantly to every other user. Everyone always works on the most current version. No exports needed for collaboration. No version conflicts. No corrupted files. This is exactly what how Qbox works for QuickBooks file sharing describes — a clean, automatic system for keeping your entire team on the same file at all times.

Secure File Sharing for Exported Reports

When you do export data — item lists, reports, financial statements — Qbox lets you share those files securely with clients and team members through an encrypted file sharing system. No emailing sensitive data as attachments. Every file is protected. Every download is logged. Learn more about how to share custom QuickBooks reports securely — and why Qbox is a much safer and more organized way to deliver exported QuickBooks data to clients and stakeholders.

Secure Client Portal

Give every client their own portal to receive exported reports, financial statements, and item lists — and to upload supporting documents. Everything stays organized, encrypted, and tied to the right client record.

Task Management

Build a recurring task list for data export and reporting workflows — from running the item listing report to delivering the final file to the client. Every step has an owner and a due date. Nothing gets missed.

Conclusion

Exporting item data from QuickBooks Desktop is straightforward once you know which method fits your purpose. Use the Item List Excel export for a quick, complete item list. Use the Item Listing report when you need specific fields and filters. Use the IIF export when you are migrating to a new QuickBooks company file. Use CSV export when your destination system requires it.

The key steps to remember: always back up your QuickBooks file before any major data operation, customize your columns before exporting to reduce cleanup work, and use the right format for your destination — Excel for analysis, IIF for QuickBooks migration, CSV for other systems.

And when your team needs more than a static export — when they need live, ongoing access to the same QuickBooks Desktop file — Qbox gives you a secure, automatic way to make that happen without the back-and-forth of manual file sharing.