Here, you’d like to merge the data from each spreadsheet into just one sheet in one spreadsheet with the same set of columns, lets say we want columns A to F to be:
More than a few and copy/paste becomes a real pain, as does converting them all to CSV files, so using VBA code may be your best option.įor step by step instructions on how to do each of these, including example spreadsheets, please have a look at How to merge Excel files with the same columns. Which option you choose really depends on how many spreadsheets you have to merge.
Some of the variations are discussed in the following sections so read on to find what you need.
Or maybe your needs are more complex and you need to merge spreadsheets that have different formats, de-duplicating rows as you go. Maybe you just need all the rows from each spreadsheet into one, consolidated, workbook. What you need from a merge can vary from situation to situation. The first thing to work out is what type of merge you want to do. There are some useful features in Excel such as 'Consolidate' and 'Remove Duplicates' but these often don't quite hit the mark. If you’ve got several Excel files that you need to merge (or worksheets in a workbook), you might be having a hard time working out how to do it.