Import Excel workbook

Question

How do I import multiple spreadsheets in an excel file?

Answer 1

Hi there

Based on your request/challenge, Power Query is the best solution in my opinion.

The video tutorials, in the links below, will guide you in finding a solution to your problem.

Get Multiple Files Containing Multiple Sheets with Power Query

Combine Files from a Folder with Power Query

I hope this helps you and gives a solution to your problem

Do let me know if you need more help

Kind Regards

Jeovany

Answer 2

Excel cannot import multiple worksheets from a single workbook in one step using the standard Data > Get Data > From File > From Workbook dialog; each object (worksheet, table, or named range) is selected and imported one at a time.

To bring in data from multiple sheets, use one of these approaches:

1. Import each sheet (or named range) separately
   • In the source workbook, optionally define named ranges for each area to import:
     1. Open the workbook.
     2. Select the cells for the first sheet’s data.
     3. Right‑click the selection and choose Name a Range or Define Name.
     4. Enter a name and select OK.
   • Repeat for each sheet/range.
   • In the destination workbook, use Data > Get Data > From File > From Workbook, then select each worksheet or named range and import it. Repeat for each object.
2. Use Power Query to combine multiple files (if data is split across files)
   • If the “multiple spreadsheets” are actually in multiple workbooks in a folder, use:
     1. Data > Get Data > From File > From Folder.
     2. Browse to the folder and confirm all files are listed.
     3. Choose Combine > Combine & Load.
     4. In Combine Files, pick a sample file and the object (worksheet/table) to use.
     5. Select OK to automatically consolidate into one query.

When all sheets are in one workbook, they must still be selected and imported individually (or first split into separate files and then combined via folder import).

---

References:

• Import data from a folder with multiple files (Power Query)
• Import or link to data in an Excel workbook