Make a Map with Excel Data Using Google Fusion Tables

This article will take you though a step-by-step example of using an Excel spreadsheet that contains location information to make a map using Google Fusions Table.
Make a Map with Excel Data Using Google Fusion Tables

For this example, an Excel file containing the rank of Fortune 1000 companies for 2014 will be used.  In the screenshot below, the Excel data contains the Fortune 1000 company name, 2014 rank, 2013, CEO, and location information stored in the columns.

Importing Your Excel File into Google Fusion Tables

While many of Google’s products are free to use, you need to have an account set up first.  If you don’t already have an account set up with Google (such as a gmail address), set on up first.  You can do this by clicking on the “create account” link found on any of the login pages for Google’s products.

To get started, you first have to set up a Google Fusion Table.  To do so, visit and sign in with your Google account.   To start a new Google Fusion Table, click on the red create button and then select Fusion Table from the list.
This will bring you to the import table screen where you can upload your Excel file.  To do so, click the choose file button and then navigate to the location on your computer where the file is stored.  In addition to Excel files, Google also accepts delimited text (such as .txt or .csv) and KML files.  Once the file is selected, click on the next button.
The next page allows you to visually verified that the data was imported properly.  If the first column has the column names, you can designate this and select none if the columns names are missing.  If everything looks okay, select the next button.
The next screen shows the metadata for the table.  Here you can add in a name for the table (or accept the default name extracted from the file name).  You can also allow the data to be exported by others, add a description, and set the information about attribution of the data.

Once you’ve filled out the form, hit the finish button to import the Excel spreadsheet into your Google Fusion Table.  One the import has finished, you will be presented with a view of your imported data.  Google automatically attempts to recognize locational information.  If it does, the data in the identified column will be highlighted in yellow.

Then you can sitting up your Excell to Map

No comments:

Post a Comment