# Export column header mismatch **URL:** \ **Category:** Support\ **Created:** [May 18, 2022, 2:37am UTC](https://forum.avicennaresearch.com/t/export-column-header-mismatch/509 "2022-05-18T02:37:42Z")\ **Posts on this page:** 14\ **Page:** 1
**Author:** ![echo](https://forum.avicennaresearch.com/letter_avatar_proxy/v4/letter/e/c6cbf5/32.png) [@echo](https://forum.avicennaresearch.com/u/echo)\ **Post date:** [May 18, 2022, 2:37am UTC](https://forum.avicennaresearch.com/t/export-column-header-mismatch/509/1 "2022-05-18T02:37:42Z")
Exports from survey have column headers that don’t export correctly leading to column headers mismatched with responses when opened in Excel and Google Docs. Study ID: 2485, Acitivity ID: 15800. ---
**Author:** ![n.a.huizinga](https://forum.avicennaresearch.com/letter_avatar_proxy/v4/letter/n/58956e/32.png) [@n.a.huizinga](https://forum.avicennaresearch.com/u/n.a.huizinga)\ **Post date:** [May 19, 2022, 12:23pm UTC](https://forum.avicennaresearch.com/t/export-column-header-mismatch/509/2 "2022-05-19T12:23:53Z")
I also second this issue. My column headers are messed up when exporting surveys. Study ID: 1480, Activity ID:10941 ---
**Author:** ![faham\_r2222](https://forum.avicennaresearch.com/letter_avatar_proxy/v4/letter/f/85e7bf/32.png) [@faham\_r2222](https://forum.avicennaresearch.com/u/faham_r2222)\ **Post date:** [May 19, 2022, 5:44pm UTC](https://forum.avicennaresearch.com/t/export-column-header-mismatch/509/3 "2022-05-19T17:44:45Z")
Hi @echo @n.a.huizinga, This issue has been resolved a couple of days ago and everything work as expected. Could you please confirm if you generated the export yesterday or today? If yes please send the export ID, otherwise please recreate the export and everything should work as expected. Faham ---
**Author:** ![echo](https://forum.avicennaresearch.com/letter_avatar_proxy/v4/letter/e/c6cbf5/32.png) [@echo](https://forum.avicennaresearch.com/u/echo)\ **Post date:** [May 19, 2022, 6:11pm UTC](https://forum.avicennaresearch.com/t/export-column-header-mismatch/509/4 "2022-05-19T18:11:38Z")
I believe that I exported it on Tuesday. It would have been export ID 5. I tried it again just now (export ID 6) and the headers are still messed up. It has some answers as a header instead of the question. I’m looking at survey responses for 15780 (I had requested multiple). It’s also messed up in survey 15800. ---
**Author:** ![n.a.huizinga](https://forum.avicennaresearch.com/letter_avatar_proxy/v4/letter/n/58956e/32.png) [@n.a.huizinga](https://forum.avicennaresearch.com/u/n.a.huizinga)\ **Post date:** [May 20, 2022, 8:15am UTC](https://forum.avicennaresearch.com/t/export-column-header-mismatch/509/5 "2022-05-20T08:15:18Z")
It still doesn’t work correctly for me either. I tried it again just now and nothing has changed. It’s messed up in survey 10941. And it looks like the issue occurs specifically with questions where the participant can choose multiple answers. ---
**Author:** ![faham\_r2222](https://forum.avicennaresearch.com/letter_avatar_proxy/v4/letter/f/85e7bf/32.png) [@faham\_r2222](https://forum.avicennaresearch.com/u/faham_r2222)\ **Post date:** [May 25, 2022, 4:17pm UTC](https://forum.avicennaresearch.com/t/export-column-header-mismatch/509/6 "2022-05-25T16:17:26Z")
Hi all, we’ve identified the issue and a fix will roll-out in couple of days. Sorry for the delay and thanks for reporting this. Faham ---
**Author:** ![echo](https://forum.avicennaresearch.com/letter_avatar_proxy/v4/letter/e/c6cbf5/32.png) [@echo](https://forum.avicennaresearch.com/u/echo)\ **Post date:** [June 1, 2022, 2:06am UTC](https://forum.avicennaresearch.com/t/export-column-header-mismatch/509/7 "2022-06-01T02:06:50Z")
Hi Faham - this issue still seems to be occurring in the export I made just now (export 12, see Survey 15780 for an example). It seems to happen for answers to a multiple-selection question when a comma was included in an answer. Any update on when this will be fixed? I have work that is pending this fix so if there is anything you can do to get this fix in place it would be greatly appreciated. ---
**Author:** ![faham](https://forum.avicennaresearch.com/letter_avatar_proxy/v4/letter/f/5daacb/32.png) [@faham](https://forum.avicennaresearch.com/u/faham)\ **Post date:** [June 1, 2022, 3:47pm UTC](https://forum.avicennaresearch.com/t/export-column-header-mismatch/509/8 "2022-06-01T15:47:00Z")
Hi @echo, The fix for it is going to roll-out today or tomorrow at the latest. Thanks, Faham ---
**Author:** ![echo](https://forum.avicennaresearch.com/letter_avatar_proxy/v4/letter/e/c6cbf5/32.png) [@echo](https://forum.avicennaresearch.com/u/echo)\ **Post date:** [June 3, 2022, 12:36am UTC](https://forum.avicennaresearch.com/t/export-column-header-mismatch/509/9 "2022-06-03T00:36:37Z")
Hi Faham - the column headers are still messed up. If the fix has rolled out it doesn’t appear to be working. ![image](https://forum.ethicadata.com/uploads/default/original/1X/8f02611d32e32ed9addcbe037e16283366debfd2.png). This was just exported now (Export 15 on Activity 15780). ---
**Author:** ![faham](https://forum.avicennaresearch.com/letter_avatar_proxy/v4/letter/f/5daacb/32.png) [@faham](https://forum.avicennaresearch.com/u/faham)\ **Post date:** [June 3, 2022, 5:23am UTC](https://forum.avicennaresearch.com/t/export-column-header-mismatch/509/10 "2022-06-03T05:23:43Z")
Hi @echo, The fix just got out less than an hour ago. The problem should be resolved. Would you please try again and let us know if still had any issues. Thanks Faham ---
**Author:** ![l.braas](https://forum.avicennaresearch.com/letter_avatar_proxy/v4/letter/l/ebca7d/32.png) [@l.braas](https://forum.avicennaresearch.com/u/l.braas)\ **Post date:** [July 5, 2022, 5:36pm UTC](https://forum.avicennaresearch.com/t/export-column-header-mismatch/509/11 "2022-07-05T17:36:57Z")
Hello, I also have issue in my study (ID: 2406, 2591 and 2593). I have downloaded the data in Ethica and exported the csv files to excel, delimited by comma’s. In general this looks fine (after deleting all the comma’s in the headers manually, so the headers are not splitted like @echo anymore). However, the answers are not matching the headers (at all). Moreover, the mismatching seems to be inconsistent, so I could not find an easy solution. Can you maybe help me? ![Schermafbeelding 2022-07-05 om 19.34.24](https://forum.ethicadata.com/uploads/default/original/1X/ede3984e93c7cd810554ea96e51aa7d0ee76e9ce.png) ---
**Author:** ![faham](https://forum.avicennaresearch.com/letter_avatar_proxy/v4/letter/f/5daacb/32.png) [@faham](https://forum.avicennaresearch.com/u/faham)\ **Post date:** [July 11, 2022, 5:35pm UTC](https://forum.avicennaresearch.com/t/export-column-header-mismatch/509/12 "2022-07-11T17:35:56Z")
Hi @l.braas, You shouldn’t change the headers. MultiAnswerQuestions or MAQs are designed to have one separate column per Answer. This is the official format of the exports now. Please try importing your CSV export to Google Spreadsheet and let us know if there is any issues. Thanks, Faham ---
**Author:** ![l.braas](https://forum.avicennaresearch.com/letter_avatar_proxy/v4/letter/l/ebca7d/32.png) [@l.braas](https://forum.avicennaresearch.com/u/l.braas)\ **Post date:** [July 13, 2022, 9:11am UTC](https://forum.avicennaresearch.com/t/export-column-header-mismatch/509/13 "2022-07-13T09:11:11Z")
Hello @faham, Thank you for your answer. Unfortunately, the document is still not well structured when I open the csv file in google spreadsheets. The headers look fine! But in general, the number of characters in csv file does not fit the number of columns in the sheet. The first ±20 columns look fine, but further! all the rows are shifted to the left. In addition, I noticed mismatches when participants answered the follow-up questions. Our study is divided by 4 topics, each starting with single answer question (yes/no). If they answered yes and were referred to follow-up questions, the mismatch occurs and the row shifts a few cells to the right. If participants answered no, they were directly referred to the next topic. \*picture 1 shows the general mismatch: VAS scale question answered by yes/no \*picture 2 shows the mismatch when participant answered a few follow-up questions. Number questions are answered by yes/no… and a few a shifted to the right I would like to hear from you. Kind regards, Lisan Braas ![Schermafbeelding 2022-07-13 om 11.04.56](https://forum.ethicadata.com/uploads/default/original/1X/4e15f10a4100cf5a177c7bd5cd1e799ee60793a2.png) ![Schermafbeelding 2022-07-13 om 11.08.40](https://forum.ethicadata.com/uploads/default/original/1X/c53fbc060582ed0a1f472fc8843d06aad4a57a63.png) ---
**Author:** ![faham](https://forum.avicennaresearch.com/letter_avatar_proxy/v4/letter/f/5daacb/32.png) [@faham](https://forum.avicennaresearch.com/u/faham)\ **Post date:** [July 14, 2022, 6:29pm UTC](https://forum.avicennaresearch.com/t/export-column-header-mismatch/509/14 "2022-07-14T18:29:00Z")
@l.braas could you please let me know your study ID and export ID? Thanks, Faham