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

How Do I Open a LEDES File in Excel?

Objective:

  • How can I view a LEDES Bill?
  • Viewing LEDES in a readable format

Environment:

  • Clio Manage
  • Microsoft Excel

Additional Information:

The LEDES files use 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 Bill from Clio to the LEDES format
  2. Open Excel
  3. Click File
  4. Click Open
  5. Choose the file downloaded in step #1
  6. Select Delimited
  7. Click Next
  8. De-select Tab
  9. Check the Other checkbox
  10. Enter a Pipe "|" in the Other box
  11. Click Next
  12. 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