4 ms·

I have to ask this here... Because I have the same annoyance with SharePoint Lists. While you can import a sharepoint list into Excel and refresh as you desire

I have to ask this here... Because I have the same annoyance with SharePoint Lists. While you can import a sharepoint list into Excel and refresh as you desire... You actually can't edit in Excel and push it back to sharepoint. I wish it was bidirectional. If anyone knows of a way or even a 3rd party app that allows this please let me know. Ideally I would expect third party tool to be similar to a database explorer /navigator where you can CRUD - but this doesn't seem to exist.

CharlesW 4y ago
> If anyone knows of a way or even a 3rd party app that allows this please let me know. Potential commercial solution: https://www.synchronizer-for-excel-and-sharepoint.com/ https://www.synchronizer-for-excel-and-sharepoint.com/
faeriechangling 4y ago
I will say if you want to get your hands dirty look into Power Automate. Also look into powershell, pnpsharepoint, and importexcel. This sort of integration isn’t impossible to DIY but it will take a lot of effort to make the first such integration. I’m going to say right away though many processes I’ve seen involving excel spreadsheets and SharePoint are inane managerisms which should never be automated and instead should be purged with fire. LOTS of fire.
ics 4y ago
Completely agree that this should be a seamless experience but unfortunately it's not there. As faeriechangling said, you can start with Power Automate and do a lot of dirty work with Powershell but the amount of effort is annoying especially if you hit a wall in your organization (e.g. in my case Power Automate is fine, but there's no way I'm getting PnP). The dumbed down version is to use the "edit in grid view" feature of lists, which happens to make copy/pasting cells and rows between Sharepoint and Excel easy. I've done this before to make bulk changes when any additional effort isn't worth it.
- gompertz 4y ago
  Yeah, while I myself can deal with Power Automate / Powershell, the average company layman user still can't even do an index match formula, so there's no way they are going to understand anything that complex. I've done what you have done and demonstrated the pasting into grid view. But this requires a perfect placement of the cursor and also the slow as f*ck row-by-row validation+commit to the database is outright comedic.

CharlesW 4y ago

> If anyone knows of a way or even a 3rd party app that allows this please let me know. Potential commercial solution: https://www.synchronizer-for-excel-and-sharepoint.com/ https://www.synchronizer-for-excel-and-sharepoint.com/

faeriechangling 4y ago

I will say if you want to get your hands dirty look into Power Automate. Also look into powershell, pnpsharepoint, and importexcel. This sort of integration isn’t impossible to DIY but it will take a lot of effort to make the first such integration. I’m going to say right away though many processes I’ve seen involving excel spreadsheets and SharePoint are inane managerisms which should never be automated and instead should be purged with fire. LOTS of fire.

ics 4y ago

Completely agree that this should be a seamless experience but unfortunately it's not there. As faeriechangling said, you can start with Power Automate and do a lot of dirty work with Powershell but the amount of effort is annoying especially if you hit a wall in your organization (e.g. in my case Power Automate is fine, but there's no way I'm getting PnP). The dumbed down version is to use the "edit in grid view" feature of lists, which happens to make copy/pasting cells and rows between Sharepoint and Excel easy. I've done this before to make bulk changes when any additional effort isn't worth it.

gompertz 4y ago
Yeah, while I myself can deal with Power Automate / Powershell, the average company layman user still can't even do an index match formula, so there's no way they are going to understand anything that complex. I've done what you have done and demonstrated the pasting into grid view. But this requires a perfect placement of the cursor and also the slow as f*ck row-by-row validation+commit to the database is outright comedic.