← ddigger

City populations from Excel

Upload a single-sheet workbook. ddigger publishes instructions, schema, and a filterable /data API for AI agents. The example below filters city rows by country.

Preview city example

Separate live source: World Bank countries

From worksheet to matching cities

The Central European city populations example has three rows. Imagine them in a single-sheet XLSX workbook with field names in the first row.

Worksheet rows

Illustrative single-sheet workbook
citycountrypopulation
PragueCZ1300000
BrnoCZ380000
ViennaAT1900000

Focused request

GET /data?fields=city,population&where=country:eq:CZ&limit=10

Matching rows

Selected city and population fields
citypopulation
Prague1300000
Brno380000

Prague and Brno match the CZ filter; Vienna does not.

The preloaded example uses the same rows. Upload your own workbook to test XLSX import.

Use your own workbook

Upload a single-sheet XLSX file with field names in the first row. Multi-sheet workbooks are not supported. Review inferred fields and the generated human view before publishing. Preview does not require sign-in; publishing requires an account.

Upload updated rows and republish to move the latest URL to a new version. The API is read-only and does not synchronize with the local workbook.

Published source

Your publication serves /llms.txt instructions, an /openapi.json schema, focused /data queries, and a generated human page. A pinned /v/{version} URL retains an exact version. For live endpoint responses, inspect this separate country source: instructions, schema, and data.