Submit a ticket
Login NRDR Portal

Convert an Excel File to a .TXT File

If you created a data file using Excel, you can use the following steps to convert the file to pipe-delimited text file. If this is your first time creating a file you may need to configure your computer to use the ‘|’ (pipe) character, rather than a comma, when converting the file.

  • Open the file in Excel and make sure there is a column header for all data elements, including any optional fields

  • Delete all worksheets other than the one with your data

  • Save the spreadsheet as a CSV (comma delimited) file

Save As Type CSV

  • Find the file you just saved, right click on it and rename it so the file extension is .txt rather than .csv

Note: If you cannot locate the file you just saved, and cannot see the file extension ending with .csv then use these instructions to change your computer’s display settings

  • After changing the file extension to .txt you may receive a warning message like the one below. Click Yes to proceed.

Rename Filename Extension Warning Message

Once your document is in .txt format you may upload it to the registry.

Previous: Web-based Data Transmission
Next: Change Windows Settings to
Show Filename Extensions

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.