I have a SP Online list and I want to present this data as a report using Excel Web Access.
First is it possible to sync a SP Online list data to an excel file uploaded to SP document library as a report? If so how?
You can follow the steps below to add connection to a SP Online list and upload the excel file to a SP Online library. The data in the workbook will refresh automatically if the refresh control is enabled. After that, you can display the data using Excel Web Access web part.
Edit this data connection properties, set the refresh control to refresh data when opening the file or other refresh options as you want.