Topic Options
#57663 - 09/04/20 03:21 PM Convert xls data file to csv
Sami786 Offline
OL Expert

Registered: 01/29/14
Posts: 396
Loc: Home
Hi,
Is there any script to convert an xls file to csv format?
Client sending xls files only!

thanks
_________________________
Peace

Top
#57664 - 09/08/20 08:26 AM Re: Convert xls data file to csv [Re: Sami786]
jim3108 Online   content
OL Expert

Registered: 04/19/10
Posts: 314
Loc: London, UK
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.

Top
#57803 - 12/11/20 09:50 AM Re: Convert xls data file to csv [Re: Sami786]
Sami786 Offline
OL Expert

Registered: 01/29/14
Posts: 396
Loc: Home
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!
_________________________
Peace

Top