AnsweredAssumed Answered

Can I split a list of multiple choice answers in the Excel output?

Question asked by zcooley_mfcgis on Apr 25, 2019
Latest reply on Jun 30, 2020 by afabrizi

I've exported the results of a recent survey as a FGDB, then converted the table to an Excel spreadsheet. Once I opened the spreadsheet I noticed that the answers for the two multiple choice questions were all in the same field, but separated by commas. In the Survey123 Results page, the totals for each answer is tallied up in the bar chart, but I can't replicate this with the Excel format. Is there a way to split these answers in Excel? That probably sounds confusing, but hopefully my screenshots will help.




Question in the Survey:

Results in the Excel Spreadsheet:


Results on the Survey123 Results page: