[ODK Community] Trouble exporting data


(1) Publish to Fusion Tables and use the wide view of the data to display
all the household data long with the individuals


(2) Use ODK Briefcase (

Run ODK Briefcase and Pull data from your server to your computer.
Then export as CSV

This will produce a CSV for the top-level set of questions, and a CSV for
each repeat group within it (i.e., each household member).

You can then import the two CSV files into a sinle Excel spreadsheet and
use the linkage columns (KEY, PARENT_KEY) to link the two sheets together.


ยทยทยท On Thu, Dec 12, 2013 at 5:56 PM, wrote:


We have a question from our survey that asked about employed persons in a
household. If the respondent answered any number greater than 0, 5
additional questions would show up for each member that was employed. The
issue lies in the data, where I cannot recover this information without
going onto the web (the cell in excel refers me to appspot.com). We have
approximately 4000 observations, and going through individually would be
quite tedious. Is there a simpler or more efficient way to extract this
information? Thank you very much in advance.


Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

You received this message because you are subscribed to the Google Groups
"ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

Mitch Sundt
Software Engineer
University of Washington