This article explains how to import to QuickBooks from an Excel or comma separated values (.csv) file. Windows based QuickBooks allows you to import your data from a Microsoft Excel worksheet or from a .csv file into four different lists:
It can be faster as well as easier to import these through the window Add/Edit Multiple List Entries.
In the event you need to import a list of transactions or other types of lists, or you are a QuickBooks for Mac user, you need to use the Intuit Interchange Format files (.IIF). For information on how to use .IIF, visit the Intuit support center article http://support.quickbooks.intuit.com/support/Articles/HOW12778.
QuickBooks has a reference guide on how to create and work with CSV and Excel files. It is titled the “QuickBooks Import Excel and CSV toolkit”. This kit contains:
- A PDF doc with best practices, notes and instructions titled Import From Excel and CSV Manual
- A sample CSV file for each of the four types of lists mentioned above. In the toolkit, this aid is titled CSV Examples Folder
- A sample Excel file for each type of list mentioned above. In the toolkit this is titled XLS Example Folder
- A guide that explains what fields you can use for CSV and Excel imports. In the toolkit, this is titled Allowed Fields
To quickly and efficiently learn how to import to QuickBooks, you should install the QuickBooks Import Excel and CSV toolkit using these detailed instructions:
- Open the toolkit File Download window and then click on Save
- Navigate to your Windows Desktop and click on Save
- To open your WinZip Self Extractor window, double click on the saved file on your desktop.
- Now click on Browse and choose a folder that you want to use to install this toolkit (your Desktop for example) and then click on OK.
- To extract the contents of the file, click on Unzip. Now click on Close so the Winzip Self Extractor window will close
- Open the folder you selected in the fourth step and open the file QuickBooks Import Excel and CSV.
If you need additional help and are having problems importing a CSV or Excel file into QuickBooks and need more information on how to import to QuickBooks, contact our local QuickBooks Pro Advisor in your area for help. They are highly qualified to resolve any issues you are facing in QuickBooks or the bookkeeping/accounting cycle.