Finance | Project Operations, Human Resources, ...

Export CSV from D365 F&O with UTF-8 BOM and Double Quote Text Qualifier

(1) Share

Report

Posted on by RJ-22061207-0

Hi everyone,

I have a requirement to export certain entities from Dynamics 365 Finance & Operations in CSV format, with the following specifications:

Encoding: UTF-8 with BOM (Byte Order Mark)

Text Qualifier: Double quotes (") around all fields

Escaping: Any embedded double quotes within a field should be escaped by doubling them ("")

This is needed to ensure fields don’t split into separate columns during processing by an external system (Esker integration).

Question:

Can D365 F&O export files in this exact format directly via the Data Management framework, or is post-processing required to meet these specifications?

Appreciate any insights or best practices you’ve used for similar scenarios.

Thanks in advance!

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Navneeth Nagrajan 2,438 Super User 2025 Season 2 on at

Like (1)

Report

Hi RJ-22061207-0,

You can use the standard csv file format for exporting certain entities.

It should address the requirements:

1. Text qualifier with " around all the fields is possible with CSV-Unicode.

2. UTF-8 with byte encode characters is possible with CSV-unicode as your file format.

You can use the standard CSV-Unicode: Comma seperated (Unicode) as the source data format while exporting the entity.

However, for escape sequences (""), you will require X++ code for handling double quote "" characters.

Hope this helps. Happy to answer questions, if any.

Was this reply helpful? Yes No
Anton Venter 20,346 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

Does it have to be UTF-8 with BOM? I don't see standard support for that. If it is required, you will need an extra customization step to create a UTF-8 with BOM file and copy the data to the new file.

Was this reply helpful? Yes No
Suggested answer

Navneeth Nagrajan 2,438 Super User 2025 Season 2 on at

Like (0)

Report

Hi RJ-22061207-0,

Alternatively, you can consider using Electronic reporting because ER has the ability to identify UTF-8 with byte order marks. Used this in one of the reports in the past to generate data in UTF-8 mode with BOM.

Also, check for flight DMFDisableDoubleByteCharacterExport, based on your requirement if you are planning to use Data management framework to address this requirement.

Hope this helps. Happy to answer questions, if any.

References:
https://learn.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/analytics/er-suppress-bom-characters

Was this reply helpful? Yes No

Join the conversation

Community site session details

Export CSV from D365 F&O with UTF-8 BOM and Double Quote Text Qualifier

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

Export CSV from D365 F&O with UTF-8 BOM and Double Quote Text Qualifier

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates