In this article, I am going to show, how can we export Delimited Text Files in Excel. For Example, you have a file which is Comma delimited Text file or Pipe Delimited Text File etc. This file you want to export in to Excel in such a way that Delimiter is treated as a Column. It mean wherever it finds the delimiter, rest of the Text is put in next Cell (towards Column).

Follow the below Steps to Export a delimited files in Excel:
Example: For Example i have taken one Text File, which is Pipe Delimited as shown below:

Pipe Delimited Notepad

Pipe Delimited Notepad



Step 1. Select any Cell from where you want your File to be Exported.
Step 2. Go to Data Tab

Pipe Delimited - Data Tab

Pipe Delimited - Data Tab



Step 3. Click on “From Text” Option
Step 4. Now Browse your File and Click OK

Pipe Delimited - Select Delimited Text Files

Pipe Delimited - Select Delimited Text Files



Step 5. Choose option as “Delimited” as highlighted below and Click Next

Pipe Delimited - Choose Option as Delimited

Pipe Delimited - Choose Option as Delimited



Step 6. Here Select any one of the Delimiter Like Tab, Semicolon, Comma and Space. If your Delimiter is not one of these Values then Select Delimiter as “Other” and Type the Delimiter in the Highlighted Textbox.

Pipe Delimited - Select your Delimiter

Pipe Delimited - Select your Delimiter



Note: In the Above case i have Types Delimiter as “Pipe Sign” (|). You can give any character which is used as Delimiter in your Delimited File.

Step 7. Click Next

Pipe Delimited - Select Default Options

Pipe Delimited - Select Default Options



Step 7. Finish.
Step 8. Now Select the Cell Address From Where you want to Export your Data. By Default, it will have the same address which is selected in Step 1.

Pipe Delimited - Select your Start Address

Pipe Delimited - Select your Start Address


Now you can see that all the data is Exported in Excel.

Pipe Delimited - After Exporting the Data in Excel

Pipe Delimited - After Exporting the Data in Excel