Create: a map (classic)

Google Fusion Tables is a online data management application, designed for easy collaboration, data visualization and web publishing. It allows you to upload and merge large datasets and offers simple data queries and filters. View the Example Gallery to see how tables can tell stories.

This tutorial shows you how to upload data to generate a map with placemarks in Fusion Tables. It also steps you through customizing the markers' info window layout.

Import the sample dataset

Go to Google Drive. You need to be logged into your Google Account. Note that you can't use a Google Apps accounts for Fusion Tables. You'll have to use a non-Apps Google account instead. (Create a Google Account if you don't already have one.)

Your newly uploaded data now appears in a new Fusion Table with thumbnails in the two columns of URL links to images:

Map the data

Fusion Tables auto-detects location data in a table so when you choose Visualize > Map, you immediately view the data on a map.

Choose Visualize > Map.

The map appears, with several small red placemarkers scattered across the countryside.

Click a placemarker to view the information available for that row. The default info window template appears.

That's it! You've mapped a spreadsheet of data.

Customize the info window template [Optional]

The default info window template automatically uses the first ten columns for this table, but you can customize which data appears and how it is displayed:

While looking at the map visualization, click the Configure Info Window link at the top edge of the map.

You can experiment by checking column check boxes to add or remove information from the Automatic info window template.

If you want to customize the overall style and content of the info window template, click the "Custom" tab. The HTML for the default (automatic) columns set is displayed.

To see how you can change the output format, copy and paste the code below into the text box. Note that you indicate a column by using its name inside curly brackets. For example, to insert the species name in the balloon, put {herbivore species} into the template code.