Arabic characters not displayed correctly in data download

Problem:

Free text responses are shown correctly when viewing them on the data section of the platform. However, when you download the data as CSV, and then open a CSV file by double-clicking it or using "File -> Open" in Excel, Arabic characters may not display correctly. This happens because Excel doesn't automatically select the correct character encoding (e.g., UTF-8).

Solution:
You need to import the CSV file using Excel's CSV import wizard to specify the correct character encoding.

Step-by-Step Instructions:

1. Open Excel: Start Excel without directly opening the CSV file.
2. Go to the "Data" tab: In the top menu bar, click on the "Data" tab.
3. Import From Text/CSV: In the Data tab, select "Get Data" or "From Text/CSV." This will open a wizard that helps you import the file properly.
4. Select the CSV file: Navigate to your CSV file and select it. Click on "Import."
5. File Preview in the Wizard: The wizard will show a preview of the data. Check if the Arabic characters are displayed correctly.
6. Select Character Encoding (File Origin):  If the characters are not displayed correctly, choose the "65001: Unicode (UTF-8)" option from the "File Origin" dropdown menu. This will ensure the Arabic characters are recognized properly.
7. Set Data Format (optional): If necessary, you can also adjust the data format for specific columns.
8. Finish the Import: Click "Load" to import the data into Excel.

Now, the Arabic characters should display correctly!