KCS - How Do I Open an IIF File in Excel?

Objective:

  • Export IIF file from Clio for Quickbooks Desktop, then read in a spreadsheet program

Environment:

  • Clio Web App
  • Excel

Additional Information:

n/a

Procedure:

  1. Download the IIF File from Clio
  2. In Excel, under File select Open
  3. Under File Name ensure All Files is selected
  4. Select the IIF File
  5. Click Open
  6. Click the My data has headers checkbox
  7. Click Next
  8. Under Delimiters select Tab 
  9. Click Finish

 

Was this article helpful?
This information is confusing or wrong
This isn't the information that I was looking for
I don't like this functionality