Exporting an Excel file

Before trying an Excel forum, I thought that I would state my question here
first, since it is Vista-related.

When I export a file from a website to an Excel spreadsheet where I am using
a Windows 2000 platform, it is saved as an Excel file. However, when I
export this same file from the same website on a Vista platform, it gets
saved as a CSV file. (I don't have the option of specifying the file format
at the website. The website does ask if one wants to save the file to
Excel.) I am using Office 2000.

What is the method for converting the CSV file to an Excel format?

Thanks in advance for any thoughts.

Gordon Biggar
Houston, Texas

csv files can be loaded directly into excel. It depends on ho
complicated they are as to how they will look

--
roy6

Dont PM people with questions, post them in the forums so others ca
learn.

Excel can open a .csv file directly. Just double-click it and see. If it
does not get opened by Excel directly, right-click on the file and select
"Open With" | "Microsoft Excel" from the menu.

- Chirag

PowerShow - View multiple PowerPoint slide shows simultaneously
http://officeone.mvps.org/powershow/powershow.html

"Gordon Biggar" <> wrote in message
news:OFfxv%...
> Before trying an Excel forum, I thought that I would state my question
> here first, since it is Vista-related.
>
> When I export a file from a website to an Excel spreadsheet where I am
> using a Windows 2000 platform, it is saved as an Excel file. However,
> when I export this same file from the same website on a Vista platform, it
> gets saved as a CSV file. (I don't have the option of specifying the file
> format at the website. The website does ask if one wants to save the file
> to Excel.) I am using Office 2000.
>
> What is the method for converting the CSV file to an Excel format?
>
> Thanks in advance for any thoughts.
>
> Gordon Biggar
> Houston, Texas

I tried this. It opens the file into an Excel spreadsheet, but the numbers
are still displayed within quote marks, and the numbers are still separated
by commas.

GB



"Chirag" <> wrote in message
news:##...
> Excel can open a .csv file directly. Just double-click it and see. If it
> does not get opened by Excel directly, right-click on the file and select
> "Open With" | "Microsoft Excel" from the menu.
>
> - Chirag
>
> PowerShow - View multiple PowerPoint slide shows simultaneously
> http://officeone.mvps.org/powershow/powershow.html
>
> "Gordon Biggar" <> wrote in message
> news:OFfxv%...
>> Before trying an Excel forum, I thought that I would state my question
>> here first, since it is Vista-related.
>>
>> When I export a file from a website to an Excel spreadsheet where I am
>> using a Windows 2000 platform, it is saved as an Excel file. However,
>> when I export this same file from the same website on a Vista platform,
>> it gets saved as a CSV file. (I don't have the option of specifying the
>> file format at the website. The website does ask if one wants to save
>> the file to Excel.) I am using Office 2000.
>>
>> What is the method for converting the CSV file to an Excel format?
>>
>> Thanks in advance for any thoughts.
>>
>> Gordon Biggar
>> Houston, Texas
>

On Thu, 26 Mar 2009 02:28:26 -0500, "Gordon Biggar"
<> wrote:

>I tried this. It opens the file into an Excel spreadsheet, but the numbers
>are still displayed within quote marks, and the numbers are still separated
>by commas.

NOW do you think it's better to ask in an Excel group???

DDW
--
Reply via this group
No email please

On Thu, 26 Mar 2009 02:28:26 -0500, "Gordon Biggar"
<> wrote:

>I tried this. It opens the file into an Excel spreadsheet, but the numbers
>are still displayed within quote marks, and the numbers are still separated
>by commas.
>
>GB

When you open it, go through the text import wizard. Be sure to
specify the proper quote type as the text delimiter and the comma as
the field separator.

Back to your original question: How are you "exporting" from a web
site? Do you have a sample URL and rough instructions? Or is this
something being done on an internal corporate network?