Data Encoding (CSV)

Owned by Steven Revill, created
Last updated: Mar 19, 2021 by Katy Aird
1 min read

You are best to save your csv as a UTF-8 encoded version of csv in order to ensure that all symbols etc are picked up properly here. The most recent versions of workbooks enable data to be saved in this format if not already in that format. An example of doing that in Excel is shown here:

This for example allows the euro symbol “€” to be included within the API rather than some encoding types which replace the € symbol with something else. This can lead to a loss in quality of the data as it is less interpretable.