Open up a QuickBooks IIF file in Excel - Transaction Pro Technical Support

Emails from our Customer Support team will be sent from [email protected].

To ensure you receive important updates without interruption, please add [email protected] to your safe sender list and mark it as “not spam.”

Home > Tips and Tricks > Open up a QuickBooks IIF file in Excel

Open up a QuickBooks IIF file in Excel

Apr 15, 2025

13906

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

Feedback

3 out of 10 found this helpful

Need additional information

Hard to understand

Inaccurate/irrelevant content

Missing/broken link

Tags

Import (278) Tips and Tricks (24) IIF (2)