How to Convert Text Files to Columns in Excel

Objective:

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

Environment:

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

Procedure:

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"