Was this page helpful?
Thank you!

Comments or suggestions?



Enter Email Address (optional)
email

About exporting data to an Excel or CSV file

export

Excel

QuickBooks can export data about the people you do business with and the items you buy and sell. It can even export transactions and reports.

Note: Exporting to an Excel file requires Microsoft Excel 2000, 2002, 2003 or 2007.

During export, you decide whether QuickBooks should create an Excel file or a CSV (comma-separated values) file. Each column in the Excel or CSV file corresponds to a field of QuickBooks data. Once the data is in the file, you can further analyze and modify it as needed.

CSV files are simple text files containing tabular data. Each field in the file is separated from the next by a comma. Most spreadsheets support this format, although you can create and edit CSV files with any text editor. Files in the CSV format end with the .csv suffix. Both QuickBooks and Microsoft Excel can easily import and export files of this type.

See also

An easy way to update information about your customers, vendors, and items is to export the data to an Excel or CSV file, make your changes, and then import the file.

What type of data do you want to export?

KB ID# H_EXCEL_ABOUT_EXPORT
9/17/2014 6:33:29 AM
PPRDQSSWS401 9102 Pro 2013 c39556