An Excel address list gives you the locations you want to see together on a map. You may be reviewing customer spread, branch locations, or the addresses your team needs to visit. On the map, you need to be able to inspect each record's location and confirm that it points to the place you mean. A billing office and a delivery address can belong to the same customer while pointing to different locations.
Prepare the Excel address list
Keep the location fields clear
Give each column a header that says what it contains. Address, City, State, ZIP Code, and Country are useful names when those fields are separate. If your list already has latitude and longitude, keep those in clearly named columns too. Maptive accepts addresses and coordinates, so you don't need to find coordinates just to map a street address.
Choose the address that fits the question. A customer's billing address may be different from the location where your team delivers or provides service. If the map is for delivery planning, use the delivery location. Preserve the other address in your source if you need it, but don't leave two vaguely labeled address columns for the import to interpret.
Keep a customer ID or location ID beside the address. Names can change, and 2 customers can share a building. An ID lets you check the same record before and after mapping without guessing from the pin's position. Useful fields such as customer status or assigned rep can stay in the workbook as well.
Decide what one row means. It might be one customer, one branch, or one delivery location. Those are different counts. A customer with 3 service locations may need 3 rows for a service map, while a customer-count map may need one. Write down the number of rows you intend to import, excluding the header.
Review repeated records before uploading. Two rows with the same customer ID and the same address may be an accidental duplicate. Two different customer IDs at that address may both belong in the map. Don't delete records solely because the addresses match.
Preserve ZIP codes as text
ZIP codes are identifiers, so store them as text in Excel. A leading zero belongs to the code. If Excel turns a code into a number, it can drop that zero and leave you with a different value.
Check the underlying cell value as well as what the cell displays. A number format can make a numeric value appear to have 5 digits, but that display doesn't turn the stored value into text. If zeros have already been lost, confirm the full code from a reliable source before repairing it. Adding zeros to every short value can conceal a different error.
Use the same care with international postal codes. Keep letters and spaces that are part of the code, and retain the country so a location name has enough context. A city name on its own can be ambiguous across states or countries.
Look through the location columns for blanks. Resolve missing street details where you can. If a row only has a city or postal code, keep that limitation clear in the data rather than treating it as a full address. You can still map the broader location, but later distance checks will have less precise input.
Upload the workbook in Maptive
Once the list is ready, sign in to Maptive and create the map in this order.
- Click Create New Map.
- Give the map a name and add a description if you want one.
- Click Continue.
- Select your Excel file or drag it into the import area.
- Click Map Now.
You can also paste your data instead of uploading a file. Include the header row when you paste so the column names travel with the records. Maptive also accepts CSV files, but you can use the Excel workbook directly for this task.
Choose a name that helps you recognize this particular list later. Include the business purpose and source period if both matter. A description can explain which address you used and what one row represents. That gives someone opening the map a way to understand the records without reopening your preparation notes.
As the locations appear, compare the overall spread with the area you expected. A faraway pin deserves a closer look, especially when the rest of your list is in one market. It may be a genuine customer, an incomplete address, or a column match that needs changing. The pin alone won't tell you which.
An uploaded workbook is a file import. Don't assume that changing the Excel file later changes this map. Treat the imported data as the version you supplied, and keep track of any corrections you make afterward.
Match and repair the location columns
Confirm Categorize Data matches
Maptive may show Categorize Data during map creation to confirm how your columns match its fields. Review the location matches rather than accepting them on sight. The street field should use your street-address column, and the postal field should use the column containing postal codes.
If a field is matched incorrectly, use its dropdown to select the correct column. Click Done after making the changes. This fixes how Maptive reads the list, which is different from rewriting an address in an individual row.
You can reach the same matching controls after creation. Click a marker, click the gears, and select Categorize Data. This is useful when a pattern of errors points to a shared column problem. For instance, if the wrong address type has been used throughout the map, review the match before correcting records one by one.
Once the matches are right, check some familiar locations. Include records with a complete street address and records with less detail. Confirm that each uses the intended fields, and inspect the location it produced.
Correct individual address records
A correctly matched column can still contain a wrong address. To edit an individual value, open the Data tab, change the cell, and press Enter to save it. Use this path when you have found the problem in a specific source record.
You can also begin from the pin. Click the marker, open Settings & Customization, and choose Edit Data. Make the changes, then click Map Now. Keep that save action separate from the Data tab's Enter action so you complete the path you started.
Work from the actual address evidence. Check the street number, city, state, postal code, and country against your customer or location record. A point near the place you expected is worth inspecting too. It could identify the right town while still using the wrong street detail.
After a correction, return to that record and inspect its location again. Update the source workbook as needed so the next import doesn't bring the old error back. These are manual checks you make on the data and pins; plotting a point doesn't certify that an address is complete or current.
Reconcile the map with your source rows
Use the IDs you retained to compare the imported data with the intended source list. Check that expected records are present, that repeated IDs have an explanation, and that corrected rows contain the right values. Review the data records as well as the map, because several records may occupy the same location.
A count of visible pins is a poor substitute for this comparison. Pins for customers sharing an office or apartment building can overlap. Conversely, repeated rows can make a customer appear more than once in the data. Your counting rule starts with what the rows represent.
Keep unresolved location detail in view. A record mapped from a ZIP code remains an area-level location even if its pin looks precise. If you later measure a radius or plan a route, check whether you need the street address before including that row.
Keep a useful customer map
Leave the fields that help you recognize and use each record, such as the customer ID, name, status, and relevant address. If a category view will help your next task, keep the category column ready for marker grouping. Before using the map, revisit a few corrected records and compare their IDs and address values with the workbook you intend to keep as the source.
