Conversion from Excel to csv, what to watch for?

Power Query
1

Hi there,

I’ve heard that csv files are more efficient than Excel files (xlsx) and just on the surface, it seems to make sense.

What are some of the issues I need to look out for when converting all my Excel source files (xlsx) into csv files in an existing report? Also, which csv option would work best csv or csv UT-8?

2

Hi @powerbideveloper

I found the following:

i hope this helps
If it does, please mark solved on my message.

thanks
Keith