import tab delimited text files into excel but skip first 5 lines

**alexbotea2005** · 11-27-2011, 04:46 AM

Is there a way to import into Excel a tab delimited text file but skip the first 5 lines?
The file has up to 91 columns
Also I would like to import only certain columns let's say column 3, 5 and 9.
Attached is an exmple of the file that I would like to import into excel.
Thanks in advance for your help.

**pike** · 11-27-2011, 06:15 AM

Hi alexbotea2005
Welcome to the forum

the easy was is to use the recorded macro are the change the start row to 5

Please Login or Register  to view this content.

**alexbotea2005** · 11-27-2011, 02:34 PM

Thanks for your help, the script that you've sent works fine. If possible I would like to be able to import only certain columns of the text file in column B, E and G. I was trying to use the bellow code:

Please Login or Register  to view this content.

I don't know how to tell the script to skip first 5 lines and to split each textline by tab.

**snb** · 11-27-2011, 03:54 PM

Please Login or Register  to view this content.

**alexbotea2005** · 11-27-2011, 05:37 PM

Thanks for your reply,
The code that you’ve send imports the entire text file without header into a new workbook.
I’m trying to add only couple columns from the text file to an existing workbook in columns A, B, C and G.
To clarity, I have attached an excel file with to sheets:
- “file1-original” : has the original text file imported manually and tab separated
- “Data” : is the sheet where the data needs to be imported.
Thanks,
Regards
Alex

**pike** · 11-28-2011, 02:08 AM

or just replace the ones with 9 in the column you dont need

Please Login or Register  to view this content.

**pike** · 11-28-2011, 02:11 AM

should have been

Please Login or Register  to view this content.

**alexbotea2005** · 11-28-2011, 03:49 AM

The above script worked perfect for a blank sheet. Only problem is that the sheet I need to update has other formulas / data between the columns that are filled in from the text file (see Import-text-file.xls file “Data” sheet - that was attached on a previous post) and array puts all the columns one next to each other.
Best Regards
Alex

**pike** · 11-28-2011, 04:54 AM

Hi alexbotea2005
The problem is that its a file1 should be saved as a csv file
you can open in in excel as save as a csv file or change the extention
then this will do the trick

Please Login or Register  to view this content.

**alexbotea2005** · 11-28-2011, 05:22 PM

It's a good starting point from which I will have to figure out how to implement it.
Thanks for your time,
Best Regards
Alex

import tab delimited text files into excel but skip first 5 lines

LinkBack

Thread Tools

Rate This Thread

Display

import tab delimited text files into excel but skip first 5 lines

Re: import tab delimited text files into excel but skip first 5 lines

Re: import tab delimited text files into excel but skip first 5 lines

Re: import tab delimited text files into excel but skip first 5 lines

Re: import tab delimited text files into excel but skip first 5 lines

Re: import tab delimited text files into excel but skip first 5 lines

Re: import tab delimited text files into excel but skip first 5 lines

Re: import tab delimited text files into excel but skip first 5 lines

Re: import tab delimited text files into excel but skip first 5 lines

Re: import tab delimited text files into excel but skip first 5 lines

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions