How to audit entities

I’ve been using HA for a while now and my system has grown and grown. I can see I’ve been quite inefficient with naming and sometimes duplicating entities so I’d like to do a big tidy up & re-organisation. As I see it the first step is to get a full list of all the entities I’ve created and then to check where they are used (in other entities, dashboards, automations etc). Is there a way of doing this? My approach so far is to get lists of entities by going though each integration, eg:
{{ integration_entities('statistics') }}
Then I copy this into Excel, together with the texts of each YAML file (configuration.yaml etc) and use lookups to see whether & where each is used. This is so clunky I’m embarrassed to admit it. All I really want is a full list of all my entities saying if they are unused or where they are used. Has anyone done this? How else do folk keep their HA instances under control? Maybe you are all neat & logical people and I’m the only messy one…

While not exactly what you’re after, Watchman does a good job of finding orphaned entities/services within your system. Ie. What’s being referenced in automations, scripts, lovelace, etc., but doesn’t exist.

I use the ‘Find in Project’ feature within the Atom Editor to help me find all references of an entity / service / etc. in HA as well when trying to find items. The ‘Project’ points to me /config folder where I have HA installed using the Samba Share Add-On to access.

Will be following this thread as well, curious to see how / what others use.

I like the idea of cute little orphans, but I worry I’m suffering from zombies, some hideously malformed…