Convert xls data file to csv

Posted by: Sami786

Convert xls data file to csv - 09/04/20 03:21 PM

Hi,
Is there any script to convert an xls file to csv format?
Client sending xls files only!

thanks
Posted by: jim3108

Re: Convert xls data file to csv - 09/08/20 08:26 AM

You could use a Run Script to open the file in Excel in the background and save as a CSV.

Let me know if you need help doing this.

Regards,

James.
Posted by: Sami786

Re: Convert xls data file to csv - 12/11/20 09:50 AM

Hi Jim, Yes please send me the scrip to open file in Excel and then save it as CSV format, and also let me know if there's a way to save each tab separately. The other option is to use ODBC Excel Files driver!