Catalog

Google Sheets

Load a purchased dataset into a spreadsheet.

How Google Sheets loads data

Google Sheets can import a CSV from your computer. The IMPORTDATA formula only works on a public URL with no login. This API needs a key, so IMPORTDATA will fail. Upload the file.

Connect

  1. Sign in with your Google account and open a Google Sheet.
  2. File → Import → Upload.
  3. If the CSV is not already in the order email, use your API key and dataset id from the catalog or confirmation email, for example B-026, to download https://data-marketplace-data.bakosbence.com/v1/data/B-026?format=csv in Excel with Authorization = Bearer mk_… and Anonymous sign-in, then save it as CSV.
  4. Pick the CSV.
  5. Import location: Replace current sheet, or Insert new sheet.
  6. Separator: Detect automatically (comma).
  7. Import data.

Google’s import help is the same dialog.

If it fails

  • IMPORTDATA shows an error — expected. Use Upload.
  • Import truncates — the file is larger than a sheet allows. Import one dataset, or split the CSV.
  • Download errors — API errors.

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