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.
About importing data from an Excel or CSV file
About exporting data to an Excel or CSV file
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.