Troubleshooting reports

Junk characters appear in my Excel output

Problem: When I open my report in Excel, junk characters appear.

Reason: When you open a report generated in CSV format in Excel, junk characters can appear due to the conversion.

Solution: Open the report's Excel file > next to Data in the top menu, click the From Text/CSV button > select the CSV file and click the Import button > choose Unicode (UTF-8) > click Load.