Create a list from an Excel file

On Wemap Pro, to be able to display content on your map, you must create and associate a list containing this information.

To do this, you can use different methods, including importing an Excel file.

The Excel file is a simple way to add content (list of points: places and/or events) in an automated manner on a map (container).

When you import an Excel file, you can then modify and/or complete your information directly on your Wemap Pro account.


📁 Prepare the import file

Before anything else, in order to perform an optimal import, make sure to properly prepare your file:

  • Data must start at the first line of the first column:
    • The first line of the file must contain the column headings
    • The second line must contain the information of your first point
  • The file must not contain any spaces at the beginning and end of cells

  • Each point that must appear in your list has several properties. Each of them must be defined clearly and independently in a column of your file: 1 property = 1 column

    Ex: one column for the point name, one column for the address...

  • 2 fields are essential for creating a point:
    • Point name
    • Address or latitude / longitude coordinates of the point
  • You can also add other properties: description, image URL...
  • If your data contains events, add 2 columns "Start date and time" and "End date and time" in ISO format (see Set up an event to display on my map: format and best practices)

👉 Here is a non-exhaustive template in Excel format, which you can import and reuse (in green the mandatory information): Download the Excel template.

It contains a "Point" tab and an "Event" tab, with related specificities.

You can add as many columns as properties associated with your point (to be associated later with Wemap Pro during the mapping phase).


📄 Create your list by importing an Excel file

  1. Click on "Create" > "List"
  2. Select "Import an xlsx file"
  3. Drop or upload your file


  1. Name your list
  2. Proceed with the mapping by associating at least the 2 mandatory fields (name, address / coordinates)

👉 The columns of your excel file, which correspond to the properties of your points, are shown here in blue. You just need to drag them into the relevant fields.

Mapping-description.gif

📌 Note:

  • The advanced fields require special formatting: favor the "Description" field for all contact information such as email, phone, website, etc...
  • The photo field expects a URL value
  • The fields "Address", "Tags" and "Description" can contain multiple values
  • The different Feed fields allow you to connect social media content (Twitter, Facebook…) to display live posts
  • In the "Category icon" field, you can associate icons with points based on a specific criterion
  • The tags allow you to highlight information and/or searches by criterion: you can use dedicated columns in your file (ex: "Tag 1", "Tag 2"...) but also information already used in the description field, for example.

  1. Stylize the information contained in the "Description" field

    You can:

    • Add a title and/or an icon
    • Add an action button
    • Change the color of the title / icons

  1. Configure the icon display

👉 To learn everything about mapping, stylizing and configuring the display of points, consult our article Customize the template of my points using mapping (edit field assignment)


  1. Click on "Import to a list"

After a few moments, a confirmation message appears in green, at the top right of your screen to confirm the import


Once completed, you can associate your list with a map.

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.