cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Post Prodigy
Post Prodigy

Get data into a spreadsheet

I am trying to figure out how to read a csv or text file and add that info to a master excel spreadsheet?

 

I'm looking at the connectors but not seeing anything?

 

Terry

2 REPLIES 2
Highlighted
Solution Sage
Solution Sage

Re: Get data into a spreadsheet

Hi Mattw112IG,

First, I want to know where do you store the file.

Here, I have made a flow for your scenario, please check it for a reference.

The file I used came from SharePoint library.

The issue is you only can store the file content  in one cell.

10.png

If you want to store the text file (CSV)content in different cells  in Excel, I afraid that there is no way to achieve your needs in Microsoft Flow currently.

There is a similar idea would like to get rows from a text file (CSV) submitted as link below:

https://powerusers.microsoft.com/t5/Flow-Ideas/Text-CSV-file-get-rows/idi-p/19494

 

Best Regaeds,

Zhongys

Highlighted
Post Prodigy
Post Prodigy

Re: Get data into a spreadsheet

Thanks!

 

Unfortunately I need it to be broken into columns.

 

The thing that is frustrating, is reading and parsing text seems to be such a basic basic thing that Flow should have had fromt he begining...

 

For me I can put the text into any format (Except Excel) txt, csv, xml, ...

 

Then my tableau team wants me to add the lines to a master excel spreadsheet for reporting.

 

Thanks,

Terry

Helpful resources

Announcements
firstImage

Super User Program Update

Three Super User rank tiers have been launched!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

Join the new Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Top Kudoed Authors
Users online (7,233)