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

11/18/2017 5:58:11 AM
PPRDQSSWS901 9142 Pro 2018 9cc100