Converting a CSV file to an Excel file

G

Gordon Biggar

When I export a file from a website to an Excel file (on a Windows 2000
platform), it shows up in Excel as a standard Excel spreadsheet (I am using
Office 2000). However, when I export the same file on a Vista platform, it
shows up in Excel as a comma-delimited file. How do I convert a CSV file
into an Excel spreadsheet?

Thanks in advance for any thoughts.

Gordon Biggar
Houston, Texas
 
S

Susan Ramlet

I usually open it in Excel and then do a "File, Save As" and select Excel
format.
 
J

Jacob Skaria

Open using File|Open and SaveAs .xls

If you are looking at opening the .csv file from Explorer on a click then
register the file type within Win Explorer Tools|FolderOptions|FileTypes tab

If this post helps click Yes
 
G

Gordon Biggar

When I saved as a Microsoft Excel workbook, or as an Excel worksheet, I
ended up with exactly what I started with (a CVS file).

By experimenting, however, I saved the file first as a tab delimited text
file, and then read that in to Excel and had the Excel Wizard convert the
file from a comma-delimited file to a .xls file. It worked, but it seems
like a very cumbersome way to get to the end point!

Maybe my procedure was at fault?

Gordon
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top