Merge Add-in for Excel 2016 or higher for the Mac
Briefly! RDBMerge is a user friendly way to Merge Data from Multiple Excel
workbooks into a Summary Workbook.
workbooks into a Summary Workbook.
Download add-in for Excel 2016 or higher
Note: RDBMerge is available as freeware. But you can use the Contact button in the menu if you want to support the development of this merge add-in.
Mac Excel 2016 and higher
RDBMerge for Excel 2016 or higher for the Mac, version 3.0
File date : 9-Dec-2019
File date : 9-Dec-2019
How to install the Add-in after you unzip it on your Mac
Prepare your Mailing List. If you have already created a mailing list in Excel, then you can safely skip. For more info, see Prepare your data source in Excel for a mail merge in Word for Mac. Outlook Contact List contains data in a format that can be read by Word. See Use Outlook contacts as a data source for a mail merge. Word data file is a data source you can create on the fly, within Word. For more info, see Set up a mail merge list with Word.
- Open Excel 2016 or higher
- Update Excel (See button in the Help menu)
- Use Tools>Excel Add-ins... in the menu to open the Add-ins dialog
- Use the Browse button to select the add-in and choose Open
- Press OK
- Done
Note: If you copy the Add-in in the Add-ins folder it will be automatic in your Add-ins dialog list, for finding this folder see : Setup your Mac for Mac Office 2016 or higher
Read the information below good
You can find a button named RDBMerge Add-in to open the add-in on the Data tab on the Ribbon. Important : 'Enable all macros' in Excel>Preferences>Security if you want to merge files that contain VBA code. There is a bug in Mac Excel that not trust if a installed add-in in Excel for the Mac opens other workbooks with code like this merge add-in does, and I not think you like to click on allow in the security warning dialog that pop up for every file you want to merge. Be aware that if you uncheck this checkbox that it always open files with code without a warning.
Also the location of the files you want to merge is important in Excel 2016 or higher because of Apple’s sandbox requirements, read this page and use a folder in your Office folder.
How to use the RDBMerge Add-in Step by step
Recover Excel File Mac
Folder Location:
In the folder location section click on the Browse button and select the folder with the files you want to merge. After you do that you see the path returned in the UserForm. You can also set the level of subfolders in the dropdown (max of 9)
Which Files:
In the section “Which Files” select the type of files in the dropdown that you want to merge. If you use the first option 'XL?' it will merge all type of Excel files (xls, xlsx, xlsm, xlsb). But you can also only merge files with a specific extension in the folder. By default the option to merge all files in the folder is selected but you can also use the option to filter on the file names or to select the files you want to merge.
Which worksheet(s):
In this section you have the option to choose the worksheet by index or name. If you use the index 1 it will use the first worksheet in each file, you not have to know the worksheet name this way. You can also merge data from all worksheets or use the filter option to filter on the worksheet names.
Which range:
You have the option to merge a fixed range (can be more than one area). Click on the Tips button for more information. Or use the First cell ? till last cell on worksheet option, you can change the start cell. Use A2 for example if you not want to copy your header each time.
Different options:
Before we press on the Merge button we have a few options here that you can change.
The Add file name checkbox will add the file name or file and sheet name before or above your data. You can use it for example to filter the Summary sheet for the data from a certain file.
To avoid problems with formulas I suggest you always check Paste as values.
If your workbooks have links to other workbooks use the UpdateLinks option to update the values.
Use the Paste data next to each other option if you want paste the data from each file next to each other instead of below each other. If you set your fixed range for example to A1:A100 and check this check box it will use one column for each file in the combine sheet. If your range have two columns it will use two columns for each file in the combine sheet.
If your workbooks have an Open password you can fill in the open/modify password in the two text boxes, it is no problem if there are also workbooks with no password in the folder.
Click on the Merge button:
When you click on the Merge button it will create a new workbook for you with two worksheets:
Combine Sheet with all the data
Log Sheet with copy/paste and error information
Then it is up to you if you want to save this workbook.
You see it is very easy to work with this add-in, testing all options with a few files in a test folder is the best way to get familiar with this add-in. If you have problems or have suggestions let me know and I try to help you.
In the folder location section click on the Browse button and select the folder with the files you want to merge. After you do that you see the path returned in the UserForm. You can also set the level of subfolders in the dropdown (max of 9)
Which Files:
In the section “Which Files” select the type of files in the dropdown that you want to merge. If you use the first option 'XL?' it will merge all type of Excel files (xls, xlsx, xlsm, xlsb). But you can also only merge files with a specific extension in the folder. By default the option to merge all files in the folder is selected but you can also use the option to filter on the file names or to select the files you want to merge.
Which worksheet(s):
In this section you have the option to choose the worksheet by index or name. If you use the index 1 it will use the first worksheet in each file, you not have to know the worksheet name this way. You can also merge data from all worksheets or use the filter option to filter on the worksheet names.
Which range:
You have the option to merge a fixed range (can be more than one area). Click on the Tips button for more information. Or use the First cell ? till last cell on worksheet option, you can change the start cell. Use A2 for example if you not want to copy your header each time.
Different options:
Before we press on the Merge button we have a few options here that you can change.
The Add file name checkbox will add the file name or file and sheet name before or above your data. You can use it for example to filter the Summary sheet for the data from a certain file.
To avoid problems with formulas I suggest you always check Paste as values.
If your workbooks have links to other workbooks use the UpdateLinks option to update the values.
Use the Paste data next to each other option if you want paste the data from each file next to each other instead of below each other. If you set your fixed range for example to A1:A100 and check this check box it will use one column for each file in the combine sheet. If your range have two columns it will use two columns for each file in the combine sheet.
If your workbooks have an Open password you can fill in the open/modify password in the two text boxes, it is no problem if there are also workbooks with no password in the folder.
Click on the Merge button:
When you click on the Merge button it will create a new workbook for you with two worksheets:
Combine Sheet with all the data
Log Sheet with copy/paste and error information
Then it is up to you if you want to save this workbook.
You see it is very easy to work with this add-in, testing all options with a few files in a test folder is the best way to get familiar with this add-in. If you have problems or have suggestions let me know and I try to help you.
If you want VBA code examples see this page : Merge Excel workbooks on a Mac
Save yourself some time, and merge .csv files with one easy command in Terminal.
Let's say you have a bunch of .csv files in a folder. You want to merge them into one file. How to do that?
Easy: use 'cat'
Cat is a UNIX program that lets you concatenate files, which is what we need. It's so simple that you don't need installable apps for it. For those who want the code first and the explanation later, here is the code:
That's it.
Merge Excel Files For Macs
Translated, it says: 'take all files in this folder that end with '.csv', and put them in 'merged.csv' (effectively merging them).
Bonus tip: the 'open here in Terminal' service in Mac OS X 10.7+
It is important that this command is executed in the right directory. You don't want all existing .csv files in your entire computer to be altered this way, now do you? :) You can use the terminal to navigate to the folder (as described below), but you can also use a default Mac OS X service that functions in much the same way as its counterpart in Windows: 'open here in Terminal'. It works like this.
First, go to:
System Preferences > Keyboard > Shortcuts > Services
and select New terminal at Folder
:From now on, when you select a folder in the Finder, you can right-click and find it under
Services
:We want more images!
Here are some images that may help. I had a bunch of .csv files that contained exports of Google search engine results (made by the SEOmoz toolbar). The English results were all put in a folder named
en
inside the folder /meta/csv
:I also made sure that every single .csv only contained the data I needed. In my case, I needed to delete the first 7 rows that were included in every export:
Back to the terminal. I used
cd
to go to that folder in my terminal (or use the 'New terminal at Folder' Service I described earlier):You can see it below, i'm at
macbook en
(the folder en
on my macbook) and my username is monchito
. I then executed the command:The file
merged.csv
was successfully added to the folder:A quick check shows that the newly created .csv file contains way more rows than the individual files, so it probably worked :p
Now I can merge a great number of .csv files into one file quickly, and move on with my analysis.
What's next?
If you think this was useful to you, it might be for others also. Feel free to share: