# Exporting metadata **URL:** \ **Category:** Support\ **Created:** [November 29, 2012, 3:57am UTC](https://forum.getodk.org/t/exporting-metadata/1800 "2012-11-29T03:57:09Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![KoboUser.RSS](https://getodk.b-cdn.net/letter_avatar_proxy/v4/letter/k/3d9bf3/32.png) [@KoboUser.RSS](https://forum.getodk.org/u/KoboUser.RSS)\ **Post date:** [November 29, 2012, 3:57am UTC](https://forum.getodk.org/t/exporting-metadata/1800/1 "2012-11-29T03:57:09Z")
Hi group, I would like to separate my exported data based on time they were submitted to aggregate. Can someone tell me how to include the metadata in exports from aggregate to excel? Thanks! Rachel ---
**Author:** ![Mitch\_S](https://getodk.b-cdn.net/letter_avatar_proxy/v4/letter/m/3ec8ea/32.png) [@Mitch\_S](https://forum.getodk.org/u/Mitch_S)\ **Post date:** [November 29, 2012, 5:38pm UTC](https://forum.getodk.org/t/exporting-metadata/1800/2 "2012-11-29T17:38:06Z")
There was a bug that prevented this from working in earlier versions and in the current version, it is a little quirky. Be sure you are running the very latest ODK Aggregate (check the version on the Site Admin / Preferences page). To include the metadata in the export: (1) go to the "Submissions" tab displaying your form data (2) Click 'Display metadata' Ideally, at this point, you would click 'Save' and be done creating a filter that displayed the metadata. However, this gives an error about there not being at least one filter. So... (3) Click "Add Filter" (4) choose "Display" "Rows" where "_meta-is-complete_" "equals" true (this has no effect on the result set because no other value is possible for this metadata field -- the queries that display rows already apply exactly this filter clause) (5) Click "Apply Filter" (6) Click "Save" and name your filter something like "All data including metadata" Now, choose Export, select this filter as the filter to apply to the export, and proceed to generate the CSV file. That will now contain the metadata. This same filter can be used to publish the metadata to an external service, etc. Mitch > **···** > > On Wed, Nov 28, 2012 at 7:57 PM, rsklar wrote: > > > Hi group, > > > > I would like to separate my exported data based on time they were > > submitted to aggregate. Can someone tell me how to include the metadata in > > exports from aggregate to excel? > > > > Thanks! > > > > Rachel > > > > -- > > Post: [opendatakit@googlegroups.com](mailto:opendatakit@googlegroups.com) > > Unsubscribe: [opendatakit+unsubscribe@googlegroups.com](mailto:opendatakit+unsubscribe@googlegroups.com) > > Options: [http://groups.google.com/group/opendatakit?hl=en](http://groups.google.com/group/opendatakit?hl=en) > > -- > Mitch Sundt > Software Engineer > University of Washington > [mitchellsundt@gmail.com](mailto:mitchellsundt@gmail.com) ---
**Author:** ![KoboUser.RSS](https://getodk.b-cdn.net/letter_avatar_proxy/v4/letter/k/3d9bf3/32.png) [@KoboUser.RSS](https://forum.getodk.org/u/KoboUser.RSS)\ **Post date:** [December 15, 2012, 6:22pm UTC](https://forum.getodk.org/t/exporting-metadata/1800/3 "2012-12-15T18:22:58Z")
Im running v1.2.0. Is that the latest? If not, how do i update? > **···** > > On Wednesday, November 28, 2012 10:57:09 PM UTC-5, rsklar wrote: \> \> Hi group, \> \> I would like to separate my exported data based on time they were \> submitted to aggregate. Can someone tell me how to include the metadata in \> exports from aggregate to excel? \> \> Thanks! \> \> Rachel \> ---
**Author:** ![Mitch\_S](https://getodk.b-cdn.net/letter_avatar_proxy/v4/letter/m/3ec8ea/32.png) [@Mitch\_S](https://forum.getodk.org/u/Mitch_S)\ **Post date:** [December 17, 2012, 5:22pm UTC](https://forum.getodk.org/t/exporting-metadata/1800/4 "2012-12-17T17:22:56Z")
1.2 is the latest version; the steps I outlined should therefore work. The latest software is available at [http://code.google.com/p/opendatakit/downloads/list](http://code.google.com/p/opendatakit/downloads/list) See the release notes under the wiki tab for the upgrade steps for that software. Mitch > **···** > > On Sat, Dec 15, 2012 at 10:22 AM, rsklar wrote: > > > Im running v1.2.0. Is that the latest? If not, how do i update? > > > > On Wednesday, November 28, 2012 10:57:09 PM UTC-5, rsklar wrote: > > > > > Hi group, > > > > > > I would like to separate my exported data based on time they were > > > submitted to aggregate. Can someone tell me how to include the metadata in > > > exports from aggregate to excel? > > > > > > Thanks! > > > > > > Rachel > > > > -- > > Post: [opendatakit@googlegroups.com](mailto:opendatakit@googlegroups.com) > > Unsubscribe: [opendatakit+unsubscribe@googlegroups.com](mailto:opendatakit+unsubscribe@googlegroups.com) > > Options: [http://groups.google.com/group/opendatakit?hl=en](http://groups.google.com/group/opendatakit?hl=en) > > -- > Mitch Sundt > Software Engineer > University of Washington > [mitchellsundt@gmail.com](mailto:mitchellsundt@gmail.com)