MrKowz
Well-known Member
- Joined
- Jun 30, 2008
- Messages
- 6,653
- Office Version
- 365
- 2016
- Platform
- Windows
Can Excel be used to query a website's API and pull back results in a spreadsheet? I've been searching around, and am trying to come up with a way to have Excel query SEMRush's API.
For example purposes, we'll say that the API URL would be:
http://us.api.semrush.com/?action=report&type=phrase_related&key=XXXXXXXX&export=api&export_columns=Ph&phrase=search+engine+optimization
Obviously, I can't give out my API key, but was hoping someone could give me some skeleton code to work from.
Thanks!
For example purposes, we'll say that the API URL would be:
http://us.api.semrush.com/?action=report&type=phrase_related&key=XXXXXXXX&export=api&export_columns=Ph&phrase=search+engine+optimization
Obviously, I can't give out my API key, but was hoping someone could give me some skeleton code to work from.
Thanks!
Last edited: