How to Plot Lat Long in Tableau

Transforming rows of location data into an insightful map is one of the most powerful things you can do in data visualization. If you have latitude and longitude coordinates, you have everything you need to plot precise locations in Tableau. This guide will walk you through exactly how to plot lat long data, enhance your map for analysis, and troubleshoot common issues along the way.

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

What You Need to Get Started

Tableau makes geographic analysis surprisingly simple, but it relies on your data being set up correctly. Before you start, make sure your dataset meets a few basic requirements for a smooth process.

Understanding Latitude and Longitude

First, a quick refresher on what these coordinates represent:

• Latitude (Lat) measures north-south position. It runs from -90° (South Pole) to +90° (North Pole), with 0° being the Equator.
• Longitude (Long) measures east-west position. It runs from -180° to +180°, with 0° being the Prime Meridian in Greenwich, England.

For Tableau to plot your data accurately, you need separate columns in your dataset for latitude and longitude. It's also crucial that both of these columns are formatted as a numerical data type, specifically a decimal number.

Example Data Structure

Your source data, whether in an Excel file, a CSV, or a database, should look something like this:

Store ID, City, State, Monthly Visitors, Latitude, Longitude 101, San Francisco, CA, 12000, 37.7749, -122.4194 102, New York, NY, 25000, 40.7128, -74.0060 103, Chicago, IL, 18000, 41.8781, -87.6298 104, Austin, TX, 15000, 30.2672, -97.7431

Notice how each location has its own row, with dedicated Latitude and Longitude columns containing numerical values. This simple structure is the perfect starting point.

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

Connecting and Preparing Your Data in Tableau

Once your data is ready, the first steps in Tableau involve connecting your data source and telling the software how to interpret your geographic fields. This is a critical step that makes everything else possible.

Step 1: Assign Geographic Roles

Tableau is smart, but it needs a little guidance. You need to explicitly tell it that your Latitude and Longitude columns represent geographic coordinates. This is called assigning a "Geographic Role."

1. After connecting to your data source in Tableau, go to the Data Source tab at the bottom left of your screen. You should see a preview of your data columns.
2. Look at the column headers for your latitude and longitude fields. Above each column name, there's a data type icon (e.g., # for numbers, Abc for strings).
3. Click the icon above your latitude column (Lat, Latitude, etc.).
4. In the dropdown menu, navigate to Geographic Role and select Latitude.
5. Repeat the process for your longitude column, this time navigating to Geographic Role and selecting Longitude.

When you've done this correctly, you'll see a small globe icon appear next to those fields in the Data pane on the left side of your worksheet. This confirms that Tableau recognizes them as geographical coordinates.

Creating Your First Map: A Step-by-Step Guide

With your data correctly configured, you’re ready for the fun part: building the map. The process involves dragging and dropping your newly defined geographic fields onto the correct shelves.

Step 2: Generate the Basic Map View

Tableau's Show Me feature can often build a map for you, but understanding the manual process gives you much more control and insight into how it works.

1. From the Data pane on the left, find your Longitude field and drag it onto the Columns shelf at the top of the workspace.
2. Next, find your Latitude field and drag it onto the Rows shelf.

Tableau will immediately generate a map. However, you'll probably only see one single point on it. Why? Because right now, Tableau is showing you the average of all latitude and longitude values in your entire dataset. To fix this, you need to tell Tableau what defines an individual point.

Step 3: Define the Level of Detail

Your "level of detail" is the field in your data that uniquely identifies each location you want to plot—like a city name, a customer ID, or a store number.

1. Find the dimension that serves as your unique identifier (e.g., Store ID or City from our example).
2. Drag this field onto the Detail box in the Marks card.

Instantly, the single point will break out into multiple points, one for each unique Store ID or City in your dataset. You now have a custom symbol map with all your locations plotted correctly!

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

Enhancing Your Map with Visual Analytics

Just plotting points is a great start, but the real power comes from encoding more data onto the map. The Marks card is your control center for adding layers of information to your visualization.

Add Context with Size

You can make the size of each dot correspond to a key metric. For instance, you could show which stores generate the most revenue or attract the most visitors.

• Find a measure in your Data pane, like Monthly Visitors or Sales.
• Drag this measure onto the Size box in the Marks card.

The dots on your map will automatically resize. Larger circles represent locations with higher values, making it easy to spot your top performers at a glance.

Separate Groups with Color

Color is one of the best ways to distinguish categories or highlight performance ranges. You can color your points based on either dimensions (qualitative data) or measures (quantitative data).

• To color by category (dimension): Drag a dimension like Region or Product Type onto the Color box. Tableau will assign a unique color to each item in that dimension, allowing you to see geographical clustering of different categories.
• To color by performance (measure): Drag a measure like Profit Ratio or Customer Satisfaction Score onto the Color box. Tableau will create a color gradient — for example, showing high-profit locations in dark blue and low-profit locations in light orange.

Provide Detail with Tooltips

Tooltips are the pop-up boxes that appear when you hover over a data point. By default, they show the fields already in your view, but you can add more information to provide richer context without cluttering the map.

• Drag any field you want to display—like Store Manager, Sales Reps, or Opening Date—directly onto the Tooltip box in the Marks card.
• Now, when you hover over a point on your map, the tooltip will provide a comprehensive summary of that specific location.

Common Issues and Quick Troubleshooting

Sometimes things don't go as planned. If your map isn't appearing correctly, it’s usually due to one of these common issues.

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

Problem: All my points are plotted in one spot in the middle of the ocean.

This is the "Null Island" problem, which happens when Tableau can't understand your geographic data. The most common cause is forgetting to define your level of detail.

• The Fix: Double-check that you have a unique identifier dimension (like Store ID, City, or a Customer name) on the Detail shelf in the Marks card. Without it, Tableau is only plotting the average of all coordinates.

Problem: A dialog box appears saying I have "unknown" or "ambiguous" locations.

This error typically points to issues within your source data.

• The Fix:

Problem: I created a density map, but it's just one colored blob.

When you change your mark type to Density to create a heatmap, you can often experience the same aggregation issue as with a default symbol map. Without a level of detail, it just shows an aggregated density for the whole map.

• The Fix: Even for a density map, you need to add your unique location identifier (like Store ID) to the Detail shelf. This tells Tableau to calculate the density based on the concentration of individual points, not just the regional average of the coordinates.

Final Thoughts

Plotting latitude and longitude coordinates is a fundamental skill in Tableau that turns your spreadsheets into a powerful tool for geographic analysis. By assigning geographic roles, dragging your fields to the marks cards, and defining your level of detail, you can quickly build insightful, interactive maps that reveal patterns you'd never find in a table of data.

Building visualizations step-by-step is a rewarding process, but at Graphed , we see a path to answering questions much faster. Instead of dragging and dropping fields, our platform lets you simply ask for what you want in plain English. For marketers and analysts looking at store performance or campaign results across different locations, being able to say "Create a map from our Shopify data showing order locations, and color them by order value" is huge. We built Graphed to eliminate the manual work, so you can go from data to a live, insightful dashboard in seconds, not hours.