Upload Your Own Data
How to upload a CSV file, configure columns, and turn your own location data into a map layer.
You can bring your own location data into any Mapbook by uploading a CSV file. The platform geocodes addresses automatically, maps your data to H3 cells, and makes it available as a series.
Upload your existing store network or lead list to visualize white spots on the map: areas with demand but no coverage.
Prepare your CSV file
Your file needs at least one column that identifies the location of each row. Supported geolocation methods:
| Method | Required columns | Notes |
|---|---|---|
| Coordinates | lat / latitude and lon / lng / longitude | Fastest; no geocoding needed |
| H3 index | Any column named h3, h3_index, or similar | Direct cell mapping |
| Full address | address, full_address, or location | Geocoded via OpenCage |
| Address parts | Any combination of street, city, postal code, country | Geocoded via OpenCage |
The platform auto-detects column names matching these patterns, so you usually don't need to rename anything.
Row limits:
- Up to 100,000 rows when coordinates or H3 index are provided
- Up to 10,000 rows when geocoding from addresses
File size limit: 15 MB per file.
How to upload
- 1Open a Mapbook and click + Add column.
- 2Go to the Load tab in the action catalog.
- 3Click Upload CSV.
- 4Drag and drop your file, or click to browse.
- 5The platform detects the delimiter (comma, semicolon, tab, or pipe) automatically.
- 6Review the data preview showing the first 5 rows.
- 7Confirm or adjust column types (integer, float, date, text).
- 8Mark geographic columns: the platform pre-selects likely geo columns.
- 9Name your dataset and choose visibility (Private or Shared with your organization).
- 10Click Upload. Processing runs synchronously. You'll see a confirmation when it's ready.
Column types
The platform infers column types from your data:
| Type | Examples |
|---|---|
| Integer | 42, -100, 1234567 |
| Float | 3.14, 1,234.56 (European notation supported) |
| Date | 2025-01-24, 24.01.2025, Jan 24, 2025 |
| Text | Everything else |
You can override any auto-detected type by clicking the column header in the preview.
Adding a series from your dataset
After uploading, your dataset appears in the action catalog under My Datasets. Datasets shared with your organization appear under Organisation's Catalog.
When you add a series from your dataset, you configure:
- Which column to visualize
- Aggregation: how values combine per H3 cell (Sum, Average, Min, Max, Count, or Unique Count)
You can add multiple series from the same dataset with different aggregations or filters.
Uploaded datasets are reusable across Mapbooks. Upload once, add to any Mapbook.
Point layer
In addition to the H3 hex visualization, your uploaded data can be shown as individual points on the map. Toggle the Show points option in the layer settings to display the raw locations alongside the aggregated hex grid.
You can style the points by shape (circle, square, diamond, triangle, pin, or star), fill color, border color, size, and opacity.