How to Open up a QuickBooks IIF file in Excel

QuickBooks Online > Intuit App Center - Transaction Pro Importer for QuickBooks Online
You may need to open up an QuickBooks IIF file in Excel to edit it or to save it to Excel.  Below are the steps on how to accomplish this.
 
Step 1:  Save the IIF file to your local computer
 
Step 2:  Open up Microsoft Excel and in Excel select File and then Open
 
Step 3: In the drop down in the lower right change the selection to:  All Files: 
 
 
Step 4:  Select the IIF file.
 
Step 5:  When the Text Import Wizard pops up select delimited and next.
 
 
Step 6:  Select Tab as  the Delimiter and then select Finish.
 
 
 
Step 6:  Select File and then Save as.  Change the Save As type to an Excel workbook.
 
 
 

Add Feedback