cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sk824a Frequent Visitor
Frequent Visitor

Pulling .xlsx from Sharepoint and converting it to CSV in python script

I'm trying to pull an .xlsx file from Sharepoint and convert it to CSV in python by running a script. After the file would get converted to CSV, I have a script written to perform some data cleanup. After that, I may have to convert it back to a .xlsx for my subsequent data cleanup steps executed in PowerBI not Python. Can someone advise?

1 REPLY 1
Highlighted
Stachu Super Contributor
Super Contributor

Re: Pulling .xlsx from Sharepoint and converting it to CSV in python script

cannot help with the pyton code, but why bother with the conversion? why not pulling XLSX to PowerBI directly and doing all the data cleanup there?

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Top Kudoed Authors
Users Online
Currently online: 290 members 2,977 guests
Please welcome our newest community members: