Encoding
How characters are stored as bytes in a file. UTF-8 (code page 65001) is the usual choice; the wrong encoding garbles accented letters.
Files saved by older software may use Windows-1252 or another code page; reading them as UTF-8 turns accented letters into symbols like é. The import dialog's File Origin setting chooses the encoding, and Csv.Document accepts it as an option, so the choice is saved in the query.
In the Power Query editor
File Origin in the CSV import dialog, or [Encoding = 65001] in the Csv.Document call.
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.