Can I Import Data to QuickBooks From Microsoft Excel?

Yes, subject to certain limitations.

You can only import list data into 1 of 4 lists:

1. Customers
2. Vendors
3. Items
4. Accounts

You can import either in Microsoft’s supported workbook format (.xls or .xlsx, depending on your version of Excel) or CSV format.

Intuit offers a free Import Excel and CSV Toolkit, which includes a PDF manual, CSV and .XLS example import files, and a reference guide explaining field names. It’s a compressed executable file, which extracts those files when run. Additional information is available in this Intuit knowledgebase article.

You can use another import file type, Intuit Interchange Format (IIF), to import unlinked transactions. See our article on the capabilities of IIF files for more information.

   [ +1 rating, 1 votes ]

 Loading ...

You May Also Be Interested In ...

1. Is QuickBooks Compatible With Microsoft Office 2010? (9.8)
2. Securely Upload Data Using an Accountant’s Copy File (5.8)
3. What Does the Clean Up Company Data Utility Do? (5.8)