Can we use R to read list data in SharePoint?

Copper Contributor

Can I read the list data from SharePoint into R and convert it into a dataframe for use?

Thank you very much for your answer!

1 Reply

@Xiaohu_Liu 

Yes, you can use R to read list data from SharePoint Online.

You can use the Microsoft365R package to access data stored in SharePoint Online sites.

You can retrieve the items in a list as a data frame using the list_items() function. 

This function has arguments filter and select to do row and column subsetting respectively. 

 

I hope that I could help with that!