How to scrape/extract SharePoint aspx page into excel

[Pondlife]

As per the title, I'm looking for a way to extract the text from a sharepoint aspx sitepage and dump it into excel. Can't seem to get webquery in excel to work as it's complaining about authorisations despite me being an owner/editor on the SP site.

Any ideas?

Constraints include it being a client laptop so I'm not able to install python or any new software although I can run Powershell.

TIA

Pondy

[GregRickshaw]

I thought Excel had a native connector to SharePoint.

Check how Excel is authenticating you (default browser should be ticked or it will try to do it via IE)

[northernladuk]

CTRL A, CTRL C, CTRL V?

Im not very technical like. HTH

[Lance]

if it's a SharePoint list there is a native extract to CSV file.
If it's any other type of SharePoint page why do you want it in Excel anyway? What are you trying to achieve?

[Pondlife]

if it's a SharePoint list there is a native extract to CSV file.
If it's any other type of SharePoint page why do you want it in Excel anyway? What are you trying to achieve?

I have a sharepoint list of items and one if the columns in this list is a URL to a sp site page containing some text about the item - definition, usage, varying bits of textual info (formated based on a template used to create the sitepage).

I want to extract that text in some automated way into excel, so I can link it to an extract of the main item list as an extra column. I can do the manipulation once it's in excel - I just want to know how I can get it there without NLads ^C^V method given there are hundreds of items in the list

[_V_]

I'm no Excel expert, but seems there are two main approaches, one is the Excel web query and the other is using VBA code.

https://www.wikihow.com/Import-Web-D...l-on-PC-or-Mac

https://www.guru99.com/data-scraping-vba.html

No idea if this helps. Personally I avoid Excel in any kind of automated solution as much as possible.

[Lance]

I have a sharepoint list of items and one if the columns in this list is a URL to a sp site page containing some text about the item - definition, usage, varying bits of textual info (formated based on a template used to create the sitepage).

I want to extract that text in some automated way into excel, so I can link it to an extract of the main item list as an extra column. I can do the manipulation once it's in excel - I just want to know how I can get it there without NLads ^C^V method given there are hundreds of items in the list

like this?

Export to Excel from SharePoint or Lists (microsoft.com)