Hi @AriWeissman -
Thank you for your question.
If we understand correctly, it concerns the new CSV (comma separated value) text based reports now available in DQM.
Fortunately, there's an easy way to make Excel display special characters properly.
When you open a CSV report in Excel, default settings may cause accented and non-Latin characters to display incorrectly. There are workarounds to make Excel display them as intended.
Example: โฆ improve your systemรขโฌโขs productivity and efficiency
Method 1 - Open the CSV file in Notepad and save a copy with UTF-8 encoding
If you are using Windows, the Notepad text editor can save the file with a marker to indicate that it contains special characters. This will make recent versions of Excel open it correctly. To do this, start Notepad and open the CSV file. The open Notepadโs File menu and choose โSave Asโ. At the bottom of the Save As dialog box, thereโs a drop down chooser to change the fileโs encoding. Click the chooser and select โUTF-8โ, then click โSaveโ.
When you open the CSV file in Excel, accented or special characters should be displayed correctly.
Please note โ this adds a marker at the start of the CSV file. Although it is recognised by many applications and works with Excel, not all applications are guaranteed to understand it.
Method 2 โ Change the encoding when opening the CSV file in Excel
When you open comma separated CSV file in Excel, it may not present the text import wizard, where you can specify file encoding and delimiter options.
In a blank workbook, open Excelโs Data ribbon and click โGet Dataโ at the left of the toolbar.
From the drop-down menu, choose โFrom Fileโ >> โFrom Text/CSVโ.
This opens a file chooser. Select the CSV file and click โImportโ to open the import wizard:
When the import wizard appears, open the โFile originโ drop-down chooser at the top left and select the following entry:
65001: Unicode (UTF-8)
The delimiter should default to โCommaโ.
After UTF-8 encoding has been chosen, click โLoadโ to bring the data into Excel.
