# BumbleBee write to excel preserve line breaks and text format

**URL:** <https://forum.dynamobim.com/t/bumblebee-write-to-excel-preserve-line-breaks-and-text-format/81310>\
**Category:** Revit\
**Tags:** bumblebee, excel, dynamo\
**Created:** [September 21, 2022, 3:28pm UTC](https://forum.dynamobim.com/t/bumblebee-write-to-excel-preserve-line-breaks-and-text-format/81310 "2022-09-21T15:28:01Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![j-meds](https://avatars.discourse-cdn.com/v4/letter/j/eb8c5e/32.png) [@j-meds](https://forum.dynamobim.com/u/j-meds)\
**Post date:** [September 21, 2022, 3:28pm UTC](https://forum.dynamobim.com/t/bumblebee-write-to-excel-preserve-line-breaks-and-text-format/81310/1 "2022-09-21T15:28:01Z")

</div>

Formatting doesn’t seem to be respected using BB excel export. I need to get it looking like the copy/paste version. Would this even be possible with the configs ?

I know I would have to split the text on every line break(\n), from there just insert by column. Tab(\t) would get tricky, I’d rather avoid all this and I’m wondering if there’s something they could do in excel or a config I can use for the export. Thanks in advance!

I believe it does preserve new lines, it just doesn’t follow the same format when copying and pasting.

 ![Screenshot 2022-09-21 074027](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/a/d/ad5169d0d3495a1671827b8d426a09970271d45e.png)

---

<div class="post-metadata">

**Author:** ![Draxl\_Andreas](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/draxl_andreas/32/145744_2.png) [@Draxl\_Andreas](https://forum.dynamobim.com/u/Draxl_Andreas)\
**Post date:** [September 21, 2022, 4:21pm UTC](https://forum.dynamobim.com/t/bumblebee-write-to-excel-preserve-line-breaks-and-text-format/81310/2 "2022-09-21T16:21:42Z")

</div>

@j-meds , hi

i am not sure if this is similar topic… but i had the issue with a ifc-mappingtable…  
to have a placeholder like “#”

KR

Andreas

![grafik](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/4/7/47941215159d18e31ee8566ebdd3df142d7c576f.png)

---

<div class="post-metadata">

**Author:** ![j-meds](https://avatars.discourse-cdn.com/v4/letter/j/eb8c5e/32.png) [@j-meds](https://forum.dynamobim.com/u/j-meds)\
**Post date:** [September 21, 2022, 4:33pm UTC](https://forum.dynamobim.com/t/bumblebee-write-to-excel-preserve-line-breaks-and-text-format/81310/3 "2022-09-21T16:33:02Z")

</div>

Doesn’t seem to be the case as #name was added due to it having the dash(‘-’) which expects a formula. I may need to do a custom solution which adds line breaks on the next row.

---

<div class="post-metadata">

**Author:** ![newshunhk](https://avatars.discourse-cdn.com/v4/letter/n/3bc359/32.png) [@newshunhk](https://forum.dynamobim.com/u/newshunhk)\
**Post date:** [September 22, 2022, 1:44am UTC](https://forum.dynamobim.com/t/bumblebee-write-to-excel-preserve-line-breaks-and-text-format/81310/4 "2022-09-22T01:44:15Z")

</div>

you can copy the python code from bumblebee:  
 ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/1/1/11ba41643bbfab7272d9b8b2115855e8f68be13d.png)

and add one line here:  
 ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/a/1/a1d247021d2457fca3b9d1c59d3f444a84c3c07c.png)