Excel Requests: HTTP for Humans¶
Excel Requests is the only HTTP Addin for Excel, safe for human consumption.
Excel Requests is heavily inspired by Kenneth Reitz’ popular Python Requests.
Source¶
The Excel Requests source code is hosted at https://github.com/Pathio/excel-requests
Installation¶
The easiest way to install excel-requests is via the installation script:
- Download
install.ps1 - Open a File Explorer and go to the downloaded file’s folder
- Right click install.ps1
- Click Run with PowerShell
- Confirm everything works with the Example workbook
Examples.xlsb
License & Authors¶
- This project is maintained by Bjoern Stiel at Pathio.com
- Drop me an email bjoern.stiel@pathio.com. or tweet me @bjoernstiel
- This project is licensed under the terms of the BSD license
Installation¶
The recommended and easiest way to install excel-requests is via the installation script:
- Download
install.ps1 - Open a File Explorer and go to the downloaded file’s folder
- Right click install.ps1
- Click Run with PowerShell
Manual Installation¶
- Determine whether your Excel is 32bit or 64bit (open Excel, click File, click Account, click About Excel, this opens a window that tells you version number and bitness in the first row)
- Go to https://github.com/Pathio/excel-requests/releases/latest
- If your Excel is 64bit, download “Requests64.xll” otherwise “Requests.xll”
- Though you can save the “Requests64.xll” or “Requests.xll” anywhere on your computer, it is recommended that you move it to this folder: %APPDATA%MicrosoftAddIns
- Open Excel, click File, click Options, click Add-ins, at the bottom, click (Manage Excel Add-ins) Go..., click Browse and navigate to the location of the downloaded Addin
Get the Source Code¶
Excel Requests is actively developed on GitHub, where the code is always available
Quickstart¶
Download the Example workbook Examples.xlsb
Retrieve Json from an HTTP API straight into Excel, authenticate via basic authentication:
>>> =REQUESTS.GET("https://api.github.com/user",,, "<username>:<token>")
https://api.github.com/user
>>> =REQUESTS.DICT.KEYS("https://api.github.com/user#Json")
{"login";"id";"avatar_url";"gravatar_id";"url";"html_url"; ...}
>>> =REQUESTS.DICT.GET("https://api.github.com/user", "Json/url")
https://api.github.com/users/Pathio
>>> =REQUESTS.FLUSH()
Flushed 1 key(s)