How to convert Excel to ASCII file?

Discussion in 'Microsoft Excel Discussion' started by CJN, Jan 6, 2004.

  1. CJN

    CJN Guest

    I have a large Excel file with many columns and rows. I need to
    convert it to an ASCII file that has each file separated by commas and
    with each field surrounded by double quotation marks.

    Can anyone guide me as to how to do this?

    Many thanks,
     
    CJN, Jan 6, 2004
    #1
    1. Advertisements

  2. CJN,

    You can save the file (File - Save As) specifying csv or txt as the file
    type ("Save as type" at bottom of dialog). Neither, as far as I know, will
    put quote marks around all fields -- only those with a field delimiter
    (comma) or text qualifier (quote marks) in the actual data. Quote marks
    around all fields aren't normally needed. If they are, try the Text Write
    Program at www.tushar-mehta.com.
    --
    Earl Kiosterud
    mvpearl omitthisword at verizon period net
    -------------------------------------------

    "CJN" <> wrote in message
    news:...
    > I have a large Excel file with many columns and rows. I need to
    > convert it to an ASCII file that has each file separated by commas and
    > with each field surrounded by double quotation marks.
    >
    > Can anyone guide me as to how to do this?
    >
    > Many thanks,
     
    Earl Kiosterud, Jan 6, 2004
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Goran Stjepanovic

    Excel 2000 and Importing huge ASCII files

    Goran Stjepanovic, Feb 25, 2004, in forum: Microsoft Excel Discussion
    Replies:
    1
    Views:
    304
    Bernie Deitrick
    Feb 25, 2004
  2. tmb

    VBA to export Fixed Len ASCII from Excel ?

    tmb, Mar 23, 2005, in forum: Microsoft Excel Discussion
    Replies:
    1
    Views:
    791
    JE McGimpsey
    Mar 23, 2005
  3. Scott Sanford

    Convert ASCII to Hex

    Scott Sanford, Apr 26, 2005, in forum: Microsoft Excel Discussion
    Replies:
    3
    Views:
    2,918
    Ron Rosenfeld
    Apr 26, 2005
  4. How to convert xls to plain ascii text.

    , Jun 8, 2005, in forum: Microsoft Excel Discussion
    Replies:
    1
    Views:
    588
    Earl Kiosterud
    Jun 8, 2005
  5. Replies:
    0
    Views:
    312
  6. tankgirl215

    preparing for an ascii file

    tankgirl215, Jun 12, 2006, in forum: Microsoft Excel Discussion
    Replies:
    7
    Views:
    280
    Dave Peterson
    Jun 12, 2006
  7. DK

    ASCII text file import more than 65536 entries

    DK, Sep 7, 2006, in forum: Microsoft Excel Discussion
    Replies:
    5
    Views:
    282
  8. Martin C

    How to convert a binary encoded xls file back into ascii

    Martin C, Sep 22, 2008, in forum: Microsoft Excel Discussion
    Replies:
    1
    Views:
    726
    Jim Rech
    Sep 22, 2008
Loading...