Home Forums Plugins Store Exporter Deluxe [Resolved] strange characters when csv opened in excel?

Welcome to our community support forums! We're here to help - but if you have an urgent request for a Pro Plugin, you will get a prioritised response through our Premium Support page.

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
  • #31416

    Store Exporter Version 1.5.4
    Store Exporter Deluxe Version 1.2.7
    I am not very familiar with working with csv. When I view my exported customer file in a simple text editor I see
    Valérie Blackburn”,”Valérie”,”Blackburn”,”344 5e avenue”,”Québec
    When I open it in Excel I see incorrect characters…
    Valérie Blackburn Blackburn Valérie 344 5e avenue Québec
    I need to have the files saved as Excel format, what do I need to have the text appear correctly in Excel?


    Close this
    I sorted this out. If anyone else sees this do not open the csv with Excel, import it.

    Simply follow these steps:
    Open Excel
    Import the data using Data–>Get External Data or Data–>Import Data From Text or a similar command based on your version of Excel
    Browse to your downloaded CSV file and select it

    Michael Visser

    Hi magason, I’ve added this to the Usage document for others using accented characters. 🙂

Viewing 3 posts - 1 through 3 (of 3 total)
  • The topic ‘[Resolved] strange characters when csv opened in excel?’ is closed to new replies.