How do you create a multi-column fixed select list using a local file from a computer?

Fixed select lists can be imported as files from a local computer. This can be achieved with the use of text or UTF8-coded CSV files that utilize semicolon as the field delimiter.

Excel uses the default list separator configured in Windows, which is also language-dependent. An English Windows system uses the comma separator while other languages such as German or French use the semicolon as the default separator. If you store a CSV with Excel in an English Windows system, we must first change the separator to semicolon (Windows 10: Control Panel > Clock, Region, and Language > Region > Formats > Additional settings > List separator). Otherwise, the import of more than one column will not work.

KBA applicable for both Cloud and On-premise Organizations.