Try it
Try it with your own Google Sheet
This takes about 5 minutes. You make your own copy of a small sheet, edit it, and watch the map read from it. Nothing is uploaded to us: your browser fetches the sheet directly.
Five steps
- Download the template: template.csv (six sample rows).
- Open sheets.new (opens in a new tab) to start a blank Google Sheet. Choose File, Import, Upload and pick the template. Choose Replace current sheet.
- Edit anything: rename a place, change its hours, add a row. For a new place, right-click the spot in Google Maps and click the two numbers at the top to copy its latitude and longitude.
- Choose File, Share, Publish to web. Pick the sheet, change Web page to Comma-separated values (.csv), click Publish and copy the link.
- Paste the link below.
Your map
Until you paste a link, this shows the sample template (fictional places).
Loading the interactive map...
The columns
Row 1 of your sheet needs these headings, in lower case. Only title, lat and lng are required. Everything else is optional. Rows without a valid lat and lng are skipped, and the map tells you how many.
| Column | What to put | Example |
|---|---|---|
title | Name of the place (required) | Stone Wall Cellars |
type | A category. The filter buttons follow whatever you type here. | Winery |
status | Optional. Adds a status filter (for example Planned, Underway, Complete). | Underway |
description | One or two plain sentences | Small-batch reds made on the hillside. |
address | Shown in the popup | 88 Stone Wall Ln |
lat, lng | Map position in decimal degrees (required) | 44.005, -72.682 |
image_url | Optional link to a photo | https://…/photo.jpg |
link | Optional link to the place's own page | https://… |
hours | Optional. Days, then 24-hour times. Separate groups with a semicolon. Adds an "Open now" filter. | Wed-Sun 11:00-18:00; Fri-Sat 11:00-20:00 |
In a finished project we also set up dropdowns for the type and status columns, and fill in latitude and longitude from addresses for you. Other columns we use in specific maps: order, miles_from_previous, drive_minutes (routes), pattern, new (quilt trails), when (events).