Spatial File

This topic describes how to connect Tableau to Shapefiles, MapInfo tables, KML (Keyhole Markup Language) files, TopoJSON files, GeoJSON files, and Esri File Geodatabases.

Note: Connecting to spatial data is supported in Tableau Desktop version 10.2 and later.

If you have Tableau Desktop version 10.1 or earlier, and would like to use shapefile data to create map views, see Create Tableau Maps from Shapefiles in the Tableau Desktop 10.1 Help.

Before you connect

Before you can connect to spatial files, make sure to include all of the following files in the same directory:

  • For Esri shapefiles: The folder must contain .shp, .shx, .dbf, and .prj files as well as .zip files of the Esri shapefile.

    For Esri File Geodatabases: The folder must contain the File Geodatabase's .gdb or the .zip of the File Geodatabases’s .gdb.

  • For MapInfo tables (Tableau Desktop only): The folder must contain .TAB, .DAT, .MAP, and .ID or .MID and .MIF files.

  • For KML files: The folder must contain the .kml file. (No other files are required.)

  • For GeoJSON files: The folder must contain the .geojson file.(No other files are required.)

  • For TopoJSON files: The folder must contain the .json or .topojson file. (No other files are required.)

Note: You can only connect to point geometries, linear geometries, and polygons in current versions of Tableau. You cannot connect to mixed geometry types.

Also note that if your data does not display diacritics (accent marks on characters) properly, check to make sure the file is UTF-8 encoded.

Make the connection and set up the data source

In Tableau Desktop: click the New Data Source icon and select Spatial file.
In Tableau Online or Tableau Server (Creator role): Select Create > Workbook. Select the Files tab.

Then do the following:

  1. Navigate to the folder that contains your spatial data and select the spatial file you want to connect to.

  2. Select Open.

Spatial file data source example

Here is an example of a spatial file data source using Tableau Desktop on a Mac computer:

Work with the Geometry column

There are many tasks that you can optionally perform on your data before you start your analysis, such as hiding or renaming fields. Note, however, the following restrictions apply when working with the Geometry column:

  • You can't hide the Geometry column.

  • You can't split the Geometry column.

  • On the data source page, you can't create a calculated field using the Geometry column.

About .ttde and .hhyper files in Tableau Desktop

You might notice .ttde or .hhyper files when navigating your computer's directory. When you create a Tableau data source that connects to your data, Tableau creates a .ttde or .hhyper file. This file, also known as a shadow extract, is used to help improve the speed your data source loads in Tableau Desktop. Although a shadow extract contains underlying data and other information similar to the standard Tableau extract, a shadow extract is saved in a different format and can't be used to recover your data.

In certain situations, you might need to delete a shadow extract from your computer. For more information, see Low Disk Space because of TTDE Files in the Tableau Knowledge Base.

 

See also

Create Tableau Maps from Spatial Files

 

Thanks for your feedback! There was an error submitting your feedback. Try again or send us a message.