MX CSV Import-Export Forum :: excel to csv - how to?

This thread was displayed: 3,146 times

Starting with 17th May 2007, Adobe Systems will stop offering support for any version of the discontinued InterAKT products. As a result, we will not answer to new support incidents starting with May 17th, 2007. Pending support incidents will still be followed in order to be closed. The product forums will remain open and be transformed in user-to-user forums. The general forums will be made read-only and not allow new posts or comments.

For more information about the affected products visit: www.interaktonline.com/Support/


View All View Non Threaded Newest first
  • 05-29-2006 10:04:13 GMT +2 ashok saini

    Hi,

    I am trying to save excel as csv, but after I open and see what's saved, I see the same structure as in excel, i.e. data is rows and colomns (same as in excel).

    How to save it as csv so that I get comma separators and quotes around data?

    I even tried to make excel of data in tutorial and save as csv, got the same problem. So, what I am missing? How to save as csv correctly?

    Thanks

    • 05-29-2006 12:28:58 GMT +2 Cristian IVASCU [InteraktOnline]Adobe Systems Romania staff

      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.

      Regards,
      Cristian

      • 07-25-2006 12:06:43 GMT +2 AAAA BBBB
        I edited a CSV file in Excel a... View more

        I edited a CSV file in Excel and after saving it (as CSV) it has a different structure and is not compatible with the first. For example , the values are between 2 pairs of " instead of one pair. How can I converse it into a working CSV? I tried open it with uniCSVed or CSVed but it gives me error, or says the first row is empty, or something. By the way, is a 7MB file.


        Any suggestion?

        • 08-04-2006 09:38:03 GMT +2 Cristian IVASCU [InteraktOnline]Adobe Systems Romania staff
          Hi, The CSV file is no long... View more

          Hi,

          The CSV file is no longer recognised by the page because the enclosing has bveen changed. What you can do is create another page using MX CSV Import-Export set to use the double " as enclosing separators and import the data into a temporary table. Then use a regular export to recreate the csv file with the single " signs.

          Regards,
          Cristian

          • 09-17-2006 05:28:02 GMT +2 Yvonne Lew
            I have the same problem. I can... View more

            I have the same problem. I can save excel file to csv and set option to use double quotes as text qualifier. When I open in notepad, there's no double quotes around text. Someone from another forum wrote that excel does not force double quotes unless there's a comma in the text. Do you know how I can force double quotes around text? I need to solve this problem urgetly. Thanks.

             

            • 09-18-2006 09:40:30 GMT +2 Cristian IVASCU [InteraktOnline]Adobe Systems Romania staff
              Hi Yvonna, I believe you ca... View more

              Hi Yvonna,

              I believe you can enforce this when saving as CSV by setting the options. You should check out Excel's help for this information though.

              Regards,
              Cristian
Forums
MX CSV Import-Export 1.8.6
© Adobe Systems Romania. All rights reserved.