How to force excel to open CSV file in UTF-8 Format with Flow

(0) Share

Report

Posted on by dalacarelia_196

648

Hello how is it possible to force Excel onpen CSV in UTF-8 Format

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (0)

manuelstgomes 6,625 on at

Like (0)

Report

HI @dalacarelia_196

Am I right to assume that you're talking about the Power Automate desktop?

Cheers
Manuel

------------------------------------------------------------------
If I have answered your question, please mark it as "Accept as Solution." It will help other members finding the solution faster. If you like my response, please give it a Thumbs Up. ?
Otherwise, reply to it, and the community will do its best to help you.

Was this reply helpful? Yes No
dalacarelia_196 648 on at

Like (0)

Report

Sorry yes with Power Automate

Was this reply helpful? Yes No
manuelstgomes 6,625 on at

Like (0)

Report

Hi @dalacarelia_196

I don't think there's a way to do it, but you can automate the process of opening Excel, import data, etc. I found this tutorial that explains the buttons to press, so you can try to do it in PAD:

https://www.itg.ias.edu/content/how-import-csv-file-uses-utf-8-character-encoding-0

To be honest, I'm not a bit PAD expert, so probably someone else here has an excellent workaround for this.

Cheers
Manuel

------------------------------------------------------------------
If I have answered your question, please mark it as "Accept as Solution." It will help other members finding the solution faster. If you like my response, please give it a Thumbs Up. ?
Otherwise, reply to it, and the community will do its best to help you.

Was this reply helpful? Yes No
8i5i8 3 on at

Like (0)

Report

That article refers to excel 2007 so not especially helpful.
Did you get a solution to this issue? It seems the default read file from onedrive task assume csv are ansi text rather than utf-8, which causes issues with accents and other special characters.

Was this reply helpful? Yes No