web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Add header in a text f...
Power Automate
Answered

Add header in a text file and turn it into xlsx

(0) ShareShare
ReportReport
Posted on by 45

Hi there, i have this txt file without header.

Z_BI_0-1652104476785.png

I would like to add an header like that : 

SITE, NR, DESC, DATE, HOUR

and put all the content in a excel file .xlsx

I prefer to do this in Power Automate Cloud not Desktop

Please help me

thank you very much

Categories:
I have the same question (0)
  • Verified answer
    takolota1 Profile Picture
    4,974 Moderator on at

    Hello @Z_BI 

     

    Is this something you have to routinely do, or is it a one-time task?

     

    You could create an XLSX file with a table and input your desired headings, then use a Get CSV or CSV Parser template to fill in that XLSX table with the CSV values: https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/CSV-to-Dataset/td-p/1508191

     

    And if this is a routine thing, you could just keep an unfilled template file with your headers in SharePoint or Onedrive & have the flow make a copy of that template file to fill each time this runs.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 503 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 321 Moderator

#3
abm abm Profile Picture

abm abm 237 Most Valuable Professional

Last 30 days Overall leaderboard