1. Have a spreadsheet or Google Sheets ready
For your spreadsheet, there are two required columns. But you can add up to 5 custom fields. See all the fields you can import in this help article .
The two required columns are:
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. Add custom fields in your PamPam map
For every custom column in your spreadsheet, you need to add a custom field in your PamPam map. Else, there's no place to "link" the spreadsheet column too.
For example, let's say your spreadsheet has an additional column called "Hiring". You can add that fields in your PamPam map by going to "Edit fields".
Add custom fields, by clicking "Add" then going to "Edit fields" and then click "Add custom field". You can also add "Button" to add primary button that you can then link to a Website Link or something else.
3. 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.
Link 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.
Resources: