• Skip to primary navigation
  • Skip to main content

QBGarage.com

The QuickBooks Specialists

  • Home
  • Blog
  • KnowledgeBase
  • Company
  • Show Search
Hide Search
You are here: Home / KnowledgeBase / QuickBooks Files / Importing & Exporting Data / Can I Import Data to QuickBooks From Microsoft Excel?

Can I Import Data to QuickBooks From Microsoft Excel?

Chief Mechanic · August 23, 2010 ·

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.

Vote This Post DownVote This Post Up (+3 rating, 3 votes)
Loading...

Importing & Exporting Data, KnowledgeBase, QuickBooks Files CSV, IIF, Microsoft, XLS

Reader Interactions

Comments

  1. Rebecca says

    December 17, 2014 at 12:54 pm

    I was having this problem and others trying to get excel into quickbooks. Is this thread still active?

    • Chief Mechanic says

      December 19, 2014 at 11:36 pm

      You’re welcome to comment on your experiences, and we do our best to clarify content in the original post, but we’re not able to provide QB support in these comments.

  2. Joy Peoples says

    October 14, 2014 at 2:52 pm

    You do have capabilities of importing bills, journal entries, etc. However, header and footer line are required.

  3. sam says

    March 26, 2013 at 9:21 pm

    Hi dear,
    I have time and attendance software for employee attendance. For payroll I want to import attendance file to QuickBooks. I can generate file CVS and Excel format. I don’t know the field structure required by QuickBooks any help appreciated.
    Sam

    • Chief Mechanic says

      April 10, 2013 at 8:37 pm

      QB imposes a lot of limits on payroll data. The links in our article are the best information we have for CSV imports. You can also research using the Intuit SDK, but that will require programming in an advanced language.

Accounting

  • Financial Accounting Standards Board

Developer

  • Intuit Developer Network Forums
  • qbXML Onscreen Reference

Intuit

  • Enterprise Solutions
  • Intuit
  • Intuit Marketplace
  • QuickBooks
  • QuickBooks Online Community

QBGarage.com

Copyright © 2008–2023 QBGarage.com · Privacy · Terms & Conditions · Site Help