Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 3
Default 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   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 9
Default 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   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 8,520
Default 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   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 3
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel not converting file Tim Excel Worksheet Functions 11 October 28th 08 02:37 PM
Converting an Excel File to CSV Jane New Users to Excel 0 August 17th 07 02:09 AM
Converting an Excel File to CSV JLatham New Users to Excel 0 August 17th 07 01:56 AM
Converting Excel file to text delimited file Kiran Veeramallu[_2_] Excel Discussion (Misc queries) 3 May 1st 07 07:04 PM
Converting excel file to tab delimited (txt) file Kusuma Excel Discussion (Misc queries) 1 December 18th 06 08:04 AM


All times are GMT +1. The time now is 09:42 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"