How to Transfer a Pipe Delimited Text File to Excel

Save

A delimited file is one that uses a character to establish the beginning and ending of a section of the file. Some common delimiters are tabs, commas and pipes. A pipe looks like "|." A comma-delimited file is known as a CSV file, which stands for "comma separated value." A transfer of a pipe delimited file into Excel requires that the file be imported. Delimiters are also used in programming languages to distinguish the beginning and ending of a section of code.

  • Open the Excel sheet to which you will import the data and click on the "Data" tab in the ribbon. In the "Get External Data" section, click "From Text." Select the text file and click "Import."

  • Check that "Delimited" is selected in the Text Import Wizard and click "Next>."

  • Check the check-box next to "Other:" and type the "|" symbol in the box. Uncheck any other delimiters. Click "Next>."

  • Select the type of data format. Choose "General," "Text" or "Date" and then click "Finish."

  • Choose the cell in which to place the data and click "OK."

References

Promoted By Zergnet

Comments

You May Also Like

Related Searches

M
Is DIY in your DNA? Become part of our maker community.
Submit Your Work!