Exporting columns from Excel Sharepoint to desktop excel

[course1]

I need to export just certian columns from a very large excel sharepoint that is online from only one tab is there a way to automate this. It clearly wont let me copy and paste due to the size how would I go about doing this thank you!

 

[RoryA]

Do you mean a sharepoint list, or an Excel workbook stored in sharepoint? (Power Query can handle either one)

 

[course1]

Excel workbook in sharepoint sorry there is a place on top to automate and write a script I am assuming thats where it will come from just dont know what the script would be

 

[RoryA]

I'd query it from Excel. That way if the contents of the sharepoint workbook change, you can simply refresh the query to pull in updated data.

 

[course1]

Do you have any like example on how to start with that sorry I usually only use excel for basic exports I am more of a SQL writer and then straight into power bi or tableau not alot of manipluation with excel in my background it would be really helpful!

 

[RoryA]

Power Query in Excel is the same as the one in Power BI. You need the URL for the workbook in sharepoint, then connect to that, and just extract whatever columns you want. Does that make sense?

 

[course1]

Yup! that actually does I really appreciate the help