Add your API Token to your Excel File
1. Once opened, go to the Data tab within your Excel file.
2. Click on the Queries & Connections section.
3. On the right side of your Excel document, a Queries & Connections section will open. Double left click on the Token section to open the Power Query Editor.
4. Once the Power Query Editor opens, paste your API Token into the Current Value section, then click Close & Load to finish!