RVTools is a Windows .NET 4.0 application that uses the VMware Infrastructure Software Development Kit (VI SDK) to display information about your virtual environments. It's a free application that can run on a server or a Windows client machine and it can read information from all versions of the VMware vSphere platform, from virtual infrastructure 3.x through vSphere 6.7 versions.

Using RVtools you can extract the different lists that contains information about your virtual infrastructure like VMs, datastores, HBAs, ESXi host, networking and much more:

The main pros of RVTools are that it is free, requires minimal installation, and supports all versions of vSphere. More importantly, it's able to export all that data in Excel or CSV formats.