# Publishing all data (even in loops) to one sheet **URL:** \ **Category:** Support\ **Created:** [August 17, 2023, 6:18pm UTC](https://forum.getodk.org/t/publishing-all-data-even-in-loops-to-one-sheet/42708 "2023-08-17T18:18:06Z")\ **Posts on this page:** 1\ **Showing post:** 2
**Author:** ![danbjoseph](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/danbjoseph/32/21901_2.png) [@danbjoseph](https://forum.getodk.org/u/danbjoseph)\ **Post date:** [August 18, 2023, 12:07am UTC](https://forum.getodk.org/t/publishing-all-data-even-in-loops-to-one-sheet/42708/2 "2023-08-18T00:07:46Z")
This is the expected behavior. Repeats are a powerful tool but with that power comes a necessary increased complexity in the output data structure. Please see the "Tip" box in the section of the docs on Repeating questions for 2 alternative form design options: [https://docs.getodk.org/form-logic/#repeats](https://docs.getodk.org/form-logic/#repeats) Also, if you have not seen the announcement, please note the upcoming changes to the ODK/ Google Sheets functionality: > [@Collect will stop connecting to Google Drive/Sheets in Fall 2023](https://forum.getodk.org/t/collect-will-stop-connecting-to-google-drive-sheets-in-fall-2023/40097): > > In Fall 2023, we will remove Google Drive/Sheets functionality from ODK Collect. Users will no longer be able to download blank forms directly from Google Drive or send completed forms directly to Google Sheets. We are making this change to enable us to move faster on features that serve more users. We believe most people use Google Drive/Sheets because they see it as reducing the financial and technical cost for organizations to use ODK. But because Google Drive/Sheets were not designed to be… --- _[View the full topic](https://forum.getodk.org/t/publishing-all-data-even-in-loops-to-one-sheet/42708)._