How to Plot Geographical Coordinates in Tableau

Plotting specific locations on a map brings data to life, and Tableau makes it surprisingly simple to turn pairs of latitude and longitude coordinates into rich, interactive visualizations. Forget manually placing pins on a static image, we're talking about dynamic maps you can use to analyze sales by territory, customer density, or logistics routes. This tutorial will walk you through the exact steps to plot geographical coordinates in Tableau and start customizing your maps to uncover powerful insights.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Start with Properly Formatted Data

Tableau is powerful, but it relies on you to provide data in a structure it understands. Before you even open the application, ensure your data source (like an Excel or Google Sheet) is set up for success.

Key Data Requirements

For Tableau to plot coordinates accurately, your dataset must contain at least two separate columns:

• Latitude: A column containing the latitudinal coordinates (the north-south position).
• Longitude: A column containing the longitudinal coordinates (the east-west position).

These values should be in a Decimal Degrees format. For example, the coordinates for New York City would be approximately 40.7128 in your Latitude column and -74.0060 in your Longitude column. Tableau prefers these to be formatted as decimal numbers. While Tableau can sometimes interpret coordinates with degrees, minutes, and seconds (DMS), decimal degrees are far more reliable.

Beyond the coordinates, your data should include other dimensions and measures to make your map meaningful. This could include things like store names, city names, sales figures, profit, customer counts, or any other metric you want to visualize.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Example Data Structure

Here's what a simple, well-structured dataset for mapping store locations might look like in a spreadsheet:

Step-by-Step: How to Plot Coordinates in Tableau

Once your data is ready, you can jump into Tableau. Follow these steps to get your first map up and running.

1. Connect to Your Data Source

First, open Tableau and connect to the file or server containing your location data. In the "Connect" pane on the left, choose the appropriate connector, such as Microsoft Excel, Google Sheets, or Text File if you're using a CSV.

Navigate to your file, select it, and Tableau will load it onto the Data Source screen. Here, you'll see a preview of your data columns. You can confirm that Tableau has correctly identified the data types (e.g., number, string).

2. Assign Geographic Roles (The Crucial Step)

This is where you tell Tableau that your "Latitude" and "Longitude" fields aren't just regular numbers - they represent coordinates on a globe.

• Go to a new worksheet. In the "Data" pane on the left, find your Latitude and Longitude fields.
• Tableau is smart and often recognizes these fields automatically, displaying a small globe icon next to their names. If you see the globe, you can move to the next step!
• If you see a "#" icon (indicating a numerical measure) instead, you'll need to assign the role manually. Right-click your latitude field, hover over Geographic Role, and select Latitude.
• Do the same for your longitude field, but this time select Longitude. The icons should change to globes. This tells Tableau exactly how to use these values.

Pro Tip: Ensure that your Latitude and Longitude are continuous measures (their pills will be green when you drag them into the view). If they appear as discrete dimensions (blue pills), right-click the field in the view and select "Dimension" to change it.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

3. Generate the Basic Map View

Now you can create the map visualization itself. This is a simple drag-and-drop process.

• Drag your Longitude field from the Data pane and drop it onto the Columns shelf at the top of the workspace.
• Next, drag your Latitude field and drop it onto the Rows shelf.

Instantly, Tableau will generate a world map. However, you'll likely only see a single dot. This is because Tableau has aggregated all your coordinates into a single, average point. The next step is to break them out into individual locations.

4. Add Level of Detail

To see each individual point from your dataset, you need to tell Tableau what makes each row unique (e.g., the "Store ID" or "City").

• From the "Data" pane, find the dimension that uniquely identifies each location. Using our example data, this would be Store ID or City.
• Drag this dimension and drop it onto the Detail card within the Marks pane.

Now, the map will update to show a separate point for each unique Store ID in your dataset, plotted at its correct latitude and longitude. You've successfully plotted your coordinates!

Customizing Your Map for Deeper Insights

A map with just dots on it is a good start, but the real power comes from using your other data fields to add visual context. Here's how to turn your basic plot into a rich data story.

Use Size to Show Scale

You can make the size of each dot correspond to a key metric, like sales or population.

• Drag a measure, such as 2023 Sales, from the Data pane.
• Drop it onto the Size card in the Marks pane.

The dots on your map will automatically resize. Stores with higher sales will be represented by larger circles, giving you an immediate visual cue about top performers.

Use Color to Differentiate or Highlight

Color is a great way to show categories or a range of values.

• For Categories: If you want to color-code by a category like "State" or "Region," drag that dimension field onto the Color card. Each state will be assigned a different color.
• For Metrics: If you want to show performance levels, drag a measure like Profit onto the Color card. Tableau will create a color gradient - for example, ranging from orange for low profit to blue for high profit - making it easy to spot underperforming and overperforming locations.

Enhance Tooltips for More Information

The tooltip is the little box of information that appears when you hover over a data point. By default, it shows the latitude and longitude, but you can add more valuable context.

• Drag any fields you want to show - like City, State, and 2023 Sales - onto the Tooltip card.
• Now, when you hover over a point, you'll see a clean summary of that location's key data without cluttering the map. You can even click the Tooltip card to edit formatting and phrasing.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Change Map Background and Layers

Sometimes the default map style doesn't fit your dashboard's theme. Tableau gives you options.

• In the top menu, go to Map > Map Layers.
• A pane will open on the left, allowing you to change the background style (Light, Dark, Satellite), and add or remove map layers like Streets, Place Names, or County Borders.

Troubleshooting Common Map Issues

Even with a straightforward process, you might hit a snag. Here are a few common problems and how to solve them.

• Issue: All my points are clumped as a single dot. Solution: This almost always means you forgot to add the level of detail. Drag the dimension that uniquely identifies each row (like "ID", "Name", or "Address") onto the Detail card in the Marks pane.
• Issue: My map has an "Unknown" location warning. Solution: Tableau shows this at the bottom right corner when some of your data points have null or invalid coordinates. Click the warning, and you'll get an option to either filter out the null data or review it. Check your source data for any typos, missing values, or coordinates that are clearly incorrect (e.g., Latitude of 200).
• Issue: Tableau isn't showing a map at all, just a scatter plot. Solution: Double-check that your Latitude and Longitude fields have the globe icon next to them in the Data pane. If not, right-click and re-assign their Geographic Role. Also, ensure they are set as continuous measures (green pills).

Final Thoughts

Plotting geographic coordinates on a map is one of Tableau's most powerful features, turning simple spreadsheets into an interactive platform for analysis. By ensuring your data is properly formatted, assigning the correct geographic roles, and using the Marks card to add layers of detail like size and color, you can build incredibly insightful visualizations quickly.

Mastering tools like Tableau is a huge step, but a lot of the battle happens before you even open the app - getting all your data sources connected and prepared for analysis. That's where we wanted to remove the friction. Using Graphed, you can connect your Shopify, Salesforce, Google Analytics, and ad platforms in minutes. Instead of manually exporting CSVs to build your maps, you can just ask a question in plain English like, "Show me a map of sales per city for last quarter," and instantly get an interactive dashboard that updates in real time. We built it to automate the manual data wrangling so you can spend less time downloading reports and more time finding opportunities.