Fixing Characters in CSV/Excel

Fixing 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

    • 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 ...
    • 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 ...
    • Intro Tutorial Guide (Video)

      This Report Toaster video tutorial explains the basics of using Report Toaster! ​​ This video covers things like:  - Searching for a Report - Changing the Date Range on a Report - Adding/Removing Columns, Changing the Display Order  - Filtering a ...
    • Why Aren't My Reports Matching Shopify? - Part 2

      As covered in our previous article, so long as you're looking at comparable data, our reports should generally match the exact information that is presented in Shopify.  However, one situation where a known discrepancy can occur is when you look at ...
    • What's New? - June 2022

      Summer is here, and with it comes a scorching hot new feature in Report Toaster. Calculated Fields are here!  ("Yes, finally!" I hear some of you saying. Quite literally in fact - a few of you even emailed to tell us!) Not only has this been one of ...

     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.