You are using an unsupported browser. Please update your browser to the latest version on or before July 31, 2020.
close
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 allows an IIF file to be opened in Excel.
 
  1. Save the IIF file locally
  2. Open Microsoft Excel and in Excel, select FILE > OPEN
  3. In the drop down for file type, change to ALL FILES (*.*)
  4. Browse and select the IIF file
  5. When the Text Import Wizard appears, select DELIMITED and NEXT
  6. Select TAB as the DELIMITER
  7. Select FINISH
  8. Select FILE > SAVE AS and change the SAVE AS type to an Excel workbook
 
Feedback
3 out of 9 found this helpful

scroll to top icon