Tip of the Day | Monday 2 November 2026

Discover new tools to get things done.

Import Excel File into Workbook...

This tool lets you import all sheets from another Excel file into your current workbook.
The sheets from the selected file are added to the end of your workbook.
If a sheet with the same name already exists, a number in parentheses is added to the new sheet name to avoid duplication. For example, if your workbook already has a sheet named "Sales", the imported one will be named "Sales (2)".

This tool is useful when you want to:

  • Combine data from multiple workbooks
  • Merge sheets into one file for reporting or analysis
  • Quickly copy entire worksheets without opening both files

Note:
Any macros that may exist in the Excel file are ignored and not imported.

Starting this tool

Specify a Keyboard Shortcut: ASAP Utilities  › My Tools & Shortcuts › Manage My Tools & Shortcuts...

Tip:Alt+P for the previous tool.