How to create a heat map of your Foursquare check-ins using Google Fusion Tables

Do you want to create a cool heat map of your Foursquare check-ins? Of course you do! Who doesn’t like cool maps?! With Google Maps no longer supporting KML imports (which by the way makes no sense to me), Google Fusion Tables provides an alternative method for us map geeks to visualize our check-in data. Here are 3 steps to make it happen.

  1. Go to and click the KML link which will download a KML file of your check-ins.
  2. Log in to your Google Drive account which is where you’ll now find Fusion Tables under “Drive apps”.  Click create and upload your KML file.Fusion Tables
  3. Once uploaded, click on “Map of geometry” where you can toggle back in forth between a point map and a heat map.4SQ Feature Map

4SQ Heat Map

You can also import your KML file into Google Earth or give Mapbox ( a try. I have to admit the new Mapbox site is pretty stunning.




  1. Great article. This is only the past “X” check-ins. Any way to build one of these over a longer period of time, in an automated fashion? Maybe using IFTTT to have check in history go directly to Google Drive?

    1. As a work around I was able to add ?Count=10000 to the end of the KML URL which produced over 1700 check ins, and made my heat map much more exciting.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s