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. Advertising

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:
    686
    Michal Mikolajczyk
    Feb 13, 2004
  2. Skip Montanaro
    Replies:
    0
    Views:
    753
    Skip Montanaro
    Feb 13, 2004
  3. Larry Bates

    Re: import Excel csv - files

    Larry Bates, Nov 30, 2005, in forum: Python
    Replies:
    2
    Views:
    400
    Micah Elliott
    Nov 30, 2005
  4. Replies:
    7
    Views:
    2,593
    Roedy Green
    Jun 28, 2007
  5. Joel Goldstick
    Replies:
    0
    Views:
    117
    Joel Goldstick
    Feb 28, 2013
Loading...

Share This Page