Plot multiple locations on a map
A pin map answers "where are they all?" at a glance: every store, customer, job site, venue or stop on a trip, on one map. Paste a list and press Plot pins. Lines can mix addresses, place names and coordinates, and anything after a " | " becomes the pin's label, so "Rijksmuseum, Amsterdam | Day 2" plots the museum and labels it Day 2.
For a map from a spreadsheet, copy the cells straight from Excel or Google Sheets (with the header row) and paste them, or upload a CSV. The tool finds latitude and longitude columns by their usual names, including combined "coordinates" columns and European files with semicolons and decimal commas. If there are no coordinates, it builds an address from the address, city, state, zip and country columns and looks each one up on OpenStreetMap, about one per second. Rows it can't read or find are listed with their line number and the reason, so you can fix just those.
Style the pins as classic map pins or small dots in one of six colors (or keep the colors from your file), turn labels on or off, and choose a dark, light or Voyager basemap. Click any row to fly to it, then download the map as a high-resolution PNG. To present the places as a video, Animate this map sends the first 50 pins to Mapimator Studio as a ready-made fly-in on a 3D globe.
Frequently asked questions
How do I put multiple pins on one map?
Paste your places into the box, one per line, and press Plot pins. Each line can be an address or place name ("Eiffel Tower, Paris"), a latitude and longitude ("48.8584, 2.2945"), or either one followed by " | " and a label. Every place gets a pin, and the map zooms to fit them all.
Can I make a map from an Excel or Google Sheets spreadsheet?
Yes. Copy the cells including the header row and paste them in, or save the sheet as CSV and upload it. Columns named lat/latitude and lng/lon/longitude are used as coordinates; without them, address, city, state, zip and country columns are combined and looked up. A name or title column becomes the pin label, and a color column sets each pin's color.
How many locations can I plot?
Up to 5,000 rows with coordinates at once. Addresses have to be looked up one by one on OpenStreetMap's free geocoder, which allows about one request per second, so the tool looks up 100 new addresses per run; press Plot pins again to continue with the next 100. Addresses already found are remembered for the session.
Which coordinate formats are supported?
Decimal degrees with a dot or comma decimal (48.8584, 2.2945 or 48,8584; 2,2945), degrees-minutes-seconds with N/S/E/W (48°51'30"N 2°17'40"E), Google Maps and OpenStreetMap links, and GeoJSON points. Numbers are read as latitude, longitude unless the data only makes sense the other way, and you can force the order.
What happens to addresses that can't be found?
They stay in the list marked "Address not found" with their line number, and the rest of the map is plotted. Adding a city and country to the line usually fixes it, or you can paste the exact coordinates instead.
Is the pin map maker free?
Yes, with no account required. Download the map as a PNG with your pins and labels. To turn it into an animated video, send the pins to Mapimator Studio with Animate this map.