Home › Guides › Import SEC earnings data into Excel (Power Query)

Import SEC earnings data into Excel (Power Query)

Use Excel's Power Query to pull earnings data directly from the Aegwah REST API — no coding required.

Steps

1. Excel → Data → Get Data → From Other Sources → From Web.
2. Choose Advanced and enter the URL https://api.aegwah.com/v1/actuals/AAPL.
3. Add an HTTP request header: Authorization = Bearer your-api-key.
4. In the Power Query editor, convert the returned list To Table, then expand the record columns.
5. Close & Load to drop the table into your sheet. Refresh any time to pull the latest.

Prefer a one-off? Download the ZIP and open the CSV files directly in Excel.