Introducing The Law Community, the online community just for Clio customers. Sign up now.

How Do I Open an LSA Report File in Excel?

Objective:

  • How can I view a Law Society of Alberta CSV Report?
  • Viewing LSA the Report in a readable format

Environment:

  • Clio Manage

Additional Information:

The LSA Report generates a Pipe Delimited file which use pipes, or the "|" symbol as a delimiter, whereas most CSV files use commas as the delimiter.

For more of Delimiter-Separated Values, see here

Answer:

  1. Download the LSA Report file as a CSV
  2. Open Excel
  3. Click File
  4. Click Open
  5. Choose the file downloaded in step #1
  6. Select Column A
  7. Click the Data tab
  8. Click Text to Columns
  9. Select Delimited
  10. Click Next
  11. De-select Tab
  12. Check the Other checkbox
  13. Enter a Pipe "|" in the Other box
  14. Click Next
  15. 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