Power Query Problems

Set UTF-8 Encoding for Excel Power Query CSV Imports

Phi Hung VoPhi Hung Vo Nov 14, 2026 868 views

Question details

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

Set UTF-8 Encoding for Excel Power Query CSV Imports
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.
Before you start

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.

Solution 1Recommended

Set UTF-8 in the Power Query Advanced Editor

Use this method to correct an individual CSV query by explicitly specifying its encoding.

1
Open the query

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.

2
Open Advanced Editor

In Power Query Editor, select Home > Advanced Editor and find the Csv.Document call in the Source step.

3
Specify UTF-8

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.

4
Apply and check

Select Done, check that accented and other non-ASCII characters appear correctly in the preview, then select Home > Close & Load.

Set UTF-8 in the Power Query Advanced Editor
Scope of the change: The encoding setting applies to this query. It does not establish a global Power Query default for new CSV imports.
Free Microsoft Office alternative

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.

Open and review CSV data in WPS SpreadsheetCompatible with Microsoft Excel XLS and XLSX formatsFamiliar spreadsheet interface for an easier transitionFree and lightweight office suite
microsoft office alternative - wps office

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.