I know there are ways out there somewhere but im having the hardest time finding it.
I have multiple CSV files.
All CSV files in the same folder.
All with different file names
All with a single tab in them, the tabs are labeled with the file name. (ABC.csv has a single tab in it called ABC).
How can i merge all the CSV files into a single XLS file where all the CSV files are on their own seperate sheet tab?
Last edited by PY_; 08-19-2010 at 02:25 PM.
Depends on how many, if it's less than 100, quickest way is to open them all, then right-click the sheet tab in one - move or copy - move to some chosen one, repeat for all others except your chosen workbook.
You will need to save as (not save) and save as an excel workbook not csv, csvs can only be one 'sheet'
If it's more, a macro would be more appropriate but I'll wait to hear on that...
hth
CC
If you feel really indebted please consider a donation to charity. My preferred charity is ActionAid but there are plenty of worthy alternatives.
I wrote this a couple days ago for someone in another thread. Just edit the fPath to where the CSV files are stored.
Published on my site here:
Please Login or Register to view this content.
CSVs to Sheets
Last edited by JBeaucaire; 05-14-2013 at 09:31 AM. Reason: Final edits to the code.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Originally Posted by JBeaucaire
That worked beautifully! Thank you so much for the help.
Any idea how i can make it run in XL 07? XL03 runs fine but i get this in 07:
Runtime error 1004
Cannot insert the sheets into the destination because it contains fewer rows and columns than the source workbook?
Your original workbook (into which you are importing needs to be XL07 (i.e. xlsm)).
.xls files can't have as many rows & columns as your source data (evidently...)
2003 it is then for this process.
Thanks for the tip.
Used this macro in excel 2010, worked like a charm...this is exactly what I was looking for. Thanks!
Re: Merge Multiple CSV files to one XLS with multiple tabs
Hi, there, I want to merge excel files in one folder into a new created excel folder.
is there a way to do them automatically?
if it is possible write me a code in java as opposed as macros. thanks in advance.
Welcome to the Forum, unfortunately:
Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Thanks Jerry, It worked perfectly!!
That's great code!! It helps me so much in my project and I can have much more time to work on other things. Thanks for your help
Re: Merge Multiple CSV files to one XLS with multiple tabs
Can You please help me , when I am trying to run Macro (XL 2010)with Suggested Code , Nothing Happen !!
Thanks in Advance.
The original code includes a line of code:
Make sure you edit that to point to the folder where your CSV files are before you run the macro, and when you edit, remember to leave the final \ at the end.Please Login or Register to view this content.
If that doesn't work, start a new thread of your own, post your version of the code in that thread for any helpers to see.
I've just found this 10 years on from the original post and it works perfectly. Thank you.
This works fine :-) But I want to add all the data in the new workbook, not in the current workbook please guide me
murthycode welcome to the forum
Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.
If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.
Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
First of all - Thank you for your work!
I am using Office 2016 via O365
When I run this macro, it finds all of the CSV files, but opens them in separate workbooks rather than a single workbook/separate tabs
Thanks again for the help!
alterkation,
Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.
If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.
Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
Ben Van Johnson
Yes it sure does work perfectly! 11 years on.
Hi everyone,
How can I get this code running on Excel for Mac 2016?
rsm21 welcome to the forum
Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.
If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.
Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks