How to Map Addresses in Tableau

Visualizing customer addresses on a map brings your data to life, transforming a flat spreadsheet of street names and postal codes into an interactive business intelligence tool. This unlocks new ways to spot regional trends, plan logistics, or analyze sales territories. This guide will walk you through exactly how to prepare your data and create rich, insightful maps using Tableau.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Start with Clean, Structured Address Data

Tableau is incredibly powerful, but it's not a mind reader. Before you can create a map, you need to format your address data in a way Tableau understands. The single most important step is breaking your addresses down into separate, distinct columns.

Instead of having one column with a full address like "123 Main St, Anytown, CA, 90210", you need to split it apart. Your data source, whether it's an Excel file or a database, should have a structure like this:

• Street Address
• City
• State / Province
• Postal Code / ZIP Code
• Country

Why is this so important? Tableau uses fields like Country, State, City, and Postal Code to perform geocoding. It matches the text in these fields to its own internal database of known geographic locations and their corresponding latitude and longitude coordinates. It can't easily parse a single, combined address field. If your data isn't separated, your first step is to clean it up in your original tool (like Excel using "Text to Columns") before connecting to Tableau.

Tips for Data Preparation:

• Check for Consistency: Ensure spellings and abbreviations are consistent. "California," "CA," and "Calif." might be understood by you, but standardizing on one (like "CA") reduces the chance of errors in Tableau.
• Fill in Gaps: Missing city or postal code data for a row will prevent it from being mapped correctly. Try to fill in any blank but essential geographic fields.
• Have a Country Field: Especially if you operate in multiple countries, having a dedicated "Country" column is essential. It prevents ambiguity. For example, there's a Paris in Texas and a Paris in France, the Country field tells Tableau which one to plot.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Understanding and Assigning Geographic Roles

Once your data is connected, you need to tell Tableau which columns contain geographic information. This is done by assigning a "Geographic Role" to each relevant field. This assignment is the switch that tells Tableau: "Hey, this column isn't just text - it represents a specific type of location."

In the Data pane on the left side of your Tableau worksheet, you'll see a list of all the fields from your data source. Notice the small icon next to each field name. Text fields are marked with "Abc," number fields with "#," and date fields with a calendar icon.

To assign a geographic role:

1. Right-click on the data field you want to define (e.g., your "City" column).
2. Hover over Geographic Role.
3. Select the appropriate role from the list (e.g., City for your city field, State/Province for your state field, etc.).

When you do this, you'll see the icon next to the field name change from "Abc" to a small globe icon. This confirms that Tableau now recognizes this field as location data. You should repeat this for your City, State, Country, and Postal Code fields.

When you assign these roles, Tableau coordinates them to find the most accurate location. For instance, knowing the state and country helps it pinpoint the correct city, avoiding matches with cities that have the same name in different parts of the world.

Creating Your Map: Step-by-Step

With your data prepped and roles assigned, you're ready to create the map. Tableau's 'Show Me' feature and drag-and-drop interface make this part surprisingly simple.

Step 1: Generate Basic Latitude and Longitude

Tableau automatically generates Latitude and Longitude fields once you have assigned at least one geographic role. You will find these new, italicized fields at the bottom of the Measures section in your Data pane.

To start your map, simply double-click on one of your geographic fields (like Postal Code or State). Tableau will often be smart enough to automatically place the generated Latitude and Longitude on the Rows and Columns shelves and plot your data.

Alternatively, you can build it manually for more control:

• Drag Longitude (generated) to the Columns shelf.
• Drag Latitude (generated) to the Rows shelf.

You should see a single point on a world map. This is your starting canvas. If you see two maps, one on top of the other, make sure both Latitude and Longitude are set to "Dimension" not "Continuous Aggregates".

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 2: Add Your Locations to the Map

That single point isn't very useful yet. To break it down into all of your individual addresses, you need to add your geographic data to the Marks card.

Drag one of your geographic fields with the most specific detail - like Postal Code or City - onto the Detail button on the Marks card. Instantly, the single point will break out into multiple points, one for each unique postal code or city in your data set.

If you have exact addresses and want a point for each, your best bet is using Postal Code for detail. You don't want to place 'Street Address' on the detail mark, as that field is best used later for tooltips.

Enriching Your Map with Data and Detail

A map of dots is a good start, but the real power comes from using your other data (like sales, profit, or customer count) to add visual context.

Use Size and Color to Reveal Insights

The Marks card allows you to encode your data points with additional information. This is where you transform your map from a simple location plot into a powerful analytical tool.

• To show quantity: Drag a measure, such as Sales, onto the Size button. The dots on your map will automatically resize, larger dots will represent locations with higher sales.
• To show categories: Drag a dimension, such as Sales Region, onto the Color button. Tableau will assign a different color to each region, letting you see geographic clusters instantly.
• To show performance: Drag a measure, like Profit, onto the Color button. Tableau will create a color gradient (e.g., from orange to blue) where shades reveal profit levels, helping you quickly spot underperforming areas.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Add Context with Tooltips

At this point, you can hover over any dot on your map to see its details, like the city or sales value. But you can add much more information to this hover-over box, known as the tooltip.

Drag any fields you want to see - like Street Address, Customer Name, or Order Quantity - directly onto the Tooltip button on the Marks card. Now, when you hover over a data point, you'll see a rich, customized label showing all the details for that specific location without cluttering the map itself.

Troubleshooting: Fixing Unrecognized Locations

It's very common for Tableau to be unable to map a few of your locations. A spelling mistake, an unusual city name, or ambiguous data can trip it up.

When this happens, you will see a small gray indicator in the bottom-right corner of your map that says "# unknown".

To fix these unknown locations:

1. Click on the "# unknown" indicator. A dialog box will appear.
2. Choose Edit Locations.... This will open a new window showing a list of the data that Tableau couldn't recognize.
3. For any "Unrecognized" location, you can click into the text box and manually correct it. For example, if Tableau doesn't recognize "Los Angelos," you can type "Los Angeles." Tableau will often provide suggestions as you type.
4. If you have a location that simply doesn't exist in Tableau's geocoding database, you can also enter the latitude and longitude manually if you know them. This gives you full control to plot any point on the map.

Cleaning up these few unrecognized locations is a final polishing step that ensures every piece of your data is visualized accurately.

Final Thoughts

From cleaning your initial data to enhancing your final view with color, size, and tooltips, mapping addresses in Tableau turns simple location data into a dynamic analytical tool. Following these steps unlocks the geographic dimension of your business, revealing patterns and opportunities that are impossible to see in rows and columns alone.

Oftentimes, the hardest part of building marketing and sales reports is just getting all your data in one place - your CRM address data, advertising platform data, and sales data are all scattered. With Graphed, we make this frictionless. You can connect all your sources in just a few clicks and then simply ask for the visualization you need. Instead of wrestling with data cleanup and complex BI tools, you can just ask, "Show me a map of total sales by customer state for last quarter," and get an interactive dashboard instantly.