You are using an unsupported browser. Please update your browser to the latest version on or before July 31, 2020.
close
You are viewing the article in preview mode. It is not live at the moment.
Need immediate help? Phone support is available between Monday and Friday from 9am to 9pm EST at 888-297-6172
Home > Tips and Tricks > Open up a QuickBooks IIF file in Excel
Open up a QuickBooks IIF file in Excel
print icon
QUESTION
 
Can a QuickBooks IIF file be opened in Excel?
 
RESOLUTION
 
The following steps allow an IIF file to be opened in Excel.
 
  1. Save the IIF file locally
  2. In Microsoft Excel, go to File and select Open.
  3. In the File type dropdown, select All Files.
  4. Select the IIF file you want to edit, then select Open.
  5. In the Text Import Wizard, select Next, then Next and Finish.
  6. Make the changes to your IIF file.
  7. Go to the File menu, select Save, then Yes.
  8. Exit Excel. You'll get a prompt to save the IIF again. Select Don't Save.
 
Feedback
3 out of 10 found this helpful

scroll to top icon