Microsoft Excel — ASAP Utilities Add-In — Merge Multiple Files into 1 Sheet (Part 1)
ASAP Utilities to Data Analysis — Part 1
Scenario Use Case
The more you work with data, the more likely it becomes that you will need to import various data sources into one “source file”.
In this case, I have multiple Excel files — exactly the same structure and format — that I want in one Excel data table.
This is easy to do with ASAP Utilities (Excel add-in) and the Import functionality.
How to do it!
- Open up an Excel workbook (new or existing)
- Select ASAP Utilities…
- Set ASAP Utilities merge preferences
- Select files to merge and click “Open”
- Merged worksheets appear in one worksheet!
Next Steps
I now have a data set that is easy to work with.
In the next post, I will walk through adding this to an existing data set and incorporating it into a data analysis exercise.
About Don
“It’s time for different”
Don is passionate about helping professionals and organizations keep up and adapt to the changing business world that we operate in.
“What Do You Do?”
I frequently get this question. My response (it’s not what you think!)? Check it out here!
