ExcelProportional symbolMidnight theme

Japanese metro areas

A dense coastal corridor rendered as proportional symbols over the Midnight theme. Widely varying symbol sizes need a dark, low-contrast basemap so the largest markers do not compete with the map underneath them.

Start an editable copy with this data and your current map styling.

Loading Excel data
Real city coordinates; metro populations are rounded estimates used for relative sizing.

What to look at

  • Midnight theme with iris-violet symbols, which is why the accent is not blue.
  • Label collision handling keeps dense coastal names from overprinting.
  • Read from an Excel sheet with a header row and a numeric column.

Source columns

These fields describe the example data. CSV and Excel use first-row headers; GIS formats store geometry and feature properties. Required geometry depends on the map type.

ColumnTypeExample
citytextOsaka
metro_millionsnumber19.2

Rebuild it with your own data

  1. 1

    Get your Excel file ready

    The example fields are city, metro_millions. For CSV or Excel, put headers in the first row. GIS files carry geometry and feature properties. Prepare any grid, catchment or route geometry before import.

  2. 2

    Drop it into the studio

    MapCrafter detects the geometry, counts the features, and shows the layers it found.

  3. 3

    Style the imported layer

    Pick which column drives colour, and which drives size or width where relevant.

  4. 4

    Pick a basemap theme

    Midnight is used here. 15 other basemaps are available, including official OpenFreeMap styles. Switch using Layers & basemap.

  5. 5

    Share or export

    Publish a link, embed the map, or export a PNG at print resolution.

Questions about this example

What file format does this proportional symbol use?
This example illustrates Excel data. The live preview uses GeoJSON geometry. MapCrafter reads Excel directly, along with Excel, CSV, KML, KMZ, GPX, GeoJSON, TopoJSON and zipped Shapefile. No conversion step and no desktop software.
What columns does the source data need?
The file used here has 2 columns: city, metro_millions. For tabular imports, supply coordinate columns, WKT or GeoJSON geometry, or address columns for an explicit geocoding step. Polygon and line files carry their geometry separately from these attributes.
Can I use my own data with this map type?
Yes. Open the studio, drop in your file, and MapCrafter detects the geometry and applies a starting style. Then style the layer and choose which property drives colour, size or width. The studio can render a point heatmap, but grids, routes and catchment polygons must be prepared before import.
Can I export or share the finished map?
Each map can be published to a short share link, embedded in another page with an iframe, or exported as a print-resolution PNG. The cleaned-up geometry can also be exported as GeoJSON. All of that is available on the free tier.
Where does the data in this example come from?
Real city coordinates; metro populations are rounded estimates used for relative sizing.

More bubble maps examples

Gallery (314)

Last updated 2026-10-22