.CSV files with unicode

Hello,

I have a utility that produces multiple .csv files with sheets.

The problem is the in many rows it displays Gibberish instead of the actual language it suppose to show (non English)

The csv encoding is UTF8.

I've stumbled upon a solution in this link:
https://www.itg.ias.edu/content/how-import-csv-file-uses-utf-8-character-encoding-0

my question is, can I perform this solution in a batch process? cause there are many many csv reports, and i don't want to do it manually one by one.

Thanks!!

Hi,

I'm trying to import.

some of the text in cells is in fact english and some is gibberish. This process fixes it. I wonder if I could fix multiple files at once

You have Excel 2016. Just use PowerQuery to import CSV.

You can marge multiple files into single table. If that's not desired...

Upload sample csv file so that I can test solution.

Thanks

whats your email ill send the file over

Hi, I've sent PM with my email address.