Import and Plot what3words Addresses on the Map Site using a CSV File

This guide explains how to use the Import CSV and Export CSV features on the what3words Map Site to upload, plot, and manage what3words addresses. Once plotted, these addresses can also be accessed and viewed on the what3words mobile app.

For a visual guide, you can refer to the following video:

Before importing your data, ensure your CSV file is formatted correctly with the required headers.

Required Column Headers:

• List: Organise your locations into categories (e.g., “Personal” or “Work”).
• 3 word address: Valid what3words addresses (e.g., filled.count.soap or ///filled.count.soap).
• Label: Add a descriptive name or note for each location (e.g., “Home Address”).

Example CSV Structure:

This CSV file creates three lists (Work, Personal, Other) with one labelled location each, plots them on the map, and syncs them to the mobile app.

Save your file in .csv format using a text editor or spreadsheet tool like Excel or Google Sheets.

An example of this template can also be downloaded here is
Download Template

Note: You can also get this template by visiting the mapsite and following step 2.

1. Open the what3words Map Site;
2. Log in to your what3words account. This step is essential to sync your data with the mobile app;
3. Click the Menu (three horizontal lines in the top-right corner);
4. Click “Saved Locations”;
5. Click the tree dots icon in the top-right corner of My Lists;
6. Select “Import lists from CSV”;
7. In the pop-up window:
   – Click “Upload CSV” button to upload your formatted file;
   – Or Click “Download template” to get the CSV template from the mapsite;
8. Your what3words addresses will now appear as markers on the map.

After importing your data:

1. Open the what3words mobile app on your device;
2. Log in with the same account used on the Map Site;
3. Navigate to the map view: Your imported what3words addresses will appear as synced markers;
4. Tap on a marker to view details, including the Label and List information you added.

If you’ve updated or modified your plotted data on the Map Site, you can export it for further use:

1. Go back to the Menu on the Map Site;
2. Go to Saved Locations > 3 dots icon in the top-right corner of My Lists;
3. Select “Export Lists to CSV”;
4. Download the generated CSV file containing these columns List, 3 word address and Label;
5. Save this file for sharing or future use.

Below is a table summarising the common errors users might encounter when importing a CSV file to save locations and how to address them:

Table Notes
Dynamic Data in Messages:

• ${rowNumber} is dynamically populated with the row number in the CSV file where the error occurred.
• ${w3wAddress} is dynamically populated with the specific invalid or duplicate 3-word address.

Default Errors: If the error code is not explicitly handled, it falls back to a generic message instructing the user to contact support.

How to Handle Errors During CSV Import

1. Check the Error Message
   – After attempting to import your CSV file, review the error message displayed. It will indicate the specific issue, such as a problem with a particular row or a general import limitation.
2. Understand the Error
   – Use the table above to identify the error’s meaning and how it can be resolved.
3. Correct the CSV File
   – Open your CSV file in a text editor or spreadsheet software;
   – Remove or reorganise entries to stay within account limits;
   – Navigate to the row indicated in the error message (if applicable);
   – Make the necessary changes:
   Fix invalid or duplicate 3-word addresses;
   Ensure all rows have the correct number of fields.
4. Re-upload the File
   – Save your corrected CSV file in .csv format.
   – Retry the import process.
5. Contact Support if Needed
   – If you encounter errors that persist or are unclear, contact what3words support at support@what3words.com for further assistance.