Set UTF-8 Encoding for Excel Power Query CSV Imports
Question details
Set UTF-8 as the character encoding for CSV files imported through Excel Power Query.

- Product
- Microsoft Excel 2016 Power Query
- Device & OS
- not provided
- Scenario
- An organization wants CSV imports through Get & Transform to use UTF-8, preferably with a reusable approach for deployment.
- Observed behavior
- Power Query imports CSV files using code page 1252, and registry settings for the legacy text import wizard do not change the newer import interface.
Confirm that the CSV files are actually encoded as UTF-8 and identify the Power Query queries that import them. The legacy text import wizard's registry settings do not control Get & Transform imports.
Set UTF-8 in the Power Query Advanced Editor
Use this method to correct an individual CSV query by explicitly specifying its encoding.
In Excel, open the workbook and use Data > Queries & Connections to open the CSV query for editing. The query list label may vary by Excel 2016 update.
In Power Query Editor, select Home > Advanced Editor and find the Csv.Document call in the Source step.
In the Csv.Document options record, change Encoding=1252 to Encoding=65001, or add Encoding=65001 if it is absent. For example: Csv.Document(File.Contents("C:\\Data\\file.csv"), [Delimiter=",", Encoding=65001, QuoteStyle=QuoteStyle.Csv]). Keep any other options your query needs.
Select Done, check that accented and other non-ASCII characters appear correctly in the preview, then select Home > Close & Load.

Create a reusable UTF-8 CSV import function
Use a shared Power Query function to apply the same encoding to multiple CSV queries.
Work with CSV files in WPS Spreadsheet
WPS Office is a free, lightweight alternative with a familiar interface and Microsoft Office format compatibility for easier migration. WPS Spreadsheet can open CSV files, but it does not change Microsoft Excel Power Query settings.

Frequently Asked Questions
What encoding number represents UTF-8 in Power Query?
Use Encoding=65001 in the options record of the Csv.Document call. Open the query in Power Query Editor and select Home > Advanced Editor to edit it.
Can I change every Power Query CSV import with a registry setting?
Power Query does not provide a simple registry-based global default for CSV encoding. Registry settings for the legacy text import wizard do not control Get & Transform imports.
Why do accented characters still look wrong after I select UTF-8?
Check that the source file is actually saved as UTF-8 and that the query's Csv.Document call specifies Encoding=65001. Review the preview in Power Query Editor before selecting Close & Load.
Can a reusable function automatically change existing queries?
No. Add the function to the workbook or query template, then update each relevant query to call it. Existing queries continue to use their own source steps until changed.




