List index out of range when turning CSV into dict

[perfringo]

CSV UTF-8 (Comma delimited) (.csv)

Its saved as CSV (comma delimited), not UTF - 8

My up-to-date Excel under macOS has this exact option to save as csv. There are other options as well (Comma Separated Values (.csv), Macintosh Comma Separated (.csv), MS-DOS Comma Separated (.csv)) but this one should be preferred as 'universal encoding'. However, regardless of saved encoding separator must be present anyway.

For those of us who use Mac and have ; as separator:

For Mac OS the chosen value separator depends on Region and region's default number separators. To change them, go to “System Preferences” > “Language & Region”. Then you need to verify the number separators in “Advanced …” > “General”.

Here are the rules Excel uses to determine how it saves CSV files:

1. If your language / region / locale uses comma (,) for decimal separation then Excel will save using semi-colons (;)
2. If it uses a dot (.) full stop or period, then it will delimit with commas (,).