https://legacy.forums.gravityhelp.com/topic/export-entries-check-box-values-in-wrong-columns Gravity Support Forums Topic: Export Entries - Check box values in wrong columns en-US Mon, 20 Apr 2026 06:51:58 +0000 http://bbpress.org/?v=1.0.1 q https://legacy.forums.gravityhelp.com/search.php https://legacy.forums.gravityhelp.com/topic/export-entries-check-box-values-in-wrong-columns#post-65072 Fri, 06 Jul 2012 15:28:12 +0000 Chris Hajer 65072@https://legacy.forums.gravityhelp.com/ <p>Amy, I just realized you sorted the spreadsheet, so my date range may not be correct. Is there a span of entries where the columns do not line up, then after that point all is well again? </p> https://legacy.forums.gravityhelp.com/topic/export-entries-check-box-values-in-wrong-columns#post-65066 Fri, 06 Jul 2012 14:48:20 +0000 Chris Hajer 65066@https://legacy.forums.gravityhelp.com/ <p>Hi Amy, I emailed you but wanted to post here as well. Because the entries with data that did not line up were from the beginning of the file through April 17, and none after, it looks to me like the form was modified and a checkbox choice was either added or removed. That would cause the current entries to line up properly but would throw off any earlier entries since the number of items per entry (in the CSV) would be wrong. Let me know if you can confirm that. Thanks. </p> https://legacy.forums.gravityhelp.com/topic/export-entries-check-box-values-in-wrong-columns#post-63880 Thu, 28 Jun 2012 06:39:16 +0000 Chris Hajer 63880@https://legacy.forums.gravityhelp.com/ <p>Please email a sample export to <a href="mailto:chris@rocketgenius.com">chris@rocketgenius.com</a> and I will take a look. Be sure to let me know what the expected result is and where the error exists. Thanks </p> https://legacy.forums.gravityhelp.com/topic/export-entries-check-box-values-in-wrong-columns#post-63862 Wed, 27 Jun 2012 22:59:57 +0000 LitSuppGuru 63862@https://legacy.forums.gravityhelp.com/ <p>I have used the export feature in Gravity Forms to export all entries. When I pull it into Excel, the data is slightly inaccurate.</p> <p>One of the fields I have on the form is a check box field with about 30 choices. The user can select one or more items. At first glance, it looks like Gravity Forms parses the items into separate columns in the export, so there is a column for each of the 30 choices. The choices happen to be cities in which we have a chapter in our organization.</p> <p>However, the issue is when I filter on the Philadelphia column for instance, I should get all entries where someone chose Philadelphia. What I've noticed though is that for some entries that have the value Philadelphia, the value is in the wrong column (it is in the Orange County column to the left instead).</p> <p>Why would the item choice land in the wrong column in the export? How can I correct this without digging into the SQL tables?</p> <p>If you need a sample of the export file, let me know.</p> <p>Thanks.<br /> Amy </p>