Step 1: Go to Google Fusion Tables

You must have a Google Account to start using Fusion Tables. If you don’t have a Google Account sign up and go to this link: https://www.google.com/fusiontables/ & then click on Create a Fusion table.

Step 2: Choose Data to Import to Google Fusion Tables

Before we begin, we need to import data into Fusion tables. We have three options 1) Upload a File 2) Import from Google Spreadsheets 3) Update Data from an Empty Table

In this example, we have chosen data from a Google Spreadsheet. Choose the appropriate Google spreadsheet & click Next

Step 3: Make sure the Imported Data is correct

Review the data from the file you imported to make sure everything is correct and click next

Step 4: Describe the Table & Data you are importing

You can give table headings, description, data source & other attribution details to share the data.

Step 5: Give the appropriate column a “Location” type

For Google to appropriately Geocode the data, we need to give them. For example, if the Home Insurance Rates information is from Chicago, then we need let Google Geocode the information to correctly represent it on a map. To do this:

1. Click on the appropriate column

2. Then Choose Change

3. On the Next Page, Choose “Location” for the type

4. Then hit Save

Step 6: Add Map to show the Data

Click on “Add Map” to show the data on a map. Once you have clicked on Map, it may take some time to Geocode the locations in the given column. After you have done the Geocoding, the data will be shown in the Map