Skip to main content

Notifications

Power Automate - Building Flows
Unanswered

Reading or Converting CSV Files

(0) ShareShare
ReportReport
Posted on by 6
Hi all,
 
I have with the help from community members created a flow which cleans up data in different worksheets on a spreadsheet in sharepoint and then imports a fresh set of data from an excel file uploaded to sharepoint onto one of the worksheets on that spreadsheet. At the time I was manually converting the spreadsheet with the fresh set of data from a CSV file to an XLSX file and then uploading the file to sharepoint. Is it possible using power automate and scripts to convert the CSV file to XLXS and then have my flow run? I have tried and not had much luck.
 
Thanks in Advance.  
  • AlexEncodian Profile Picture
    AlexEncodian 4,302 on at
    Reading or Converting CSV Files
    Understood - someone else may have a workaround.
     
    FYI - Encodian is a "Standard" connector on the Power Platform. But it is indeed 3rd party.
     
     
  • AC-16121504-0 Profile Picture
    AC-16121504-0 6 on at
    Reading or Converting CSV Files
    Hi, 
     
    Thank you for the quick response. I was wondering if there is a way to do this without using non standard premium connectors in power automate.
  • AlexEncodian Profile Picture
    AlexEncodian 4,302 on at
    Reading or Converting CSV Files
    @AC-16121504-0

    One way is the Encodian connector suite (specifically the Excel connector in this instance: Convert - Excel – Encodian Customer Help)

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,445

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,741

Leaderboard