The files that QuickBooks exports and imports are text files. import files^IIF, IIF file format, importing data, about, moving, data into QuickBooks, . The best way
to view an export or import file is to open it from a spreadsheet
program—that way, you'll see the data laid out into rows and columns.
If you don't have a spreadsheet program, you can also view an export file
in a word processor.
IIF import resources
There are additional resources available online to help you create and use IIF files:
IIF Import Kit
When you
download the import kit, you get an import manual, IIF header help, and sample IIF files.
QuickBooks Community Forum
List of FAQs about common issues users face using IIF files. import files^IIF, IIF file format, importing data, about, moving, data into QuickBooks, .
Search the forum to see if your question has been answered. import files^IIF, IIF file format, importing data, about, moving, data into QuickBooks, .
Browse through thousands of discussions between QuickBooks users who have imported IIF files.
Can't find the answer you need?
Post a question in the Import/Export Forum.
When you view the file, you'll see keywords in capital letters that
serve as row and column headings. import files^IIF, IIF file format, importing data, about, moving, data into QuickBooks, . The keywords that appear at the beginning of
each row identify the type of information in that row. import files^IIF, IIF file format, importing data, about, moving, data into QuickBooks, . For example, the keyword
CUST indicates that the row contains data about a customer on your Customers & Jobs
list.
Rows that begin with the same keyword are grouped together. import files^IIF, IIF file format, importing data, about, moving, data into QuickBooks, . For example, all
of the CUST entries from your Customer:Job list appear as a single block of
rows in the file. import files^IIF, IIF file format, importing data, about, moving, data into QuickBooks, . Each block, in turn, has its own column headings that appear
in capital letters in the cells of the first row in the block. import files^IIF, IIF file format, importing data, about, moving, data into QuickBooks, . The column
headings identify the type of information that each column in the block
contains.
For details about the column headings that belong to a particular block of
information, click the keyword for that block in the list below:
See also