Merge Excel files into one online

1. Open your files on xlCompare.com

   To start using this tool you need to open your files on this page. Drop your file into FILE 1 area or select it on disk by clicking Open button. Also, you can paste your data from clipboard into the worksheet. xlCompare.com uses clipboard as a universal way to exchange data.

   After file are opened, xlCompare.com has following look:

   

   If your worksheets are in the same file, you need to select worksheet using combo box below the worksheet window.

2. Select heading rows and key columns

   Merge Tables operation requires a key column(s) in both tables.

   Values in key column(s) identify the row in the table. Key columns define pairs of matching rows between FILE 1 and FILE 2.

   Heading Rows usually contain field names in table. This information is also used by xlCompare to find matching columns.

   Heading is optional. Merge Tables command can work without it.

   In our example tables with selected Heading and Key Column look like this:

   

3. Click the Merge Tables button to get the result

   After you've opened files or pasted your data and selected key columns, you need to click the Merge Tables command and xlCompare gives you the result.

   Below is the merged table for our example:

   

   All the columns from FILE 2 are moved into FILE 1 and values are inserted into the corresponding rows.

   If you don't need some columns - select them in this table and delete with a right click menu, exactly as you are doing this in Excel.

   

4. Save the merged table

   xlCompare uses clipboard to export data into the spreadsheet application you have on your computer - Excel, Numbers, etc.

   Use the Copy command above the FILE 1 table to copy the merged table into the clipboard and paste it into Excel to edit or save on disk.

5. Repeat this operation for the another worksheets

   If you need to merge more than one worksheet - select another worksheet in FILE 2 area and repeat the steps described above.

   In our example, we've merged third worksheet with other key columns:

   

   Key field for this worksheet is EMAIL