If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|