How to put character assest data from api onto excel

I need an authenticator to use the links is ESI swagger but I dont know how to get one please help

This tutorial will get you going.

https://web.archive.org/web/20190310221844/https://wiki.zansha.space/index.php/SSO_Authentication_in_Microsoft_Power_Query

you will also need, at least typeids.csv from Fuzzworks.

https://www.fuzzwork.co.uk/dump/latest/

Eve university has a description of each of SDE dumps from Fuzzworks which can be found here.

https://wiki.eveuniversity.org/Static_Data_Export

Enjoy.