How to Export Quickbooks to CSV on a Mac

You can create CSV text files from data in a Quickbooks item list.

Quickbooks is a financial computer application developed by the Intuit corporation that is designed to help small business owners keep all of their financial information organized. The Quickbooks application is compatible with both the Windows and Mac OS X operating systems. In addition, you can export items from a Quickbooks file to other formats. For example, you can export a list of Quickbooks items into a comma-separated values file, also known as a CSV.

Things You'll Need

• Mac running OS X 10.5 or later
• Quickbooks 2011

Instructions

1. Launch the Quickbooks application from the Dock or the Applications folder.

2. Go to "Lists" in the menu bar at the top of the screen and choose "Item List."

3. Click on the "Excel" button at the bottom of the list.

4. Choose the "Export All Items" option in the dialog box that appears.

5. Set the file type field in the popup window to the "CSV file" setting.

6. Enter a name for the exported file, then navigate to the location on your hard drive where you want to save it.

7. Press the "Export" button to convert the item data into the CSV format and save it to your local hard drive.

References

• Quickbooks Support: Export items to an Excel or CSV file