Fixing Special Characters in CSV/Excel

Fixing Special Characters in CSV/Excel

Often, non-English characters display correctly in Report Toaster but can become garbled when exporting the data to CSV/Excel.

You may notice this problem when you open up the excel file and the non-English text appears to be garbled or poorly formatted. This is a known issue with Microsoft Excel (see this article), but thankfully, the solution is a quick fix. 

1.) Open up a blank excel file (or simply open up Microsoft Excel and start a blank workbook). 
2.) Go to the data tab, click 'From Text/CSV". 
3.) Browse to your original file location (probably downloads) and click Import. 
4.) A window should pop up that looks something like this. As you can see you have several options for selecting the File Origin text type and Delimiter (typically, we found UTF-8 and Comma work best, but feel free to adjust as needed).  

5.) Verify that the data looks correct in the resulting table underneath. Click Load and you should be good to go. 

For more information about using Report Toaster, check out our FAQ or reach out to us at any time :)
    • Related Articles

    • Fixing ZIP Codes and Missing 0's in CSV/Excel

      Often, certain fields (like ZIP Codes) display correctly in Report Toaster but do not export correctly to CSV/Excel. You may notice this problem when you open up the Excel file the field displays without the first 0s. This happens because Excel tries ...
    • How Do I Export/Print a Report?

      Another entry in our 'Basics' series, this article will cover all your options for exporting a report in Report Toaster. For instance, say I wanted to save a copy of this report to my desktop? Or get a version of the data to excel so I can add ...
    • What's New? - January 2022

      Happy New Year! And with a big splash at New Year comes another big announcement - our integration with Mechanic!  Let's take a look :) What is Mechanic?  As they explain in their app listing, "Mechanic is a development and Ecommerce workflow ...
    • Export and Download (Video)

      This Report Toaster video tutorial explains the Export and Download features. This video covers things like:  - Downloading a Report (PDF, JSON, CSV) - Download History - Re-Downloading a previous Report.  This video is best viewed in full screen ...
    • Why Should I Upgrade My Report Toaster Account?

      One of the most common questions we get from Free Plan users of Report Toaster is of course - why should I upgrade to the Paid Plan? Well, let's break it down: The Free Plan of Report Toaster is the standard default plan for Shopify and Shopify Basic ...

     Suggestion Box

    Didn't find what you were looking for in our knowledge base? Click here to suggest an article, and we'll try to put something together for you.