ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do i convert excel to csv in command line? ( not save as) (https://www.excelbanter.com/excel-discussion-misc-queries/28601-how-do-i-convert-excel-csv-command-line-not-save.html)

F1

How do i convert excel to csv in command line? ( not save as)
 

I am trying to automate a system which needs the files in csv format.

Is there any way to convert excel to csv in command line, instead of the
usual 'save as'?

PS: If you know any UNIX utilities too, please mention.


Earl Kiosterud

F1,

No way I can think of from the command line. You could write an Excel macro
that controls the whole process. Open a file, save as csv, close, next
file, loop.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"F1" wrote in message
...

I am trying to automate a system which needs the files in csv format.

Is there any way to convert excel to csv in command line, instead of the
usual 'save as'?

PS: If you know any UNIX utilities too, please mention.





All times are GMT +1. The time now is 02:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com