Skip to main content
All CollectionsImports
How to create a map from a Spreadsheet or Google Sheets
How to create a map from a Spreadsheet or Google Sheets

Turn a Google Sheets, or a CSV file with addresses into an interactive map with multiple locations and pins.

Updated over a week ago

1. Have a spreadsheet or Google Sheets ready

For your spreadsheet, you'll have two required columns. Each column should have the first row as the name of the title.

  • Title - Each row item needs to be unique. You can't have multiple rows with the same title.

  • Address - A full complete address including city, state or country. Or you can use Coordinates.

2. Import your Google Sheets or CSV into your map

Within a PamPam map, go to the CMD+K menu, or "Add" menu, and choose your import: Import from Sheets, or CSV. Note that these are features available on our Pro plan.

Map or match the columns in your spreadsheet to the fields in your PamPam map. The titles in your spreadsheet, do not need to match the names of the fields in your PamPam map. Click "Import".

3. Update your map by importing again

If you've made changes to your spreadsheet, you can import it in your map by again by repeating step (2). If there's different information for spots you've already added, it will add that information. It will also add new information. However, it will not delete anything on your map.

Did this answer your question?