Read Raw Excel Data (unformatted xlsx) using Power Automate - Excel File to SharePoint List

Learn how to read data from unformatted Excel files using ‪@MicrosoftPowerAutomate‬ & Office scripts (‪@mspowerplatform‬).
Enable office scripts for your organization: docs.microsoft.com/en-us/micr....
Check out this video ( • Convert CSV Files to E... ) if your source file is in CSV format instead of XLSX.
Office script used in this video:
powergi.net/resources/Office%...
Got questions? We can help! Contact us at [e-mail]

[@ahmedbenyahia6853]

Thank you so much, this has supported me a lot😃

[@largenegrir4719]

This is the best thing I’ve seen all day

[@PowerGI]

Thanks for your comment! It made the day!

[@jamesmosier111]

to get dynamic range area - let newTable = workbook.addTable(selectedSheet.getUsedRange(), true)

[@timfruit]

This was incredibly helpful. Thank you!

[@ludovicfuzellier6834]

still very useful, thank you !

[@deeptech3556]

Wow, Thanks very much, You are life saver. I was struggling with this the whole day.

[@HardikShah17]

Wow! You saved my entire days work.

[@HardikShah17]

Hi, I tried this but I am getting too many issues. I have an email that comes in daily with almost a similar format as yours and there are no tables there. I tried making a script that worked fine in Excel. I get like one transaction in the excel everyday and sometimes its null too. I want the transaction to move to a sharepoint list. Using your method, I understood the script part but I get an error saying: "message": "We were unable to run the script. Please try again. Office JS error: Line 5: Workbook addTable: A table can't overlap another table." Do you have any tips for this?

[@jkunkoski4173]

I guess my only critique would be what happens if your range is variable. I notice the range is set and if you have less rows than the range, the same range is still brought in. It would be nice to be able to account for that. Looking that up now but not having much luck. Thanks for the video

[@adyelencu]

Amazing video! Helped us with a simple and elegant automation. We do have a question, though: what if I don't know the number of rows my file will have? I can set it to a high number, but then it will run into a loop and try creating blanks. It still does the trick, just not very elegant. Got a suggestion?

[@marcosnunes1701]

Great video thanks! I had a small issue on line 5 when trying to rename my table. When running the script manually on excel it was working perfectly. When the script was triggered by my work flow, my table was not getting renamed on excel, meaning there was no results on my workflow output. To solve it I decided to rename my excel table in a new line and it worked: let newTable = workbook.addTable(selectedSheet.getRange("A1:F10"),true); newtable.setName("mytable");

[@ugandhar115]

is it possible to format all the sheets in a book and update table name with sheet name?

[@ion669]

Awesome video and very well explained i wish you had a channel of your own, is confusing some videos are in spanish and others in english.

[@dcpowered]

Thanks a lot! Please post more videos on Power Automate! P.S. please use a better mic.

[@PowerGI]

hi Shakeel, thanks so much for your comment ! Also thank you for the feedback! we're definitely trying to improve so we will see how we can improve audio! Thank you again

[@2007pradipta]

do I need to write script for each individual files ? its impossible if the files are generated dynamically. Is there any we can attach the Script to dynamic files ?

[@user-dh4cf2sq6k]

The link for the code is not working

[@user-dh4cf2sq6k]

Please upload it

[@PowerGI]

thanks for letting me know and sorry about the trouble! should be good now!