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
    Posts
  • #31416
    mgason
    Participant

    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?
    Thanks

    #31417
    mgason
    Participant

    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
    import

    #31428
    Michael Visser
    Keymaster

    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.