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

• Fixing Formatting for Google Sheets

  Sometimes, customers download Report Toaster reports to CSV with the intention of uploading them to Google Sheets. This guide will help you troubleshoot some common formatting issues when importing this data. Start from a Blank Spreadsheet and Import ...

• Whats New? - September 2024

  Autumn is here, and with the start of the busy holiday season we can showcase some incredible new reports. Let's take a look! ABC Inventory Report Thanks to the recent development of formula fields in Report Toaster (essentially a special calculated ...

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