View original (French)

Converting an Excel file to CSV without opening it

marieg58 Posted messages 25 Status Membre -  
 marieg58 -
Hello,
I would like to know if it is possible to convert an Excel file to CSV without opening it.
Every week I receive 4 XLS files that I need to convert to CSV before concatenating them.
I have to open each file and save it in CSV format. I wanted to know if there is a faster way.
Thank you in advance.

1 réponse

Réponse 1 / 1
Patrice33740 Posted messages 8400 Registration date   Status Membre Last intervention   1 781
 
Hello,

Without opening them, you can use Power Query to import and concatenate the 4 files in Excel, to export the result.

Best regards
Patrice

No one can hold all the knowledge, that’s why we share it.
0
marieg58
 
Hello,
Thank you for your reply, but I don't have power query. Is there another solution?
Thank you.
0