Excel: Importing and displaying CSV data

Some examples that demonstrate how CSV data can be imported or displayed are

Miscellaneous notes

The separator of imported CSV files might be set under additional settings of intl.cpl by changing the value of List separator

In the CSV file itself, the separator can be specified with sep=…:

sep=,
"SRC","ABSCHL_PER","WJ"…
"foo","28.02.2021","2021"…
"bar","31.03.2021","2021"…

It is also possible to import CSV data using the menu Data -> Get External Data -> From Text

CSV data might also be imported with Power Query M formula standard library functions such as Power Query M formula: Csv.Document.