[mso] Re: Excel no commas in CSV file
- From: "Greg Chapman" <greg@xxxxxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Mon, 9 Sep 2002 10:24:41 -0500
A true CSV file has each value enclosed in double quotes and then each
of those fields should be separated with a comma.
Here's the output I get after telling Excel that each cell is to be
formatted as a number and to use the comma as a thousands separator and
to show values to two decimal places followed by saving to a CSV format:
"11,000.00",,,
"2,000.00","3,000.00","4,000.00","50,000.00"
"6,000,000.00","700,000.00",,
"8,000,000,000.00",,,
If I view the output pasted into notepad (or just look in the clipboard
directly), though, I get this:
11,000.00
2,000.00 3,000.00 4,000.00 50,000.00
6,000,000.00 700,000.00
8,000,000,000.00
This is because Excel only saves the actual CSV file using the CSV
rules. Copied data does not have the separator formatting applied.
Go ahead and save the CSV file rather than copying and pasting. Then
open the file in a text editor (and try to avoid using notepad; it
breaks several rules about straight text presentation). I think you'll
see that Excel XP will save the file in accordance with CSV formatting
guidelines.
Greg Chapman
http://www.mousetrax.com
"Counting in binary is as easy as 01, 10, 11!
With thinking this clear, is coding really a good idea?"
> -----Original Message-----
> From: mso-bounce@xxxxxxxxxxxxx
> [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf Of Lilies In Bloom
> Sent: Monday, September 09, 2002 6:22 AM
> To: mso@xxxxxxxxxxxxx
> Subject: [mso] Excel no commas in CSV file
>
>
> I think I have a problem:- no comma separators in an Excel
> 2002 file 9 (on Win XP) that I save as .csv (tried all options)
> I need these or other separators to import the file into
> another program.(i.e. when I paste data from the spreadsheet
> into Notepad no commas are visible)
> I have changed the options in "International Settings" to
> give a space for 1000's separator but still no luck?
>
> Gordon Hampson
> Lilies In Bloom
> Takaka, New Zealand
> info@xxxxxxxxxxx
>
> photos, info. & ordering- visit www.bloom.co.nz
>
>
>
>
>
> *************************************************************
> You are receiving this mail because you subscribed to
> mso@xxxxxxxxxxxxx or MicrosoftOffice@xxxxxxxxxxxxxxxx
>
> To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
>
> To Unsubscribe from this group, send an email to
> mso-request@xxxxxxxxxxxxx?Subject=unsubscribe
>
> Or, visit the group's homepage and use the dropdown menu.
> This will also allow you to change your email settings to
> digest or vacation (no mail). //www.freelists.org/webpage/mso
>
> To be able to use the files section for sharing files with
> the group, send a request to mso-moderators@xxxxxxxxxxxxx and
> you will be sent an invitation with instructions. Once you
> are a member of the files group, you can go here to
> upload/download files: http://www.smartgroups.com/vault/msofiles
> *************************************************************
>
>
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx?Subject=unsubscribe
Or, visit the group's homepage and use the dropdown menu. This will also allow
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with
instructions. Once you are a member of the files group, you can go here to
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
Other related posts:
