Results 1 to 2 of 2

Importing multiple CSV files to Excel

This is a discussion on Importing multiple CSV files to Excel within the Excel Questions forums, part of the Question Forums category; I have a bunch of CSV files in a folder. I'd like to import each file into Excel using the ...

  1. #1
    New Member
    Join Date
    Jan 2014
    Posts
    7

    Lightbulb Importing multiple CSV files to Excel

    I have a bunch of CSV files in a folder. I'd like to import each file into Excel using the 'Import from Text' tool by typing the name of the file into a cell. I then need to format all of the data into a specific layout.
    All of the files are in the same folder and are identical in terms of headings used, number of entries, size etc. The final layout will also be identical each time, it's just a matter of getting the data from the CSV file into the correct places and applying the correct formatting.
    I have a template layout in a separate Excel workbook, so could either use this if possible or could apply the formatting from scratch within the macro.
    I've never written a VBA code before and am just starting out recording macros (the absolute basics) because I know that's the way to get automating processes like this. A suggestion on how to record this macro myself would be absolutely ideal, as a bunch of code with no explanation will be difficult for me to edit later if needs be, however any advice is much appreciated.

  2. #2
    Board Regular
    Join Date
    Jun 2009
    Posts
    157

    Default Re: Importing multiple CSV files to Excel


Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com