How to turn a business list into a map you can share
Upload your rows, let addresses become positions, colour the points by category and share one link that updates itself. How to turn a business list into a map.
Part of the guide Location intelligence automation
To turn a business list into a map, give every row a position (latitude and longitude, or an address that can be turned into one), load the rows into a mapping tool, colour the points by a column such as category or account owner, and share the map by a link rather than a screenshot. In xMap Flows that is three blocks: My data reads your file and places rows that only have an address, Show on a map draws them, and the map's public link lets anyone open it without an account.
People do this with customer files, store networks, prospect lists, supplier directories, event venues, donor addresses grouped by area, or a sheet a colleague built by hand. A map shows what rows hide: clusters, gaps, duplicates stacked on one spot and rows that landed in the wrong country. This article covers getting the file ready, what happens to rows without coordinates, choosing colours, sharing, and keeping the map current.
Get the file ready
A clean file saves most of the work. Keep one business per row and one header row. Useful columns:
- name: shown in each point's pop-up.
- category or any column you want colours for: type of business, owner, status, region.
- latitude and longitude, if you have them. Common column names such as lat, lng, latitude and longitude are recognised, with a dot or a comma as the decimal mark.
- address and city, if you do not. Rows without coordinates get a position from these columns.
- rating or a score, if you want them in the pop-up.
My data accepts a CSV upload or a Google Sheets link right in the block's settings, up to 5,000 rows and 40 columns.
Rows that only have an address
Turning an address into a position is called geocoding. It is reliable for full street addresses and weak for vague ones. A row with only a city lands on the city's centre; a row with a misspelt street can land on the wrong street of the same name. After the first run, look at the map for two warning signs: many points piled on one spot (usually a city centre) and points far from where your business operates. Fix those rows in the file, ideally by adding coordinates, and run again.
Choosing how points are coloured
Show on a map colours points by category, by fit score, or all in one colour. By category gives each value its own colour, and clicking an entry in the legend hides or shows it, so a viewer can switch off everything except, say, distributors. By fit score shows green for 80 and over, amber for 65 to 79 and red below, which suits a scored prospect list. On the Maps page a viewer can switch to clusters for a busy city or to a heat map to see where points concentrate.
A worked example
This example is made up. A wholesaler in Casablanca keeps its 1,100 retail customers in a sheet with the shop name, city district, type and the salesperson responsible. Only some rows have coordinates.
- The sheet's link goes into My data. Rows with a full address are placed; 90 rows with only a district name land on district centres.
- Show on a map draws the 1,100 points, coloured by the salesperson column renamed to category.
- The sales manager sees at once that two reps' territories overlap in one district and that a third district has almost no customers.
- The 90 rough rows are fixed by asking the reps for shop addresses; on the next run they move to the right streets.
- The manager shares the map's public link in the team chat and on a screen in the office.
The empty district becomes the subject of the next prospecting push, with a Nearby places search in that district for the same shop types.
Sharing the map
A map on the Maps page can be shared by a public link that opens without signing in, or placed on a web page with an embed snippet. Public links show business fields such as name, category, city, address, rating, phone and website, and never your notes. A link stops working when you stop sharing it. If the map shows customers, think about who should see their addresses before you post the link widely.
Mistakes to avoid
- City-only addresses. They stack on the centre and give a false cluster.
- Mixed columns. Coordinates written as one text field in some rows and two columns in others confuse any reader.
- Too many colours. More than about eight categories is hard to read; group the small ones.
- Screenshots in slides. They are out of date the next week. Share the link instead.
- Forgetting privacy. A public map of customer addresses is still a list of customers.
Keep the map current with an AI employee
If the list changes, let a flow redraw it. With Each run set to Updates the same map, the link stays the same and always shows the latest rows. The workflow automation guide explains schedules and triggers.
- New rows, to run when rows are added to the sheet, or Schedule for a weekly redraw.
- My data with your table.
- Optionally Nearby places set to Each incoming place, with counts, to add how many competitors sit around each customer.
- Show on a map, Updates the same map, coloured by category.
- Email with a note when the map changes, if the team wants one.
The shared link then never goes stale. Templates that end in a map of your own rows include Where our registered players live, Our public impact map, updated weekly and Where customers can drop off returns.
Questions
Do I need latitude and longitude in my file?
No. Rows without them are placed from their address or city columns. Coordinates give the most exact points, so add them where you have them.
How many rows can I map?
My data reads up to 5,000 rows and 40 columns from one table, which covers most customer and store lists.
Can people without an account see the map?
Yes, through a public link or an embed on your own web page. You can stop sharing at any time, and the link then stops working.
Can I download the map's points?
Yes. From the map's page you can download the points as GeoJSON for mapping tools or as a CSV.
Why are many of my points on the same spot?
Those rows probably had only a city or district, so they landed on its centre. Add a street address or coordinates to those rows and run again.
Templates that do this
Read next
More on business and places data · Every article · Templates