ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Converting a CSV file to an Excel file (https://www.excelbanter.com/new-users-excel/225592-converting-csv-file-excel-file.html)

Gordon Biggar

Converting a CSV file to an Excel file
 
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


Susan Ramlet

Converting a CSV file to an Excel file
 
I usually open it in Excel and then do a "File, Save As" and select Excel
format.

--
Susan Ramlet
**please reply to the newsgroup so others may benefit**


"Gordon Biggar" wrote in message
...
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



Jacob Skaria

Converting a CSV file to an Excel file
 
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
---------------
Jacob Skaria


"Gordon Biggar" wrote:

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



Gordon Biggar

Converting a CSV file to an Excel file
 
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



"Gordon Biggar" wrote in message
...
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




All times are GMT +1. The time now is 08:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com