When working with a .csv file in Excel, special characters can be corrupted when you open the file.
For example '≥65°C' will appear as 'â‰¥65Â°C'.
In order to update update the text values in the .csv file ready for importing we recommend using alternative software. Our recommendation would be to use Google Sheets to do this.
When you download the .csv file from the platform it will appear in your local downloads folder.
Without opening the file upload the file to Google Sheets. Once you have made the changes that you need to, save the file and then download the file back to your machine again.
The updated file will then appear in your downloads folder ready for you to import to your App.
Note: Once the file has been opened from your downloads folder this will convert the special characters and you will not be able to edit the original text in Google Sheets or import the updated values using thefile.
Please sign in to leave a comment.