We cover the ODK Build method below but if you’re interested in other methods you can learn more in the ODK Docs.Ĭreate a new account or log in with an existing account. Most ODK users design their forms in Excel but if you're creating a form for the first time, ODK Build may be the simplest way to start. You can use ODK Build (a drag-and-drop form designer) or design your form in a spreadsheet using XLSForm. There are several ways you can create forms for ODK. Tutorial ContentsĬreate Your Form for Data Collection & Submissions If you need a more robust option for your project, review our ODK Aggregate tutorial. This is a simple, user-friendly way to manage and store your ODK data without having to set up a server like ODK Aggregate. If your form includes photos, they will be stored unlisted on your Google Photos Album Archive and linked to from Google Sheets. When you’re back online, send it to Google Sheets. Then, collect data on your mobile device offline in the field. Upload your ODK forms to Google Drive and ODK Collect will find them. The Google Drive and Google Sheets option makes setting up a mobile data collection effort simple. Google Drive and Google Sheets, allowing ODK Collect to access survey forms in your Google Drive account and send data collected on an Android device directly to Google Sheets.ODK Aggregate, allowing you to host survey forms and responses on your own cloud-based server.

To learn more about ODK, view recent updates, more tutorials, and to contribute to the project, visit When using ODK Collect, you have several options for where to send the data you’ve collected in the field: Streamline the data collection process with ODK Collect by replacing traditional paper forms with electronic forms that allow text, numeric data, GPS, photo, video, barcodes, and audio uploads to an online server.Ĭreated by developers at the University of Washington's Computer Science and Engineering department and members of Change, Open Data Kit is an open-source project available to all.

Open Data Kit (ODK) is a open-source suite of tools that allows data collection using Android mobile devices and data submission to an online server, even without an Internet connection or mobile carrier service at the time of data collection. More and more organizations are using mobile devices to collect data in the field.

Convert xml to csv google sheets