How to export device list?

hello, I have many devices and entities in my system and I feel like I’m starting to loose control as I have many unavailable entities and I don’t even know where they came from…
Is there a tool or something that will let me export a full list of devices and entities to excel?

1 Like

You can use a template to output this info in a csv format. Then copy, paste to an editor, save then open in excel.

thank you very much!
I’m not very good with that, can you please explain how to do the template?

Paste this into the Template Editor and it will show everything known to the state machine:

{{ states | map(attribute='entity_id') | list | join(', ') }}

It won’t include Devices (they’re inaccessible to templates).

If you want a list of Devices, you could simply try to copy-paste what you see in Configuration > Devices.

11 Likes