How can I merge data from two Excel spreadsheets?

Gustavo Ibargüengoytia October 8, 2011

I have two Excel spreadsheets that have the same columns, but different rows and different values for the corresponding cells.

Is there an easy and free way to merge the data?

Data is not numbers that need it be added, it’s text like names, addresses, phone numbers, etc.

Thanks.

  1. Anonymous
    October 9, 2011 at 8:24 am

    You can use the VLOOKUP function
    Excel/Merge column data from two spreadsheetshttp://en.allexperts.com/q/Excel-1059/2009/4/Merge-column-data-spreadsheets.htm

    • Anonymous
      October 9, 2011 at 5:47 pm

      Thanks hal4.

      The VLOOKUP wasn't quite what I was looking for, I'll give JMC a try later on one the trial for the DigDB plug in expires ;)

    • Anonymous
      October 9, 2011 at 5:47 pm

      Thanks hal4.

      The VLOOKUP wasn't quite what I was looking for, I'll give JMC a try later on one the trial for the DigDB plug in expires ;)

  2. Jay
    October 9, 2011 at 7:39 am

    try these guides :
    http://office.microsoft.com/en-us/excel-help/consolidate-data-in-multiple-worksheets-HP010095249.aspx

    http://msdn.microsoft.com/en-us/library/cc793964%28v=office.12%29.aspx

    http://www.accountingweb.co.uk/anyanswers/how-do-i-combine-worksheets-excel

    http://support.microsoft.com/kb/211802

    This microsoft help  is about joining two files...
    so you can move the data of your spreadsheet to a file and then merge both the files.
    you just have to go to second spread sheet and save it as a new file.

    http://www.digdb.com/excel_add_ins/join_merge_tables_lists/
    JOINING TWO TABLES. you will have to move data of second spreadsheet to a table.

    • Anonymous
      October 9, 2011 at 5:46 pm

      Thank you, Jay.

      The guides didn't do what I was looking for, but the plugin did it. Now I have one master file.