Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default Excel spreadsheet file format.


Hi,

All OK thanks --- didn't realize - had to scroll down for .CSV format ...
Thanks

for your help.

Regards,

sm



"Jacob Skaria" wrote:

You mean .CSV

(From http://excel.tips.net/Pages/T002483_..._CSV_File.html)

1.Choose Save As from the File menu. (If you are using Excel 2007, click the
Office button and choose Save As.) Excel displays the Save As dialog box.
2.In the Save As Type drop-down list at the bottom of the dialog box, choose
the CSV (Comma delimited) option.
3.Use the other controls in the dialog box to specify a file name and
location.
4.Click on Save.
5.Excel may display a dialog box telling you that not all Excel features can
be maintained in the format you have chosen. Click on Yes to continue saving
the information in CSV format.
At this point your worksheet is saved in CSV format. I generally find it a
good idea to close the workbook, without saving. At this point you will have
your original Excel workbook (in Excel format) and the CSV file, which
contains the information you wanted in CSV format.


If this post helps click Yes
---------------
Jacob Skaria


"skylux" wrote:

hi.

i have downloaded data in the .xls format. i would like to convert this data
in to .cvs format. is there a function in excel-xp or a utility which can do
this transformation of data?

regards,

sm

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
Number Format on Excel File saved from .html file joyfulone Excel Discussion (Misc queries) 3 April 15th 09 12:07 AM
File encrypted in Excel format. How to decrypt the file? Chuck Excel Discussion (Misc queries) 5 April 3rd 09 04:37 PM
Convert Excel spreadsheet to Ascii file format carley465 Excel Discussion (Misc queries) 2 December 5th 06 06:38 PM
Excel Form Format to Spreadsheet Format Karen Excel Discussion (Misc queries) 4 October 23rd 06 06:03 PM
How do I autosave a unique Excel file in the file format 03F67000 flyboy06 Setting up and Configuration of Excel 1 June 14th 06 11:11 PM


All times are GMT +1. The time now is 12:59 PM.

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"