Merge Multiple Excel Files

[vem234]

I have a few hundred Excel and CSV files that I would like to merge
into one master file xls file. Is there a macro or software for the
Mac that can do this? I know there are windows software available,
but I have found nothing for the Mac. I am using OS X 10.4.

 

[Bob Greenblatt]

I have a few hundred Excel and CSV files that I would like to merge
into one master file xls file. Is there a macro or software for the
Mac that can do this? I know there are windows software available,
but I have found nothing for the Mac. I am using OS X 10.4.

What do you mean "merge"? Append? What needs to be done with duplicates?
What will the total number of records? What version of Excel?

 

[vem234]

What do you mean "merge"? Append? What needs to be done with duplicates?
What will the total number of records? What version of Excel?

I would like to append each file into the master. So, if file 1 has 20
rows of data and file 2 has 35 rows of data, after a merge, i would
like file 3 (which has 40 rows of data) to start on row 56. Each
file's data needs to be filled in the master going down the rows.

Duplicates can remain; I can sort this out later. I have 600 files
and each has from 40-500 rows of data. I am using Mac Office Excel
2004. Thank you.

 

[Bob Greenblatt]

I would like to append each file into the master. So, if file 1 has 20
rows of data and file 2 has 35 rows of data, after a merge, i would
like file 3 (which has 40 rows of data) to start on row 56. Each
file's data needs to be filled in the master going down the rows.

Duplicates can remain; I can sort this out later. I have 600 files
and each has from 40-500 rows of data. I am using Mac Office Excel
2004. Thank you.

You would have to write a macro to do this. If it is Excel 2004, you can use
VBA. You say there are windows macros available, try one of them, it will
probably work with some minor changes. Remember that you can only have
65,535 rows in Excel 2004. If it is Excel 2008, you can write (or have
someone write) an xlm macro to do this.

 

[mac4417]

The only Mac program that I know of is Excel File Merger. We use this program (I think it costs $10 or $12) to merge 2000 excel files on a monthly basis and it works flawlessly. Do a google search for the site to download. As far as I remember, there is a free demo that you can download as well. The program will merge csv, xls and txt files. Not bad for ten bucks!

 

[golfshoe]

You would have to write a macro to do this. If it is Excel 2004, you can use
VBA. You say there are windows macros available, try one of them, it will
probably work with some minor changes. Remember that you can only have
65,535 rows in Excel 2004. If it is Excel 2008, you can write (or have
someone write) an xlm macro to do this.

The only Mac program that I know of that will do this is Excel File
Merger. We use this program (I think it costs $10 or $12) to merge
roughly 2000 excel files on a monthly basis and it works flawlessly.
Do a google search for the software. As far as I remember, there is a
free demo that you can download as well. The program will merge csv,
xls and txt files. Not bad for twelve bucks!