Excel File Merger is a nifty application for Macintosh (Mac OS X, Jaguar, Panther, Tiger and Leopard) which easily and efficiently merges hundreds or thousands of Excel (xls), Text (txt), or Comma delimited (csv) files into one master file.
With a very simple user interface, all your files can be combined with the click of a mouse.
How Does it Work?
The user selects the file type to be merged (.xls, .csv, or .txt file) and selects the folder containing these files and then chooses the resulting merged file name and location. Then, hit the merge button.
Who needs this Application?
If you're stuck with a thousand xls, csv, or txt files and need one combined file, this is the application for you. Excel File Merger appeals to those in finance, commerce, web scraping, scientists (who often obtain scientific data in csv or txt format), accountants and others working with numerous spreadsheets.
Whether your csv, txt, or xls files are created on a Windows PC or a Mac, Excel File Merger will run the merge.
FAQ
Q: Does Excel FIle Merger work with files created in Office 2008?
Yes, if fact, it will work on any Microsoft Excel file or any other csv/txt file generated on a Mac.
Q: How does this application handle workbooks with multiple sheets?
Prior to running the merge, all sheets in a given workbook need to be combined using conventional macros programming (or, do it manually). When all files to be merged contain one sheet, the merge with other files can begin.
Q: Does this application work on Windows PC?
No, not at this time.
Q: Can Excel File Merger merge csv, txt, or xls files created on a Windows machine?
Absolutely, as long as it is an xls , csv, or txt file.
Q: How are the merged files inserted into the unified , merged file?
Intelligently ! Once the last set of data is inserted into a specific row, the next file starts inserting in the row below thereby eliminating overlaps. Files are merged sequencially according to the order within a folder.
Q: Do all spreadsheet files need to have the same row heading?
No, Excel File Merger will take care of files with different row headings and different number of columns and rows. Formatting, however, will be lost in the merge.
Q: If I open a merged csv or txt file, it looks garbled, why?
Csv and txt files are flat files. To make some sense out of them, the files need to be opened in Excel. Excel will recognize these files as binary, flat files and the text import wizard will allow you to open and view the file in the proper format. Files should then be saved in the proper format for future work.
Version 1.1 (9/3/2008)
Minimum System Requirement: Mac OS X 10.3 and newer
Testimonials I merge customer database files to prepare for mailings. Every month, we send out about 50,000 pieces to 20 different markets across the country. Each of these markets has 2 CVS files of data. In the past, we had to open 40 files in Excel and literally copy and paste. Now, in 2 seconds (including the time it takes to launch the program), all of my data is in one nice clean file that I can sort and e-mail off to my mail house. This monthly task has gone from 20 minutes down to just a few seconds. Mailings used to be pure drudgery and I'd put them off due to not having that 20 minute chunk of time to prepare the file. But now I look forward to mailings because it's painless. My customers will never get a late mailer again! The best $12 investment I've ever made in my business. - Jeff R., 4/29/08 The software worked well. it was just what i was looking for. Thank you for creating it and charging only $12. - LG, 4/11/08 |