TutorialJSON to Excel: Import and Export with VBA (2026)Convert JSON to Excel with VBA-JSON: copy-paste macros to import a JSON API or file into a sheet, and export Excel rows back to JSON.Sep 11, 2022 · 7 min read
TutorialHTTP Requests in Excel VBA: GET and POST Examples (2026)Make HTTP GET and POST requests in Excel VBA with XMLHttpRequest or WinHTTP: copy-paste macros with JSON headers, error handling and basic auth.Sep 11, 2022 · 5 min read
TutorialParse HTML in Excel VBA: Scrape a Web Page Step by StepParse HTML in Excel VBA with HTMLDocument: fetch a page, find elements with getElementsByTagName and getElementsByClassName, and write results to cells.Sep 11, 2022 · 5 min read
TutorialHow to Send SMS from API or Backend 📲Sending SMS is one of the essential features for any app's backend. I've recently started working on an app and I needed an SMS service to send…Dec 19, 2018 · 7 min read
TutorialConvert Json to csv and csv to Json in Excel VBAA step by step tutorial explaining how to read a file, write a file, convert JSON to CSV and CSV to JSON programmatically using Excel VBA.Oct 25, 2017 · 7 min read
TutorialHow to build a simple weather app in Excel VBAOne of our readers posted a question on the forum asking how to get weather data using VBA. So I created a very simple weather app in Excel VBA.Jul 12, 2017 · 3 min read
TutorialWeb Scraping with VBA: Selenium Example (2026)Web scraping with VBA in Excel: scrape a website with Selenium, see when XMLHttpRequest or a JSON API is faster, with copy-paste macros.May 9, 2016 · 8 min read
TutorialBrowser automation in Excel VBA using SeleniumA simple tutorial on how to automate browser based tasks in VBA using selenium VBA which is a .NET wrapper for selenium framework.Mar 3, 2016 · 6 min read