Go Back   The macosxhints Forums > OS X Help Requests > Applications



Reply
 
Thread Tools Rating: Thread Rating: 3 votes, 5.00 average. Display Modes
Old 10-02-2008, 07:27 AM   #1
martar
Prospect
 
Join Date: Mar 2008
Posts: 2
Merge Multiple Excel (xls) and Csv Files into One

Hello,

I have a couple hundred excel and csv files that I would like to merge or combine into one master file. Each file has different column headings. I would them to append to each other - in other words, have the data rows extend downward for each file. Is there a program or macro to do this? I have both Microsoft Office 2004 and 2008. Now that Office 2008 no longer supports macros, this option is out for 2008.

I know there are Windows programs to do this but I have no clue how to do in in OS X. I don't want to get tangled up in VBA, maybe an applescript would be good. I would appreciate your help.
martar is offline   Reply With Quote
Old 10-02-2008, 02:32 PM   #2
macosnoob
MVP
 
Join Date: Jan 2007
Posts: 1,872
Because the CSVs are text files, you can combine with them with the cat command in Terminal:

cat a.csv b.csv c.csv > outputfile

Or, if you have no other .csv files in that directory:

cat *.csv > outputfile

Then bring outputfile back into Excel and resave it in XLS format for one big file.

As for XLS files, massage those into CSV files with something like MacLinkPlus, then cat those, too. There may be free/shareware alternatives to MacLinkPlus that you can use to translate XLS to CSV quickly.
macosnoob is offline   Reply With Quote
Old 10-06-2008, 10:18 AM   #3
RFI234
Registered User
 
Join Date: Oct 2008
Posts: 1
You can download the Excel File Merger program and this will merge multiple xls, or txt, or csv files. We used to have to merge 600-700 customer csv files manually and this software does it in 3 seconds. I am not proficient in programming or techno savvy.
RFI234 is offline   Reply With Quote
Old 12-20-2012, 02:31 PM   #4
popwatson
Prospect
 
Join Date: Apr 2009
Posts: 5
Thanks

Thanks so much macosnoob, really saved me hours of work there - genius!
popwatson is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump



All times are GMT -5. The time now is 10:43 PM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.
Site design © IDG Consumer & SMB; individuals retain copyright of their postings
but consent to the possible use of their material in other areas of IDG Consumer & SMB.