When uploading a CSV into Confirm, you will need to ensure that it has the proper encoding so special characters get represented correctly. Make sure that when you export or save your CSV to save it with UTF-8 with BOM encoding.
Several applications and software tools natively support exporting CSV files with UTF-8 BOM. Here are a few:
Microsoft Excel (Windows):
Excel on Windows allows you to export CSV files with UTF-8 BOM.
Go to
File>Save As.Choose the location to save your file.
In the "Save as type" dropdown, select
CSV UTF-8 (Comma delimited) (*.csv).Click
Save.
LibreOffice Calc:
LibreOffice Calc supports exporting CSV files with UTF-8 BOM.
Go to
File>Save As.Choose
Text CSV (.csv)as the file type.Check the "Edit filter settings" box and click
Save.In the "Export Text File" dialog, ensure the "Character set" is set to
Unicode (UTF-8)and check the "Apply BOM" option.Click
OK.
Google Sheets (with add-ons):
While Google Sheets does not natively support exporting CSV files with UTF-8 BOM, you can use add-ons like Export Sheet Data to achieve this.
Notepad++ (Windows):
Notepad++ can save text files with UTF-8 BOM, which you can use for CSV files.
Open the CSV file in Notepad++.
Go to
Encoding>Encode in UTF-8 BOM.Save the file.
Visual Studio Code:
Visual Studio Code supports saving files with UTF-8 BOM.
Open the CSV file in Visual Studio Code.
Go to
File>Save with Encoding>UTF-8 with BOM.
Text Editors on Mac (with specific settings):
Some text editors on Mac, like Sublime Text, can save files with UTF-8 BOM.
Open the CSV file in Sublime Text.
Go to
File>Save with Encoding>UTF-8 with BOM.
These tools and applications provide straightforward methods to export or save CSV files with UTF-8 BOM.