How to get data from API in Excel

Written by Chernenko | Published 2021/09/28
Tech Story Tags: api | rest-api | excel | microsoft-excel | data | etl | vlookup-for-web-function | get-data-from-api-in-excel | hackernoon-es

TLDR There are multiple ways of how to get data from API to MS Excel, but we are going to focus on the simplest option (including video tutorial) for non-technical people: Using Python/R/JavaScript/PHP code and save it to an MS Excel file requires programming skills and a pre-installed Postman software. Using the VLOOKUPWEB formula doesn’t require programming skills, and the simplest possible option is the 4th most simple way explanation in this article by getting data to Excel tables from API with JSON format.via the TL;DR App

no story

Written by Chernenko | NLP Intelligent Automation enthusiast nlsql.com
Published by HackerNoon on 2021/09/28