Promote headers
Turning the first row of a table into its column names, usually right after importing a CSV.
Header promotion should happen once, after banner rows are removed and before columns are referred to by name. Duplicate header names get a numeric suffix. The automatic Changed Type step that follows hard-codes every column name, so review it before relying on the query.
In the Power Query editor
Home → Use First Row as Headers, or Table.PromoteHeaders in the formula bar.
Learn more
Related functions
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.