Great to hear you got it working 😃

1. I finally figured out how to make this API work in excel.
2. All you have to do is add ?rapid-apikey=secret_api_key to the end of the URL.
3. Example = https://pokemon-go1.p.rapidapi.com/alolan_pokemon.json?rapidapi-key=secret_api_key
   
4. “Anonymous” authentication will then work properly in Excel.

1. I’m trying to test any of the JSON files, using the “Import from Web” option in Excel.
2. But I keep getting snagged with the authentication process (need more detailed instructions on how to get the authentication process to work properly in Excel).
3. Thanks.

What type of data do you want to use with excel?