# Split data

**URL:** <https://forum.dimagi.com/t/split-data/2637>\
**Category:** Users\
**Created:** [March 9, 2016, 2:47pm UTC](https://forum.dimagi.com/t/split-data/2637 "2016-03-09T14:47:38Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Goal\_Malawi](https://dimagi.b-cdn.net/letter_avatar_proxy/v4/letter/g/ad7895/32.png) [@Goal\_Malawi](https://forum.dimagi.com/u/Goal_Malawi)\
**Post date:** [March 9, 2016, 2:47pm UTC](https://forum.dimagi.com/t/split-data/2637/1 "2016-03-09T14:47:38Z")

</div>

Hi all,

I have a question that requires multiple answers but wen I export to excel,  
the answers come in one cell. When I click on the split multiple answers in  
commcare and export, its only showing the question and the word extra at  
the end without showing the answers.

Please help how I would export the splited cells to excel and that it  
should show the answers.

Thanks.

---

<div class="post-metadata">

**Author:** ![Robin\_Selwitz](https://dimagi.b-cdn.net/letter_avatar_proxy/v4/letter/r/e9a140/32.png) [@Robin\_Selwitz](https://forum.dimagi.com/u/Robin_Selwitz)\
**Post date:** [March 14, 2016, 10:49pm UTC](https://forum.dimagi.com/t/split-data/2637/2 "2016-03-14T22:49:15Z")

</div>

Hello,  
In order for us to look into this would you be able to report an issue form  
your CommCare HQ page?  
Thanks very much,

Robin Selwitz

> **···**
>
> On Wednesday, March 9, 2016 at 9:47:38 AM UTC-5, Goal Malawi wrote: \> \> Hi all, \> \> I have a question that requires multiple answers but wen I export to \> excel, the answers come in one cell. When I click on the split multiple \> answers in commcare and export, its only showing the question and the word \> extra at the end without showing the answers. \> \> Please help how I would export the splited cells to excel and that it \> should show the answers. \> \> Thanks. \>