Import multiple *.tsv files into one excel file

**bing.pascual** · 07-24-2013, 02:13 PM

Hi guys!
I badly need your help. Here's what I need to do:
I need to import several *.tsv files in a folder into one excel file.
The *.tsv file that will be imported contains several columns. But I only need some columns from this file to be imported in the excel file.
Thank you.

**patel45** · 07-25-2013, 02:31 AM

attach a sample CSV (not tsv) file and define columns to be imported

**bing.pascual** · 07-25-2013, 04:19 AM

Attached is a sample file. I just need to import Columns T to AA and AC to AD of the said file.
Thanks in advance.

**patel45** · 07-25-2013, 12:25 PM

Try this code for only one file

Please Login or Register  to view this content.

**bing.pascual** · 07-25-2013, 01:00 PM

Thanks for the prompt reply. But how about for multiple files?

**patel45** · 07-26-2013, 01:57 AM

you are in hurry, does that code works well ?

Import multiple *.tsv files into one excel file

LinkBack

Thread Tools

Rate This Thread

Display

Import multiple *.tsv files into one excel file

Re: Import multiple *.tsv files into one excel file

Re: Import multiple *.tsv files into one excel file

Re: Import multiple *.tsv files into one excel file

Re: Import multiple *.tsv files into one excel file

Re: Import multiple *.tsv files into one excel file

Thread Information

Users Browsing this Thread

Similar Threads

Import multiple jpg files in one file with file name in next cell

[SOLVED] Import text files to Excel file

Import data from multiple Excel files to 1 Excel file.

How to import data from multiple Excel files to one Excel file

Import files on a:\...display in Excel file ? ...

Bookmarks

Bookmarks

Posting Permissions