import CSV files to Excel

Slickuser

Guest

Posts: n/a

05-20-2008

I have roughly around 2000 files of CSV (each file is in the range of
49bytes-10MB, 117218 lines), a total of ~35MB.

I would like to import each CSV file to an individual sheet in Excel
workbook.

Is it best to open each CSV file, add new sheet, copy & paste to Excel
workbook?

After that, I will do all text formating, sorting, and hyper links for
all sheets.

Thanks.

Thread Tools
Show Printable Version Email this Page

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Re: Import web content to csv only if values are different from thoseof an excel sheet	Joel Goldstick	Python	0	02-28-2013 07:13 PM
How can I import XML or CSV, or TXT files into an E-Mail Client	Zygon Curry	Computer Support	5	01-21-2007 03:51 PM
Re: import Excel csv - files	Larry Bates	Python	2	11-30-2005 05:39 PM
Re: csv writerow creates double spaced excel csv files	Skip Montanaro	Python	0	02-13-2004 08:50 PM
csv writerow creates double spaced excel csv files	Michal Mikolajczyk	Python	0	02-13-2004 08:38 PM