Import – Export problem – format problem

  • Resolved andreip23

    (@andreip23)


    3 years, 9 months ago

    Hello! I have a problem with import – export funcion.

    So the problem starts when I export the products from the website. Excel (or another app) can’t open the csv format as it should (in columns) https://ibb.co/yftC0fc. As you can see, the description went on the first column, not after the commas.

    If i open it manually from excel, it opens how it should (Data, From Text/CSV). https://ibb.co/b7ZMLkc.

    Now, the file is an xmls and i have to save it as a CSV. When importing, it creates more empty products and does nothing with the one that should be edited (edited by sku and id activated).

    So what should I do now? Is it a problem from WooCommerce or from Excel? How can i solve this?

    Thank you!

    Solved! Topic closed!

    • This topic was modified 3 years, 9 months ago by andreip23.
    • This topic was modified 3 years, 9 months ago by andreip23.
Viewing 2 replies - 1 through 2 (of 2 total)

  • Hello,

    I’d suggest to open your file in Google spreadsheet instead of Excel – Google usually can handle CSV files correctly.

    • Export your products into CSV again
    • Upload the file to Google Sheets
    • Select the option to “detect” automatically the format.
    • Edit the file and download it back as CSV.
    • Upload it to your store (I’d suggest creating a staging site if you’d like to try first)

    I hope that helps.

    Hi @andreip23

    We’ve not heard back from you in a while, so I’m marking this thread as resolved. If you have further questions, please feel free to open a new topic.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Import – Export problem – format problem’ is closed to new replies.