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

How to Convert Text Files to Columns in Excel


  • Convert a LEDES Bill to a readable format
  • Convert a LSA Trust Report to a readable format
  • View a text file within Excel


  • Excel

Additional Information:

Please note that the LEDES Bills and LSA Trust Reports will still need to be uploaded to their respective destinations in the original downloaded format.


  1. Open the file within Excel
  2. Select column "A"
  3. Select the Data tab
  4. Select "Text to Columns"
  5. Select "Delimited"
  6. Select "Next"
  7. Check the box for the appropriate delimiter(For LEDES and the LSA Report this will be "Other", and the field for "Other" should be "|")
  8. Select "Next"
  9. Select "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