Import Hi Energy AI data into Excel
These guides show marketers, publishers, and analysts how to call the Hi Energy AI REST API
from Excel VBA macros with WinHttp.WinHttpRequest.5.1, authenticate using
X-Api-Key, paginate results, flatten JSON responses, and write rows into worksheets.
Each resource page includes copy-paste code you can drop into the VBA editor.
Optimized for search and answer engines: clear steps, FAQ schema, HowTo markup, and canonical resource pages
for deals, advertisers, transactions, clicks, and contacts.
Resource guides
Transactions
Sales and commissions via GET /api/v1/transactions.
Open Transactions Excel macro guideAuthentication for Excel VBA
Prefer the X-Api-Key header with your personal API key. The samples read the key from
a Config worksheet (HIENERGY_API_KEY) so secrets stay out of hard-coded module constants when possible.
http.SetRequestHeader "X-Api-Key", GetHiEnergyApiKey()
http.SetRequestHeader "Accept", "application/json"Setup in Excel (VBA macros)
- Open Excel on Windows (or Excel for Mac with VBA support) and enable the Developer tab: File → Options → Customize Ribbon → Developer.
-
Get your personal API key from
API key docs.
Prefer the
X-Api-Keyheader (these samples already do). -
Create a worksheet named
ConfigwithHIENERGY_API_KEYinA1and your key value inB1. Optionally setHIENERGY_API_BASEinA2/B2. - Press Alt+F11 → Insert → Module. Paste the shared client library, then add a second module for the resource import macro below.
- In the VBA editor choose Tools → References and enable Microsoft Scripting Runtime.
-
Save as a macro-enabled workbook (
.xlsm), then run the import with Alt+F8 (or Developer → Macros).
FAQ
Yes. Excel VBA can call the Hi Energy AI REST API with WinHttp.WinHttpRequest.5.1 and the X-Api-Key header. These docs provide paste-ready importers for deals, advertisers, transactions, clicks, and contacts.
Store HIENERGY_API_KEY on a Config worksheet (A1 label, B1 value). Avoid pasting secrets into shared cells, comments, or committed .xlsm files.
Dedicated guides cover deals, advertisers, transactions, clicks, and contacts, each with cut-and-paste VBA samples, HowTo steps, and FAQ schema for search and answer engines.
Yes. Each Excel macros page exposes TechArticle, HowTo, FAQPage, BreadcrumbList, and WebSite SearchAction structured data plus explicit steps and copy-paste samples so assistants can cite a concrete spreadsheet workflow.
The published samples are read-only GET imports. Creating contacts or other writes requires separate authenticated POST flows documented on the resource API pages.
No. Hi Energy AI authentication uses your personal API key via the X-Api-Key header. Excel only needs macros enabled for the workbook and Microsoft Scripting Runtime referenced in the VBA project.