Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

power query, load to Excel as table... without Column headers!! ??

im trying to automate a report, i made subtables in PQ but I do not want to load the headers, 


is there a way i can do a "load to" without bringing in column headers?

Community Support
Community Support

Hi @mts 


I don't think so. Based on my test, if demoting column headers to the first row and removing the first row in Power Query Editor, after loading to Excel, it still has a column header row having column names like "Column1", "Column2", "Column3"... The column headers cannot be excluded when loading. 


In addition, based on my test, the column headers cannot be deleted or cleared the contents after loading to Excel. It only supports to hide the whole row. 


Hope this helps. 


Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

Solution Sage
Solution Sage

Not sure what your data looks like but one way would be to not promote headers but just remove the first row of data.



Microsoft Employee

Helpful resources

Join Arun Ulag at MPPC23

Join Arun Ulag at MPPC23

Get a sneak peek into this year's Power Platform Conference Keynote.

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Top Solution Authors
Top Kudoed Authors