ODK Drive to Sheets (Advanced)

IMWCA17: Open Data Kit

Important Links

If you would like to use your personal Android device for the hands-on activities:

hands-on activity #1: collect data

If using your own Android phone:

  1. Download the ODK Collect app from the Play store
  2. Open the ODK Collect app and download the “imw17” form to your phone:
    • Click "Get Blank Form"
    • Click "Shared with Me" at the bottom of the screen to see files that have been shared with you.
    • Select “imw17.xml” and click "Download Selected".

If borrowing a phone, start here

3. With the ODK Collect app open, fill out the form:

    • Click "Fill Blank Form"
    • Select "imw17"
    • Fill out each survey question. Get to the next question with a swipe left.
    • At the end, Save form.

4. Submit your data:

      • Click "Send Finalized Form"
      • Select Form
      • Click "Send"

hands-on activity #2: create a form

    1. Go to build.opendatakit.org
    2. Create an account
    3. Give your blank form a title. The title should be one word only.
    4. Click on the "Text" button at the bottom to add a text question.
    5. On the right, edit the question.
      1. Fill out the Data Name field (one word, no punctuation). This is your column header. i.e. "name"
      2. Fill out the Label field (no limits). This is the question that will appear on your phone. i.e. "What is your name?"
    6. Click on the "Location button" to add a GPS location question.
    7. Add one more question of your choosing, for example a Photo question.
    8. Click File > Save.

hands-on activity #3: Deploy your form

  1. Create a Google Drive folder for your ODK project.
    1. Go to drive.google.com
    2. Add new > Folder. Give the folder a name.
  2. In Drive, create a response Sheet in the Drive folder.
    1. Add new > Sheet.
    2. Click Share and make the Sheet "Anyone with the link can edit"
    3. Copy the Sheet URL
  3. In ODK Build, click Edit > Form Properties. Enter the Sheet url in the submission URL field.
  4. In ODK Build, download your form as an XML. Click File > Export to XML. Then in the pop up, click "Download"
  5. In Drive, upload your XML file.
    1. Click New > Field Upload to upload your xml form to the Drive folder.
    2. Click on the XML file inside the folder, then click Share button.
    3. Change the settings to "Anyone with the link" can edit.
  6. On your phone, Get Blank Form to find your new form.
  7. Fill out your survey. Use Send Finalized Form to send at least one response.
  8. Look to make sure the submitted data appears in your Response sheet


  1. Create a new My Map. Two ways to do this:
    1. In Google Drive, click New > More > Google My Map
    2. Go to mymaps.google.com and click "Create New Map".
  2. Give the map a title and description.
  3. Under "Untitled Layer", click "Import".
  4. In the pop-up, click "Google Drive and click your response sheet, then "Select"
  5. Your ODK data should load on the map.


Open Data Kit for field data collection forms

Open Data Kit website

ODK Build for form building on your laptop

ODK Collect for Android devices from the Play Store

Advanced form building using XLSForm


XLS to XML converter

Google Drive for managing your response data

Go to Google Drive

Google Drive Help

Google Drive Sheets for response spreadsheet

Geotools to make maps with ODK data in Google Sheets

Google My Maps

Google Earth Pro

Google Fusion Tables

Google Earth Engine