Was this page helpful?
Thank you!

Comments or suggestions?

Enter Email Address (optional)

Export items to an Excel or CSV file



About exporting data to an Excel or CSV file.

From the Item List, you can export data about the items you buy and sell.

What fields are exported?

QuickBooks exports all item fields that can be imported except for the Reimbursable Charge and As Of (Date) fields.

An easy way to update your items and their prices is to export your Item List to an Excel or CSV file, update the information, and then import the file.

To do this task
  1. Choose Lists > Item List.

  2. At the bottom of the window, click the Excel drop-down arrow and select Export All Items.

  3. In the Export window, choose whether to create a new worksheet, update an existing worksheet, or export to a comma separated values (.csv) file.

  4. Click the Export button.

See also

3/28/2017 5:04:47 AM
QYPPRDQBKSWS05 9138 Pro 2017 1a45ed