Power QueryExercises

Delimiter

The character that separates fields in a text file, typically a comma, semicolon or tab.

When the delimiter also appears inside values, those values must be quoted in the file, and the import must respect quotes. European exports often use semicolons because the comma is the decimal separator. Choosing the wrong delimiter puts every field in a single column.

In the Power Query editor

The CSV import dialog's Delimiter list, or the Delimiter option of Csv.Document.

Learn more

Practise it

Related terms