Unanswered

Convert exvel to CSV UTF-8

(1) Share

Report

Posted on by masaustin

Hello everyone,

I just create a flow to convert current excel value to csv file and it works, but I need it to be output in CSV UTF-8 format, is there any way it can be done??

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (0)

Ed Gonzales 4,531 Most Valuable Professional on at

Like (1)

Report
@masaustin

Hi there. I found a couple of options that might work depending on your comfort level and access:

It looks like we might be able to use Python to encode the csv to UTF-8, which means we can call an Azure Function to run that (maybe)...I'm not a dev, just putting together some things I've seen.

I also found a similar solution using PowerShell -

Get-Content .\test.txt | Set-Content -Encoding utf8 test-utf8.txt

Since you can do the conversion in Excel, also, this might be a good opportunity for a UI Flow. You'd need it to run on a local machine, but it's a solution.

Let us know what you think of those. Maybe there are some other ideas floating around.

-Ed

If you liked this reply, please give it a thumbs up! If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.

Was this reply helpful? Yes No
chanwulee 165 on at

Like (2)

Report

If your .csv file shows broken characters instead of Chinese, it is because the encoded file does not include BOM for UTF-8. So, please add 3 BOM characters as below. It will show the text normally in excel.

concat(uriComponentToString('%EF%BB%BF'),body('Create_CSV_table'))

Was this reply helpful? Yes No
masaustin 33 on at

Like (0)

Report

Thanks for your reply, but after I add the 3 BOM characters, it still can't output correctly, seems nothing change in the contents.

Was this reply helpful? Yes No
fawadSid 2 on at

Like (0)

Report

@masaustin any update on this?

Was this reply helpful? Yes No