Scrape CSV web data with Excel Office Scripts
Microsoft recently announced new Get Data functionality for Excel Online. It is being rolled out this year 2022. In the meantime you can use Office Scripts to perform webscraping to obtain data from online resources like GitHub. In this video I demo Office Scripts code that uses the Fetch function to obtain a csv file without using an Interface – an artifice that structures returned data.
GitHub repo for this demo : https://github.com/MrAnalyticals/Offi...
The Office Script Example FetchingCSVv3 : https://github.com/MrAnalyticals/Offi...