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. Open the import menu
Open your PamPam map and choose one of these options:
Type CMD+K and select "Import from Sheets" or "Import CSV"
Click the "Add" menu and choose your import option
Click the Cloud icon in the toolbar and select your import type
3. Connect your Data
For Google Sheets: Paste your sheet URL
For CSV: Upload your file
Click "Next"
4. Map your fields
PamPam automatically:
Matches your spreadsheet columns to PamPam custom fields
Creates any new custom fields your data needs
Need more control? Click "Advanced" to:
Fine-tune field mapping
Add custom Buttons (these require manual mapping)
When everything looks right, click "Save Settings" to complete your import.
5. (Optional) Add custom fields in your PamPam map
Add more custom fields to your map by clicking on the "Add" button. You can also add large Buttons to your panels here.
6. Updating Your Map
Need to refresh your map with changes from your spreadsheet? No problem! You can easily reimport your data in two ways:
Click the Cloud icon in the toolbar
Use the CMD+K menu and select "Import"
When updating, you'll have two import options:
a. Match Mode (Default)
This keeps your map and data source perfectly in sync:
New rows in your spreadsheet = New spots on your map
Deleted rows in your spreadsheet = Removed spots on your map
Any spot you manually deleted that still exists in your spreadsheet will reappear
Best for: Keeping your map as an exact reflection of your spreadsheet data
b. Only Add Mode
This gently adds new data without disturbing what's already there:
New rows in your spreadsheet = New spots on your map
Existing map spots stay untouched, even if removed from your spreadsheet
Manual changes you've made directly in PamPam are preserved
Best for: When you've customized your map in PamPam and only want to add new locations without affecting your existing work
7. Choose how you want your spots displayed
Go to the toolbar and click on the wallet to change the spots in your profile to look like circles (profile), events, photos and more.
Resources: