.png)
.png)
Open up a QuickBooks IIF file in Excel
Sep 08, 2019
12127
QUESTION
Can a QuickBooks IIF file be opened in Excel?
RESOLUTION
The following steps allows an IIF file to be opened in Excel.
- Save the IIF file locally
- Open Microsoft Excel and in Excel, select FILE > OPEN
- In the drop down for file type, change to ALL FILES (*.*)
- Browse and select the IIF file
- When the Text Import Wizard appears, select DELIMITED and NEXT
- Select TAB as the DELIMITER
- Select FINISH
- Select FILE > SAVE AS and change the SAVE AS type to an Excel workbook
