Lawyers from all 50 states, and 27 countries have registered for the Clio Cloud Conference. Get your pass today!

How Do I Open an IIF File in Excel?


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


  • Clio Web App
  • Excel
  • View contents of a Quickbooks Desktop import file

Additional Information:



  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