| Discussion / comments |
2007-06-20
Sasikanth Malladi comments
from Woodbridge, NJ : |
THe above trick of resetting the default number separator in Windows to a "|" from a "," doesn't work.
Sashi
|
2005-08-29
robert comments
: |
Changing the list separator in MS EXCEL (2003!) isn't it all. You have to change the decimal symbol too. e.g. set the German (AUSTRIA), customize the list separator from ";" to "," => it won't work. ";" is used. But when you change the decimal symbol to "." and the list separator to "," => then it works ... mysterious .. and don't forget to start MS EXCEL between each change ;-)
|
2005-07-15
Dark Elf comments
from Dark Lands of Moria ;-)
\m/ \m/ : |
Thanks for the tip....!! Searched a lot for this one!! Am surprised that Microsoft does not offer this tip !! But then again Microsoft !!! aaaarggggghh...Excel rocks though!! \m/ \m/
|
2005-07-10
Martin Naranjo comments
: |
Yes, you can set a pipe rather than a comma as a delimiter. It does not depend completely on Excel. It depends on Windows. The quickest way is to save the file as a CSV file.
To change the default on your PC to a pipe rather than a comma bring up your default options window by clicking Start -> Settings -> Control Panel -> Regional Settings.
Click the "Number" tab and in the "List Separator" field, replace the current default separator with the one you want to use (let's say a pipe symbol | ).
Click "OK" to save the change and close the window. You can now save Excel files as pipe delimited files by simply doing the following in Excel:
Open or Create a new file in Excel.
Click File => Save As on the menu bar.
In the "File Type" drop down, select "CSV (comma separated values) *.csv".
|
For mysql addicts, xls2mysql converts xls sheets to mysql queries. Going through mysql can be another way to convert Excel to CSV, which doesn't need an Excel installation as the Excel sheet is in that case interpreted by PHP.
Bookmark
Back to this
