Results 1 to 4 of 4

Thread: Export Excel 2003 sheet in csv Format

  1. #1
    Join Date
    Feb 2009
    Posts
    26

    Export Excel 2003 sheet in csv Format

    Hello everyone,

    i Have Small Query Regarding Excel Export Funtion , I want to Ask whether it is possible to export an excel sheet in csv. and particularly what I would like is can we export (create) a document csv on which we are working . Infact in this document of excel sheet, i Have 2 Sheet Which i would like to tranform in Csv. format Please Help Solve These Thank in Advance

  2. #2
    Join Date
    Apr 2008
    Posts
    4,088

    Re: Export Excel 2003 sheet in csv Format

    Hello,

    I might not be very constructive in that first comment but ... I understood nothing. Otherwise: yes we can "save as" CSV. We must save each sheet separately by "save as" or you will overwrite your CSV each time by the data from different sheets. Each file created by a backup in CSV, Excel opened by only a single sheet. If you leave a document to XLS format with multiple sheets and you save a CSV, XLS original document will not be affected.


    ThoMas321

  3. #3
    Join Date
    Sep 2005
    Posts
    1,306

    Re: Export Excel 2003 sheet in csv Format

    Excel is an application that produces and uses CSV. A particular aspect of how Excel uses CSV has become a considerable source of confusion and uncertanty. Excel will always remove leading zeros from fields before displaying them. It will also always remove leading spaces. It insists on helping you, even if removing these leading zeros will, for example, cause your numerically keyed records to sort out of order.

  4. #4
    Join Date
    May 2008
    Posts
    4,831

    Re: Export Excel 2003 sheet in csv Format

    Hello , In order to save an Excel sheet as CSV file simply select the Save As option from the menu and select the CSV(comma delimited) format. To test the CSV file open it with Notepad or another text editor, and not Excel. Excel will recognize the CSV format and display the file with proper formatting - e.g. rows and columns.

Similar Threads

  1. Excel .xlsm format export from Access 2007
    By foraman in forum Windows Software
    Replies: 4
    Last Post: 26-11-2010, 02:02 AM
  2. EXCEL export to tekst or sheet
    By Ingmar1979 in forum Windows Software
    Replies: 1
    Last Post: 29-06-2009, 07:33 PM
  3. How to export a Project 2003 file into Excel 2003
    By destinyswarrior in forum Windows Software
    Replies: 3
    Last Post: 21-03-2009, 05:15 PM
  4. How to Export a table from a PDF File into an Excel Sheet
    By Computer_Freak in forum Tips & Tweaks
    Replies: 1
    Last Post: 05-02-2009, 10:21 AM
  5. Want to Export Access to Excel 2003
    By Darsheet in forum Windows Software
    Replies: 4
    Last Post: 08-01-2009, 03:10 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,638,479,306.90634 seconds with 17 queries