How to Transfer a Pipe Delimited Text File to Excel


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


Promoted By Zergnet


You May Also Like

  • How to Create a Pipe Delimited File

    Delimited files are useful for exchanging data, and businesses of all sizes widely use these files. What makes delimited files so useful...

Related Searches

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