One way to do this would be to utilize the Environment API v1. Under Topology & Smartscape you can grab a list of all available hosts in your environment and then download a json file for the given output. You can then convert that json data into a table in excel.
Here is a link that explains how to convert the json data in exel that might be useful.
Hope this helps!
To do this you'll need to go to Settings > Integration > Dynatrace API. You'll then need to generate a token with the following permission: Access problem and event feed, metrics, and topology. Then copy the generated token and use it to authorize that API by clicking the lock icon and adding the copied token into the box labeled Value. After that authorize the token and then try to execute that API again.
Hey, You will need to create an API token like this one:
You will need to copy that token code an authorize the API:
Then make sure you select Try it out!
Let me know if you get an error and we can work through it.