Excel Video: How To Do Data Consolidation In Excel You can use Excel's Consolidate feature to consolidate your worksheets (located in one workbook or multiple workbooks) into one worksheet.