Excel GIS Data Analysis: Maps, Methods, and Limits Explained

How-to basics · Updated November 18, 2026

Excel can organize, check, summarize, and map geographic data, but it is not a full geographic information system (GIS). In Microsoft Excel for Microsoft 365 on Windows, use a Filled Map chart for region-based values, 3D Maps for mapped points and geographic layers, and formulas or PivotTables for tabular analysis; use dedicated GIS software when you need spatial operations such as clipping, buffering, or polygon overlays.

How Excel fits into GIS work

A GIS stores and analyzes information linked to places, often using points, lines, and polygons with defined geographic coordinates. Excel is primarily a spreadsheet: it is strong at cleaning rows and columns, calculating measures, aggregating records, and making charts. Its geographic features make it useful for parts of a GIS workflow, but they do not turn a worksheet into a spatial database or provide the full set of GIS analysis tools.

Excel is a practical choice when the question is mainly about summarizing locations or displaying results—for example, comparing monthly sales by state, counting service calls by postal code, or showing store locations alongside a table of revenue. It can also act as a handoff point: a GIS analyst can export a table of attributes and coordinates for review in Excel, then return the cleaned data to GIS software.

The key distinction is between mapping a value to a place and analyzing spatial relationships. A map that colors states by sales is a geographic visualization. Finding every parcel within 500 meters of a river, intersecting two boundaries, or calculating a route network is spatial analysis and generally calls for a GIS application.

Prepare location data before mapping

Map quality depends on accurate, consistently formatted location fields. A tidy table should usually have one record per observation, a header row, and separate columns for the location identifiers and the measures being analyzed. Avoid merged cells, subtotals embedded among records, and blank rows within the table. Convert the range to an Excel table with Insert > Table so it is easier to filter, expand, and use as a chart source.

Choose the right type of location data for the task:

  • Named areas: country, state, province, county, or city names are useful for regional summaries, but ambiguous names may need additional context such as country or state.
  • Postal codes: keep them as text. Numeric formatting can remove leading zeros, and postal codes are identifiers rather than quantities to add together.
  • Coordinates: keep latitude and longitude in separate numeric columns. Latitude ranges from -90 to 90 and longitude from -180 to 180 in the usual decimal-degree format. Check that the source uses the coordinate reference system and datum you expect.
  • Dates and measures: store dates as Excel dates and measures as numbers, with units documented. A column mixing text such as “unknown” with numeric values can interfere with calculations and mapping.

For a named place, Excel may need to resolve which location you mean. A table containing “Springfield” alone is less specific than one containing city, state, and country. In the Geography linked data type, select a cell or range and use Data > Data Types > Geography. When Excel recognizes a place, it can link the cell to geographic information and expose available fields. This feature depends on Microsoft 365, connected online services, and regional availability; it is not a substitute for validating a complete address or geocoding a large address file.

Choose the right Excel map

Excel offers different mapping features for different inputs. A Filled Map chart shades recognized geographic regions according to a value. It is suited to summaries such as population by country or orders by state. It is not designed to plot a dot at every latitude-and-longitude pair, and it does not show street-level detail or perform spatial overlays.

3D Maps, formerly known as Power Map, is designed to display geographic data over a globe or map and can show points, categories, and time-based changes. It is useful for location records with coordinates or recognizable geographic fields, such as store sites, incidents, or shipments. The desktop 3D Maps feature is available in Excel for Windows; it is not available in Excel for Mac or Excel for the web in the same way.

For either map, consider whether the geography matches the message. A state-level chart can support a state-level comparison, but it cannot reveal the distribution of individual customers inside each state. A map may look precise while only representing an area-level total. State the aggregation level and avoid implying that a regional average describes every person or site in that region.

Create a region-based Filled Map

For a simple regional comparison, arrange the data with one column for geographic names and another for the numeric measure. For example, a table could list a country in column A and the number of service requests in column B, with one row per country. Select the data, then choose Insert > Maps > Filled Map. Excel uses its map service to identify supported regions and create a shaded chart.

Review the result rather than assuming every label was interpreted correctly. If an area is missing or assigned unexpectedly, add a higher-level location field, standardize spelling, or use a more specific region name. A chart title, legend, and data labels can help readers understand what the shading represents. Keep the measure’s unit clear: “requests” and “requests per 1,000 residents” can produce very different interpretations even when they use the same underlying locations.

Filled Map charts have limits. They map supported geographic areas, not arbitrary shapes or custom property boundaries, and they do not make a region-level value more precise than the source data. Availability can also vary by Excel edition, locale, and online map-service access. If the Maps command is unavailable, check the Excel version and organization settings, or use a GIS program to create the map.

Plot coordinate records with 3D Maps

When each row represents a point, include columns such as site name, latitude, longitude, category, date, and a value to display. In Excel for Windows, select a cell in the data table and choose Insert > 3D Map > Open 3D Maps. In the 3D Maps window, use the layer pane to assign the latitude and longitude fields, and choose how a numeric measure or category should be visualized. If using place names instead of coordinates, confirm that Excel identifies the intended geography.

Before interpreting the display, check a few known locations. Latitude and longitude are easy to swap, and coordinates entered in the wrong order can put points in an implausible location. Look for impossible values, zeros that indicate missing data in some datasets, and mixed coordinate systems. A city name may map to a city center rather than to the exact address of a record; coordinates are generally more suitable when point-level placement matters.

3D Maps can help explore where records cluster and how a measure changes over time, but visual clusters are not proof of a causal relationship or statistically significant hotspot. The result depends on the map scale, aggregation, symbol size, and completeness of the records. For formal hotspot statistics, spatial interpolation, or advanced clustering, use GIS or statistical software that provides the relevant methods and documentation.

Analyze coordinates with worksheet calculations

Excel can calculate useful attributes from coordinates, though those calculations remain spreadsheet analysis. For example, a straight-line distance between two points can be estimated with the Haversine formula. It measures distance over an assumed spherical Earth and is not a road, walking, or travel-time distance.

Assume A2 contains the starting latitude, B2 the starting longitude, C2 the destination latitude, and D2 the destination longitude, all in decimal degrees. This formula uses an approximate Earth radius of 6,371 kilometers; for New York City (40.7128, -74.0060) to Los Angeles (34.0522, -118.2437), it returns about 3,936 km.

=2*6371*ASIN(SQRT(SIN(RADIANS(C2-A2)/2)^2+COS(RADIANS(A2))*COS(RADIANS(C2))*SIN(RADIANS(D2-B2)/2)^2))

Use the result as an approximate great-circle distance, and check the inputs and units before filling the formula down a column. The formula does not account for roads, terrain, restricted access, or the exact shape of the Earth. Excel can also calculate summaries by category, date, or location using PivotTables and ordinary functions, but grouping records by the nearest boundary or measuring polygon area requires more than a standard worksheet calculation.

Bring GIS data into Excel and back

A common workflow is to export a GIS attribute table as a CSV file, open it in Excel, clean names or fields, and return the edited table for use in GIS. CSV is convenient for plain tabular data, but it does not preserve GIS geometry, styling, coordinate reference systems, or relationships between spatial layers. Keep the original GIS project or data file as the authoritative spatial source.

Excel can import text and structured data through Data > Get Data, including data sources supported by Power Query. A GeoJSON file is structured text, but its nested geometry is not automatically treated as a fully editable GIS layer just because it can be imported as JSON. For reliable exchange, use GIS software to export the needed attributes and coordinates to a flat table, and retain identifiers that allow the rows to be joined back to the spatial features.

When preparing a table for re-import, avoid changing unique IDs, coordinate precision, or text codes unintentionally. Preserve a copy of the original export, record the coordinate system, and document any filtering or transformations. If rows were removed, joined, or aggregated, verify that the output still has the granularity and keys the GIS workflow expects.

Common problems and how to avoid them

  • Locations do not resolve: add a country or state field, correct misspellings, and confirm that the selected map feature supports that geography.
  • Postal codes lose zeros: import or format the field as text before editing, rather than relying on a numeric display format after the zeros have been removed.
  • Points appear in the wrong place: verify latitude versus longitude order, decimal-degree units, valid ranges, and the source coordinate reference system.
  • Map is blank or unavailable: check that the data are in a supported structure, that online map services are permitted, and that the Excel edition includes the feature.
  • Totals look misleading: verify whether records are counts, rates, or raw totals, and make sure the map’s geographic level matches the question.

One persistent misconception is that Excel can “do GIS” simply because it can display a map. A map visualization is only one step. Spatial joins, buffers, topology checks, raster analysis, and network routing require spatial data structures and algorithms that ordinary Excel charts and worksheet functions do not provide.

When Excel is enough—and when to use GIS

Excel is often enough for small, clean datasets when the goal is to inspect a table, calculate summaries, or communicate a regional pattern. It is also approachable for colleagues who already work in spreadsheets. For a dashboard of sales by state or a quick display of geocoded store points, the built-in map options can be sufficient.

Use dedicated GIS software when the work depends on geometry or spatial relationships, when you need custom boundaries or multiple spatial layers, or when a reproducible spatial workflow matters. Options include QGIS, an open-source desktop GIS, and ArcGIS products from Esri. Which tool fits depends on data formats, organizational requirements, skill, and whether the analysis needs desktop, web, or enterprise capabilities.

A useful decision rule is to ask what operation produces the answer. If it is a spreadsheet aggregation grouped by a known region, Excel may handle it well. If the answer depends on what is inside, near, connected to, overlapping, or reachable from another geographic feature, use a GIS and treat Excel as a supporting tool for tabular cleanup or reporting.

Frequently Asked Questions

Can Excel be used as a GIS?
Excel can map and analyze geographic tables, but it is not a full GIS. It lacks many tools for managing geometry and conducting spatial operations such as buffering or overlay analysis.

Can Excel map latitude and longitude?
Yes. In Excel for Windows, 3D Maps can display records using latitude and longitude columns. A Filled Map chart is for supported geographic regions, not plotting individual coordinate points.

Can Excel open a shapefile?
Excel does not natively open a shapefile as a complete GIS layer. Export its attributes and, if needed, coordinates from GIS software to a table such as CSV; the export will not preserve the layer’s geometry and GIS properties as a shapefile does.

Is Excel’s map data always accurate?
No mapping service guarantees that every label is resolved as intended. Ambiguous names, incomplete addresses, unsupported areas, and stale source data can cause errors, so check representative locations and compare results with an authoritative source.

What is the difference between a map chart and 3D Maps?
A Filled Map chart colors supported regions according to values. 3D Maps is intended for geographic records such as points and can display layers and time-based data. Neither replaces a full GIS for spatial analysis.

Can Excel calculate driving distance between locations?
Not with the straight-line coordinate formula shown above. Driving distance and travel time depend on a road network, route restrictions, and often live data; use a routing service or GIS network-analysis tool for those results.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.