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. 

On Windows

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. 

On Mac 

1.) Go to New (⌘ N)
2.) Once your blank workbook comes up, go to File, Import. 
3.) From the 3 options, choose CSV 
4.) Find your original file location (probably downloads) and click Import

5.) 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).  

6.) Verify that the data looks correct in the resulting table underneath. Click Next/Finish 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 ...

• How Do I Run a Report from a Mechanic Task?

  For some of the more keen-eyed users of Mechanic, you may have noticed that we recently published a task last week using the Report Toaster special action. This task is designed to help you take a report out of Report Toaster and export it via email ...

• 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 ...