CSV files encoded in utf-8-bom (Excel default) can't be read by plugin

[ltalve]

Csv file exported from Excel with utf-8 encoding is "utf-8-bom" by default. It seems these files can't be used in the csv reader of the DigitransitGeocoding plugin without errors (see below). However, when files are converted to "utf-8" (without bom) in Notepad++, the csv file is read as expected by the plugin.

Steps to reproduce the behavior:

1. Save a csv file in Excel with "CSV UTF-8" (either by Export or by Save as, both give the same result)
2. In QGIS go to Toolbox - Digitransit.fi geocoding plugin - Geocode - Geocode addresses in a CSV file
3. Select the saved CSV file and give the needed information (the used separator and column names in a list (different files with different separators have been tested)) => click Run
4. Log gives error: "Prosessointiin syötteenä antamasi kentän nimeä ei ole CSV-tiedoston otsikkokentän nimenä." (field name not found in title row of csv)

Desktop:

• Plugin: QGISDigitransitGeocoding-master 0.7.2
• QGIS 3.28.4
• OS: Win11

[JuhoErvasti]

@ltalve Would you still happen to have the csv file in question / could you produce a similar file? I can't reproduce the issue on my end.