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
- beginner~7 minFree
Import a semicolon-separated stock file (hardware)
Read a CSV that uses semicolons, promote headers and set number types.
- beginner~6 minFree
Import a CSV whose descriptions contain commas (hardware)
Some item descriptions contain commas and quote marks. Import the file so each description stays in one column.
- beginner~5 minFree
Turn a JSON list of accounts into a table (saas)
A JSON file holds a list of flat account records. Convert it to a table with one row per account.
- beginner~6 minFree
Load the named table from an Excel workbook (kite shop)
The workbook has a notes sheet, a printed sales sheet and a proper Excel table. Load the table.