Was this page helpful?
Thank you!

Comments or suggestions?

Enter Email Address (optional)

Intuit Interchange Format (.IIF) files

Intuit Interchange Format (.IIF) files are ASCII text, CSV files that QuickBooks Desktop uses to import/export lists and to import transactions. The .IIF import and export utilities are on the QuickBooks Desktop File menu.

Importing and exporting .IIF files created by QuickBooks Desktop is fairly easy because QuickBooks Desktop formats the file for you. However, creating .iif files from scratch or adapting data from another program is technically complex and may be difficult if you don't have experience formatting delimited text files. In that situation it may be faster and easier to enter the information directly into QuickBooks Desktop unless you have very large amounts of data to import.

Detailed instructions

Ready to get started?

The import kit is probably a good choice if you think you're ready. The detailed .iif header information may help, too. If you're not sure, you can also look at the next section for more information.

Importing information through .iif format can be tough so you should:

Need more information?

Importing and exporting data using .iif format can be very tricky. Learn more about .iif format:

What you can do with iif files:

  • Export lists from one QuickBooks company file and import them into another
  • Import lists or transactions into QuickBooks from another program
  • Export list to and Import data from the  QuickBooks Pro Timer.
  • Share data between different QuickBooks editions and platforms (such as Pro, Premier, and Enterprise, or between Windows and Mac)



KB ID# HOW12778
9/26/2016 5:16:04 AM
QYPPRDQBKSWS03 9138 Pro 2017 a21bd7