Convert XLS to CSV

[wavp]

Maybe someone could point me in the right direction:

What I am trying to do is convert a XLS file to CSV by the press of a button, how would I go about doing this?

Cheers

Will

 

[FoFa]

If you are not using automation, you would need to either Link to the spreadsheet, or import the spreadsheet. Then you can use transfertext to create a CSV file.

 

[xlstocsv]

Maybe someone could point me in the right direction:

What I am trying to do is convert a XLS file to CSV by the press of a button, how would I go about doing this?

Cheers

Will

If you would like to convert XLS to CSV files in a press of a button please visit:

http://www.xlstocsv.com

All the information you need to know can be found there, and you can visit that link and learn how to convert XLS to CSV files.

Best regards.

 

[boblarson]

If you would like to convert XLS to CSV files in a press of a button please visit:

http://www.xlstocsv.com

All the information you need to know can be found there, and you can visit that link and learn how to convert XLS to CSV files.

Best regards.

That is NOT in the press of a button.

 

[xlstocsv]

That is NOT in the press of a button.

Yes it is!

 

[boblarson]

Yes it is!

No, it isn't. That requires you to MANUALLY open the file, Click on the SAVE AS, and then manually select it and then click on save.

 

[gemma-the-husky]

surely if you HAVE an xls, then you have looked at it in Excel - so why not save it as a csv from Excel.

having said that - it isnt so easy to change an xls into a csv - an xls file can contain many features that can't be represented in a csv. how would you resolve this?

 

[xlstocsv]

surely if you HAVE an xls, then you have looked at it in Excel - so why not save it as a csv from Excel.

having said that - it isnt so easy to change an xls into a csv - an xls file can contain many features that can't be represented in a csv. how would you resolve this?

Simple.
First of all, excel is not the only player in the market as many other people choose to use OpenOffice, and not all people are tech oriented as you are, meaning a lot of people for example get an ODS file (OpenOffice) and try to open it in their email and can't open it because they only use excel AND VICE VERSA.
The same applies to CSV files which a lot of In-House programs are using on a daily basis. This is exactly why a lot of people would find this information useful as it doesn't require them to download any extra software and all they have to do to learn how to convert is to simply type ODS TO XLS or CSV TO XLS etc... in order to learn how to make the conversion.

As to CSV not saving every feature from excel it is due to CSV being much inferior to XLS and this is the natural limitation of the format. Still, a lot of people would choose to use it to bring their data into 3rd party programs which support only CSV.

 

[ghudson]

That is NOT in the press of a button.

Yes it is!

I counted 4 clicks if I allowed the file to be saved to the default location.

xlstocsv, the OP wants a VBA routine to convert the xls to a CSV file [hence the "press of a button" phrase].

 

[vbaInet]

Certainly a couple of clicks there, definitely not ONE. Unless I can't count

 

[xlstocsv]

I counted 4 clicks if I allowed the file to be saved to the default location.

xlstocsv, the OP wants a VBA routine to convert the xls to a CSV file [hence the "press of a button" phrase].

I thought the OP was simply looking for an easy way of converting, I didn't think he is referring to a one click solution, I mean literally one click.

I don't think you can convert file to another in 1 click, even if you would have some sort of a magic software installed on your computer, you would still have to 1) Right click on the file 2) Use your magic software to convert which makes it two clicks, minimum.

Not trying to be picky or fussy or anything, but what's the big deal between one or four clicks?

 

[vbaInet]

I thought the OP was simply looking for an easy way of converting, I didn't think he is referring to a one click solution, I mean literally one click.

That was the point Bob was trying to make. Nothing to do with your solution

Not trying to be picky or fussy or anything, but what's the big deal between one or four clicks?

It's an old thread (2005), I'm sure the OP has come to this resolution.

 

[ghudson]

It's an old thread (2005), I'm sure the OP has come to this resolution.

Dang, I fell for that trap again!

Why do people respond to threads that have not been touched in years?

 

[vbaInet]

Dang, I fell for that trap again!

Why do people respond to threads that have not been touched in years?

He's new so he probably didn't notice the date on the thread.

 

[boblarson]

Dang, I fell for that trap again!

Why do people respond to threads that have not been touched in years?

And even more questionable is why is their username the same as the question posed by the OP? It is a bit odd to say the least.

 

[ghudson]

And even more questionable is why is their username the same as the question posed by the OP? It is a bit odd to say the least.

Good catch, I bet he owns that site. It only has 156 hits but it is add free.

 

[boblarson]

Good catch, I bet he owns that site. But it is add free.

Or it is one of our recently banned members having a play.

 

[vbaInet]

Keep an eye out for rtftopdf or doctopdf or csvtoxls, the possibilities are endless.