How to Export Delimited Text File in Excel

February 12, 2012| Posted by : | Filled in Excel Functions, Excel Tips

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



Related posts:

  1. Restrict to fixed text or integer length in the given range of cells Follow below steps to Restrict to fixed text or integer...
  2. How to run a .bat file (Batch File) by Excel Macro By executing the below code, you can run any .bat...
  3. How to restrict some key or Characters in text box in a Excel Macro When you are using Text Boxes in Excel Macros then...
  4. File Name Formula There are few instances when we want to store the...

Leave a Reply

Comments

comments