web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... How to handle line bre...

Small and medium business | Business Central, N...

Answered

How to handle line breaks in text field during export?

(1) Share

Report

Report

Posted on by BD-25111452-0

4

Hi,

I have a table in BC with multi line text fields. When displaying the field on a page, line breaks are displayed normally. But now I would like to export the data for use in Excel. When I create the Query and use the Odata connection in Excel, the text is shown as a single line of text.

I am new to BC and AL so I was hoping somebody could give pointers on how to get the data to Excel including the line breaks.

Thank you in advance.

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

YUN ZHU 99,090 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi, Hopefully the following content can give you some hints.

Dynamics 365 Business Central: How to set multi-line text for a Blob Data Type field via AL

https://yzhums.com/38800/

Thanks

ZHU

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1

OussamaSabbouh 1,993 Super User 2026 Season 1

#2

YUN ZHU 1,116 Super User 2026 Season 1

#3

Khushbu Rajvi. 557 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans