Apr 15, 2025
QUESTION
Can a QuickBooks IIF file be opened in Excel?
RESOLUTION
The following steps allow an IIF file to be opened in Excel.
- Save the IIF file locally
- In Microsoft Excel, go to File and select Open.
- In the File type dropdown, select All Files.
- Select the IIF file you want to edit, then select Open.
- In the Text Import Wizard, select Next, then Next and Finish.
- Make the changes to your IIF file.
- Go to the File menu, select Save, then Yes.
- Exit Excel. You'll get a prompt to save the IIF again. Select Don't Save.
For more details on Importing, Exporting, and Editing IIF files: https://quickbooks.intuit.com/learn-support/en-us/help-article/import-export-data-files/export-import-edit-iif-files/L56LT9Z0Q_US_en_US