Download and install the Office Tookit 4.0 MSI and the Excel Connector for Profiessional Edition (API 16.0) from https://code.google.com/archive/p/excel-connector/downloads
Additional configuration is required to get everything working properly.
The SalesForce Excel Connector will no run in Excel unless macros are enabled. Due to the security risks that macros pose, it is recommended to enable macros only when using the connector and disable them when fished.
To enable macros, launch Excel and follow these steps: