This article may be out of date!
Visit the New Knowledge Center

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 Manage
  • 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