import CSV files to Excel

Discussion in 'Perl Misc' started by Slickuser, May 20, 2008.

  1. Slickuser

    Slickuser Guest

    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.
     
    Slickuser, May 20, 2008
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Michal Mikolajczyk
    Replies:
    0
    Views:
    907
    Michal Mikolajczyk
    Feb 13, 2004
  2. Larry Bates

    Re: import Excel csv - files

    Larry Bates, Nov 30, 2005, in forum: Python
    Replies:
    2
    Views:
    453
    Micah Elliott
    Nov 30, 2005
  3. Tintin92
    Replies:
    1
    Views:
    2,120
    Andrew Thompson
    Feb 14, 2007
  4. Replies:
    7
    Views:
    2,968
    Roedy Green
    Jun 28, 2007
  5. =?Utf-8?B?c2hhc2hhbmsga3Vsa2Fybmk=?=

    Problem with Excel reports ::::Excel 2003 Migration To Excel 2007

    =?Utf-8?B?c2hhc2hhbmsga3Vsa2Fybmk=?=, Oct 5, 2007, in forum: ASP .Net
    Replies:
    15
    Views:
    1,940
    =?Utf-8?B?c2hhc2hhbmsga3Vsa2Fybmk=?=
    Oct 24, 2007
  6. jliu66
    Replies:
    0
    Views:
    747
    jliu66
    Oct 19, 2007
  7. sso
    Replies:
    20
    Views:
    3,158
    Martin Gregorie
    Apr 26, 2009
  8. Tim
    Replies:
    1
    Views:
    458
    Peter Otten
    Jul 5, 2010
Loading...