Merging 1
Merging2
Merging3

Merge Data with EXMERG

Merging data from multiple Microsoft Excel worksheets or CSV files is now problem of the past. Use simple Drag&Drop instead of complicated macros and formulas.

  • Drag workbook into browser
  • Let the magic happen
  • Export merged data
Start Your Workspace

or explore our NEW Data Merging service Gridoc (Beta):

Free Data Merging

It’s easy !

Merge data from different Workbooks, Worksheets or CSV files

Merging data from various workbooks is one of the most frequent challenges spreadsheets users encounter.
There are a few options how to merge data in MS Office Excel or one of it’s free alternatives. The problem is that these options (like VLOOKUP function) doesn’t scale automatically with your data.

Merging data with EXMERG

EXMERG provides Drag&Drop interface which enables you to focus on your data instead of figuring out how to merge them.

Our customers

Needing to merge four exported CRM csv worksheets, it was a daunting task and I would consider myself a power Excel user. Excel seemed to make it harder than it needed to be so a quick browse and I came upon Exmerg which brought together the fields easily. A quick “concatenate and sort” afterwards and I saved hours of painstaking copy and pasting. Thanks!
Ben Kirk, Operations ManagerBrian Tracy Global
Really love that the site is user-friendly and easy to use but yet is really powerful under-the-hood!
The tool was exactly what I needed! It worked flawlessly and was extremely easy to use. Thank you!
I’ve always struggled with how to merge multiple Excel files into one without resorting to some sort of statistical program like SPSS. Your website did the job BEAUTIFULLY. I bookmarked it and will be returning the next time I need to do something like that.
Jake Moskowitz, Ph.D. StudentUniversity of California, Irvine

1. Upload your Workbook or CSV files

Simply drag&drop the spreadsheet files into the upload area.

EXMERG - Drag worksheet_mod

Let’s go step by step to see how to merge data based on common columns.

2. Example: Merge data from sample files

Following example uses sample files which can be added to workspace by clicking Workspace – Add Sample Files in app.exmerg.com.
Click Merge Data in the Productivity Tools panel on the right – new Merge Data panel will open up.

Now we are going to create matching rule. For the matching rule we need 2 columns – Left column and Right column.
Drag header of the desired column into the Left column area. This will automatically load data from the original table into the merging table.

EXMERG - merging - add column1_mod

Next, switch to the other workbook.

EXMERG - merging - add workbook2_mod_mod

Choose column which you want to match with the Left column, and drag header of that column into the Right column area.

EXMERG - merging - add column2_mod

The matching rule is now complete and it is being applied to the data in the orginal worksheets.

EXMERG - merging - result2

Following matching rules are currently available:

  • Equals to (include all rows)
  • Equals to (include only matching rows)
  • Equals to ignore case (include all rows)
  • Equals to ignore case (include only matching rows)

Use the “include only matching rows” rules to only include rows which contain matching values.

Merged data can be exported into CSV or XLS formats.

EXMERG - merging - export_mod

You can export or save up to 6,000 rows each month for free.

Start Now

You can use multiple matching rules at the same time.

For example in the picture below, we created second matching rule for columns Items on stock and Sold items.

Only rows which are valid by both matching rules will be included in the merged data.

EXMERG - merging - second rule_mod

Did anything go wrong while merging your data? Call us today at +421 918 972 459 or Email us at help@exmerg.com

Get in touch and let us know how we can help.
Mobile Analytics
© Copyright 2014-2015 BITFICTION, s.r.o.