0

I am working on an ADF pipeline to export a CSV file from a Snowflake table. The table contains some fields with special characters (i.e. French language characters)

If I look at the CSV output in notepad, it looks perfect.

However, when opening in Excel, it is not showing the characters correctly.(ex: "é" appears as "é")

If I change the encoding in Notepad to UTF-8-BOM, then Excel opens it correctly as expected. It also shows as expected if I import the data into Excel using the "Get Data" feature.

I do not see an option in ADF under encoding to set it to UTF-8-BOM, only UTF-8 or UTF-8 without BOM.

enter image description here

My question is basically this: How can I export the file to CSV format in such a way that the special characters will show correctly when a typical end user tries to open the CSV file in Excel?

Below is an example of how the file is currently configured.

enter image description here

Improve this question

2 Answers 2

Reset to default
0

I tried the similar thing in my environment and got same result when I downloaded the copied blob in excel it's not Showing Special Characters in Excel. you can see below:

enter image description here

To achieve your goal, you need to specify the encoding as UTF-8 in sink dataset.

enter image description here

After this when I copied the blob and open the CSV file in Excel it Is showing Special Characters appropriate format.

enter image description here

Improve this answer
Sign up to request clarification or add additional context in comments.

2 Comments

As shown in the screenshot I shared, the encoding is set to UTF-8. If I use the "Get Data" feature of excel and import as UTF-8, everything appears correctly. Are there any sort of settings in Excel or Windows needed to make it recognize UTF-8 by default?
yes there is setting in excel where you can ser defult encoding
0

In the Integration Dataset for "DelimitedText" file you could configure de following Encoding property:

Encoding: ISO-8859-1

This will solve the issue

Improve this answer

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.