Skip to main content
All CollectionsImports
How to set up your spreadsheet to import to your map
How to set up your spreadsheet to import to your map

All the fields you can customize when importing a spreadsheet to create a PamPam map.

Updated yesterday

You can import a spreadsheet, Airtable or Google Sheet into PamPam. Below are the fields that you can import. Only Title, and Address or Coordinates are required for an import.

Column

Description

Example

Title*

The name of your spot. Each spot needs to have a unique name when importing from a CSV, Spreadsheet or Airtable.

Cafe Clock

Address*

Full address of your spot, including city, state and possibly country. You can use an Address or Coordinates.

123 Main Street, Philadelphia, PA, USA

Description

A description for your spot that will appear in the card in the panel and in the main panel.

An awesome cafe with a weird clock collection

Display

How you want your spot to appear on your map. The choices are:

  • photo

  • profile

  • sticker

  • link

  • event

Make sure you're not using capitals.

profile

Link(s)

Links that you want to appear in the "Links" area in the panel. You can add multiple links by comma separating them.

The first link will be used for the "Link" display.

Images from these links will appear in the image carousel automatically.

Section

The section you want your spot in.

Cafes

Date

The date you want for your spot. If you want it to appear as an "event" display type, then you also need to add the display column as display.


It should be in ISO format:

2024-06-13T20:00

or

2024-06-13T20:00 - 2024-06-13T21:00

2024-06-13T20:00

Image

Images you want to use in the image carousel. You can use image URLs that are externally hosted. For example hosted on Dropbox. To add multiple photos, separate them with commas.

Images should be less than 1024px width and height.

Coordinates

If you don't want to use the Address field, and prefer to use coordinates, you can use that.

48.8584, 2.2945

Button

If you've added a primary or secondary button, you can import that link too.

An example of what the spreadsheet should look like, or see a Google Sheet example here.

Did this answer your question?