Catalog

Excel

Load a purchased dataset into a workbook.

How Excel loads data

Excel on Windows uses Power Query (Get Data) the same way Power BI does. The CSV becomes a table in the sheet. Data → Refresh All runs the same request again.

Excel for Mac has a thinner Get Data menu. If you do not see From Web → Advanced, download the CSV (see API) and use Data → From Text/CSV on the file.

Connect

  1. On Excel for Windows, open a blank workbook. Keep your API key from the order confirmation (mk_…) and your dataset id ready, for example B-026.
  2. Data → Get Data → From Other Sources → From Web. (Some builds: Data → From Web.)
  3. Advanced.
  4. URL: paste the CSV URL, for example https://data-marketplace-data.bakosbence.com/v1/data/B-026?format=csv.
  5. HTTP request header parameters: Authorization / Bearer mk_…. There is a space after Bearer.
  6. OK.
  7. Sign in as Anonymous, then Connect.
  8. CSV preview → Load.

Same Web connector as in the Power Query Web docs.

If it fails

  • 401 — key or Anonymous step.
  • 403 / 404 / 429 — see the error list.
  • No Advanced box — import a downloaded CSV instead.

Support

Any questions?

Email info@bakosbence.com.

Please write from a company-specific email address, or include an order identifier you received in your order confirmation email. Include the endpoint or the dataset you have a problem with.

Catalog