Data

Import from CSV & Excel

Upload CSV or Excel files to populate your map with data.

Import from CSV & Excel

Mapsemble lets you upload spreadsheet files to quickly populate your map with data. This is the fastest way to get started if you already have your data in a spreadsheet.

Supported formats

  • CSV (.csv) — Comma-separated values, the most universal spreadsheet format.
  • Excel (.xlsx) — Microsoft Excel workbooks.

How to import

  1. Open your map and go to Data Source settings.
  2. Click Upload.
  3. Select your CSV or Excel file from your computer.
  4. Map your spreadsheet columns to map fields (see below).
  5. Confirm and import.

Field mapping

After uploading your file, you'll be asked to map each spreadsheet column to a Mapsemble field. Each column can be mapped to a field type:

  • Text — Short single-line text.
  • Number — Numeric values.
  • Date — Date values.
  • Image — URLs pointing to images.
  • Single select — One value from a predefined list.
  • Multi select — Multiple values (tags).

Columns that don't match any field can be skipped during mapping.

Location data

Your data must include location information so Mapsemble knows where to place each marker. You can provide location in three ways:

  • Separate latitude and longitude columns — Two columns, one for latitude and one for longitude.
  • A single address column — Mapsemble will geocode the addresses into coordinates automatically.
  • GeoJSON geometry — A column containing GeoJSON geometry objects.

Skip first row

If your file has a header row (column names), enable the Skip first row option so it isn't imported as data.

Import limits

Plan File uploads
Free 3 file uploads max
Pro Unlimited
Enterprise Unlimited

Re-importing

Uploading a new file to the same data source replaces all existing data from that source. This makes it easy to update your map — just upload the corrected file.

Tips for a smooth import

  • Clean your data before import. Remove empty rows and ensure consistent formatting across columns.
  • Select field values must match exactly. Values are case-sensitive — "Restaurant" and "restaurant" are treated as different options.
  • Image fields should contain valid URLs. Each cell should be a full URL pointing to an image (e.g., https://example.com/photo.jpg).
  • Use dots for decimals, not commas. Numbers should be formatted as 1234.56, not 1234,56.