Results 1 to 10 of 10

Combine many .csv files into one excel sheet

Threaded View

  1. #1
    Registered User
    Join Date
    02-27-2018
    Location
    Kenya
    MS-Off Ver
    2016
    Posts
    14

    Combine many .csv files into one excel sheet

    Hello everyone
    Please can you help me:
    I have more than 100 files with tables (format .csv, find some of them attached) and I need to combine them into one excel sheet, putting them in many columns like in "All stations together.xlsx". I can copy and paste but I have so many other files like that and it will take me and eternity. Can someone help me with a code?
    Thank you
    PS: No need to repeat the first column of each .csv and the files names are not necessarily St0, St2, St3....they may change to other names.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Combine the second sheet of a few files into one worksheet.
    By shir02 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-03-2017, 12:06 PM
  2. Combine Excel files into Single sheet (values only) add column for filename
    By supremesabre in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-18-2017, 11:48 AM
  3. Need VBA: Combine excel files to 1 sheet
    By navafolk in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-05-2016, 10:06 AM
  4. VBA to combine the first sheet of numerous excel files into one master document
    By Peep_Show_Fan in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-29-2016, 11:37 AM
  5. Replies: 0
    Last Post: 10-12-2015, 10:02 AM
  6. Excel vba to tel adobe combine two pdf files based on a spcified list of files
    By Abbadon486 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-30-2014, 12:04 PM
  7. [SOLVED] Combine data of some cells in multiple excel files into one sheet
    By ricdamiani in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 08-07-2013, 12:07 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1