← back to Managing Data

Using your Fulcrum Data with Google Fusion Tables

How to upload your Fulcrum data and use it within Google Fusion Tables

Google Fusion Tables is a way to store, manage, share, and even visualize data from the web. It’s entirely free; all you need is a Google account to get started. With Fulcrum as your means for data creation, getting that data into Fusion Tables is simple and can be incredibly useful for any project.

Exporting your Fulcrum Data

The first step to getting your data into Fusion Tables, is to export your Fulcrum data to a CSV file. You could also use the KML format. Go to your app library, and from the app settings box, click “Export Data”:

Export Data

Follow the steps of the export wizard and be sure that CSV (or KML) is selected as your export file format.

Select CSV

Once the export process has finished, download the file from the exports list.

Download Exported File

Once you have downloaded the CSV file you may have to unzip it if it contains photos.

Uploading your Fulcrum Data to Google Fusion Tables

Go to Google Fusion Tables and select “Create a New Table”. If you want to, you can also download the Fusion Tables Google Chrome web app. Browse and select your CSV file and ensure that the Comma box is checked. If you are using a KML file, the separator character selection won’t appear.

Select Your CSV File

After clicking next, it will prompt you to edit information such as the title, description, etc, which you can do as needed. Once you have your data imported, it will bring you to the table view. Now you can filter your data, modify it, and even map it.

Add Information

If you would like to add photos, simply insert a URL for each photo in the column. You will also need to adjust the line format though the column settings. You can use the images exported with your Fulcrum records. Be sure to upload them to the web somewhere (for this example, I used Photobucket).

Using Exported Images

Creating Maps and Charts with Fusion Tables

Fusion Tables can really come in handy if you are not very knowledgeable or experienced with mapping, since you can use this tool to create a map. Simply click the “map of latitude” tab. This will automatically generate a map of your data. You can choose to filter by specific features, change the marker icons, and more. When you are finished you can share the map by emailing it to others, downloading it, posting a link on social media, or even embedding it in a website.

Generate Map in Fulcrum

Creating a map isn’t the only Fusion Tables feature that can enhance your Fulcrum experience; you can also create charts and graphs. Simply select the ‘+’ tab and then ‘add chart’.

Select Plus Tab

Once in the charts section, all you have to do is select which type of chart or graph you want. In this example, I chose to create a pie chart showing which school districts have the most houses for sale. It is very easy to setup and modify; you can even change the colors.

Create Pie Chart

Still have questions? Browse our support forum and drop us a line.

Go to support