This article addresses how to import a vendor list into your QuickBooks Desktop company file utilizing the .IIF file format. This article does NOT address a QuickBooks Online company file.

An .IIF type of file (Intuit Interchange Format) is a type of file that QuickBooks Desktop utilizes to import and export lists.

So, to get started on creating a vendor list utilizing this file format, simply go to a current QuickBooks Desktop company file that already has a vendor list and:

1. File>Utilities>Export>Lists to IIF Files
2. Select “Vendor List” and then “OK”
3. Give this file a name and Save.

Now that you have created a vendor list in this .IIF format, it is time to import this list into a new QuickBooks Desktop (blank) company file.

**Note: However, If you first want to edit this list prior to importing, you will need to:

1. Open Microsoft Excel
2. File>Open
3. Click on Browse
4. Make sure on the File Type you choose “All Files” instead of just Excel Files.
5. Find the .IIF file and open
6. Next>Next>Finish
7. Make your changes.
8. Then, File>Save>Yes

Now, to import your .IIF vendor list into the new QuickBooks Desktop company file:

1. Open your new QB Desktop company file.
2. File>Utilities>Import>IIF files
3. Now go through all the prompts to import your new vendor list.

Note: AccuraBooks is a bookkeeping firm only, so please consult with your C.P.A. for verification and clarification about the contents of this article.