Issue:
I have exported a file from Monsido, but special letters are being replaced with symbols such as commas, and this causes some of the data to land in the wrong column.
Answer:
Monsido Excel exports are created in a format that allows special characters, but this must be selected at the time of import.
Export: Click the Export button on the upper right side of the window.
Select: Select your export file. A dialog box opens, chose the file to export.
A dialog box opens: "Your export is currently being generated. You will receive an email when the export is ready. To see the current progress, click the user avatar on the upper right-hand side of the main page and select My Export. Alternatively, click the button below."
Click Go to My Export, in the dialog box.
The My Exports window opens.
On the same row as the export, click Download.
The file downloads to the local machine, normally to the downloads folder.
Open Excel and click File --> Import.
An Import dialog opens. Select CSF file type and then click Import.
Browse to Downloads and select the file. Click Get Data.
The Import Wizard dialog opens.
Select:
Delimiters: Choose the one that your document uses to separate the data:
semicolon
commas.
File Origin: UTF-8: This ensures that special letters appear normally and that data is placed in the correct column in the Excel sheet.
Click Finish.
Choose the existing sheet.
Click Import.
Note: If you do not have Excel, you can also convert the data with Google Sheets.