The customer list you already use may help you explore a small question, such as where your active accounts are or which salesperson serves them. If this is your first map, that question gives the work a clear purpose. The list may contain several addresses for the same account, so the location you want to understand matters as much as the customer name.
Choose the customer question and fields
Give the first map a job you can describe in a sentence. You might want to see the accounts assigned to each salesperson or check where your active customers are located. Choose one of those tasks before adding more views. That keeps the source list and the map easier to check.
Start by choosing the right address. Shipping locations help you see where orders go. Service locations show where your team works. Billing addresses show where invoices go, which may be a different place. Use the one that answers your question.
Keep Customer ID, an account or display name, the chosen address fields, and one useful category. Add a source date so you know how old the list is. If customer status determines who belongs in the view, include it as a separate column. An owner field is useful when the person looking at a pin needs to know whom to contact.
Give the address fields clear headers. Keep delivery instructions and other notes outside the street-address field. Those notes may help your staff, but they shouldn't be mistaken for part of the location. Remove sensitive or unrelated columns that the first map doesn't need.
Check repeated IDs before importing. Don't remove a customer solely because its address matches another customer's address. Several accounts can share a building, and the map should retain those legitimate records. A stable ID lets you tell them apart later.
Keep a copy of the source list with its date and record count. You'll use it to confirm that the map contains the intended customers. You don't need coordinates for the address-based creation workflow.
Create the customer map
You can upload a headered customer list to Maptive and group the pins by a field such as owner or customer type without writing code.
Sign in to Maptive and choose Create New Map. Enter a name that identifies the list and its purpose. Add a short description if someone else will review it, then click Continue.
Under Your Data, use Add File or drag in an Excel, CSV, or TSV file. You can paste the table instead, including the column headers. Click Map Now after the data is loaded.
If prompted, review the column matches. Categorize Data puts address information in Section 1 and title or contact information in Section 2. Match the street, city, and other location fields to the appropriate choices, then select Done. Don't put the account name or phone number into an address slot.
Other business fields can remain unmatched. They still appear in marker pop-outs, so you can keep a customer ID or owner field without trying to categorize it as location information. Open a marker after creation and check that the account name, address, and business details belong to the same customer.
Inspect and correct the customer records
Fix data and column matching
Start with customers whose locations you know. Check their addresses and pins, then inspect any markers far from the rest of the list. A familiar location gives you a useful check on whether the columns were matched correctly. An isolated point needs a closer look before you assume it's a distant customer.
Compare the imported Data rows with your source list. Look for missing customers, repeated IDs, and addresses that need clarification. Keep unresolved records on a short correction list so they don't get forgotten once the map starts looking useful.
If an entire address column was matched incorrectly, open the Data tab and choose Categorize Data. Correct the column choices and click Done. This changes the matching across the map. Recheck several customers afterward, rather than moving each affected pin by hand.
For an individual record, open the marker, select Settings & Customization, then Edit Data. Make the change and click Map Now. You can also edit cells in the Data tab and press Enter to save. Correct the original customer list as well when the error came from that source.
A ZIP-only address doesn't give you the same detail as a complete street address. If you need to plan a visit or examine a small area, get the missing information before relying on the pin's exact position.
Move a known position when appropriate
Use a manual move when you know the correct location and the pin needs a position correction. Open the Map Settings gear, choose Map Markers/Graphics, select Move Markers, then Activate and Start. Move the marker to the known position and click Save. Reset reverses an incorrect move. Use Deactivate or the dialog's X to exit.
You can also right-click a marker and choose Move Markers. Whichever way you open the tool, base the move on a checked location. Don't move a customer to make the pattern look neater or to separate legitimate customers who share an address.
Keep a note of the correction with the source record. The next person updating the list needs to know why the location was changed and whether the address itself also needs repair.
Add one useful category view
Open Map Tools and select Grouping Tool / Colored Pins Tool. Choose your owner, status, or customer-type column as Primary Group. Maptive gives each group a different marker color. Check that the category names are recognizable and that each customer has the intended value.
Use the small white icon beside a group if you need to change its marker appearance. Keep the first view easy to read. A simple distinction between customer types or account owners usually needs less explanation than several visual rules at once.
You can select and deselect groups to inspect them separately. Open a few markers from each group and compare the displayed category with the source. If two group names mean the same thing because someone used different spelling or spacing, correct the source values before treating them as separate customer segments.
For an active-customer view, open the Filter Tool. Select Create Filters on first use, or use the gear if filters already exist. Choose Group for the supplied status field and select the values you need. A Date filter works when the question concerns a defined period and you have an appropriate date column.
Check which rows the filter retains. An empty or outdated status field can remove a customer you intended to include. Uncheck the filter's checkbox when you want to disable it and inspect the broader list again.
Once this view answers your first question, you have a useful map to hand off. Keep any more detailed analysis for a separate task with its own data requirements.
Hand off the map and assign updates
Download a checked file through Export Data on the map's right. Choose Export Entire Dataset for the full customer list or Export Filtered Data for the current grouping, filter, and search restrictions. Select the format and click Export Now. Export Data Visible on Map follows the viewport, so choose it only when the screen area is the intended scope.
For a person who needs to view the map without a license, open Share and Share Externally. Choose Password Protected or Public deliberately. A public map can be viewed by anyone with its link. Review the customer fields and viewer settings before sending access, then test what the recipient can see.
For licensed colleagues who need to work on the same map, Team Map Share is available from the map's three-dot menu on the home screen. It requires multiple licenses purchased together. Choose team members and grant editing or view-only permission. Only one person can edit the map at a time, so name the person responsible for the next update.
An ordinary file upload is a snapshot. Editing the original workbook doesn't automatically update that imported map. Identify which spreadsheet or customer system is the source, who corrects it, and who brings changes into the map. A Google Sheets connection is a separate setup when that workflow suits your team.
To add an individual customer, open the Data tab, choose Add New Row, fill in the record, and select Map Now. Before handing over the finished view, have its update owner open one checked customer record and confirm the ID, address, and category. They can then keep later changes tied to the same source.
