When troubleshooting a LEDES text file, it is helpful to view the information in columns. If you open the file in Excel, it is possible to see the columns. Here is an example of how to open the LEDES text file in Excel. First open Excel. Then Select “Open” and find the correct File Name. In this example, the file is called “Sample Corridor Credit Note”. Please make sure you are looking for “All Files” as shown.
The Text Import Wizard should open:
Select “Delimited”, then “Next”
Uncheck “Tab”, check the “Other” box, and enter “|” in the field; then click “Next”
Click “Finish”. Your LEDES file can be viewed and edited in columns now.
Replace all fields with your firm’s own information. The following instructions are credit invoice specific:
You must have Manager- level access or higher to access this information in Corridor. Please contact your firm’s Corridor admin if you do not have access.
Here is an example of a LEDES file that has been altered in Excel:
When opened in Notepad, you can see that it has been altered. The “|” characters are now missing in the LEDES file:
Select the space between the header descriptions, and type Ctrl + C, or Edit > Copy :
Type Ctrl +H or use the Edit > Replace:
For the “Find what” field, paste the spaces (that were copied previously). For the “Replace with” field, type “|”, then click Replace All.
Close the Replace box. Your LEDES file should look similar to this:
Most of the file looks like it has the correct formatting, however, the first line has some extra characters, which you can delete in Notepad.
Save As the file and check the encoding:
Please make sure the file is being saved as a txt and the encoding is ANSI. Click “Save”.
The file is now ready to be uploaded into Corridor.