SharePoint
Feedback by UserVoice

I suggest you ....

← Sites and Collaboration

Two-Way-Sync between SharePoint and Excel

It should be feasible to sync updates from Excel to SharePoint Online list. We can import the Excel sheet to a SharePoint Online list or export a SharePoint list to Excel file. However, the sync between them is one-way.

Changes made in the SharePoint list can be written to Excel, but any changes that we make in Excel won't written to SharePoint list automatically.

255 votes
Sign in
(thinking…)
Sign in with: Facebook Google
Forgot password?
Create a password
Signed in as (Sign out)
Close
Close

We’ll send you updates on this idea

Anonymous shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

15 comments

Sign in
(thinking…)
Sign in with: Facebook Google
Forgot password?
Create a password
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Anonymous commented  ·   ·  Flag as inappropriate

    Excel is the only software that allow us to have easily programed tools for CALCULATING and CREATING information (Not only filling forms) for our companies. It would be the best feature ever made to sync excel and an accessible data storage as sharepoint lists. OneDrive isn't enouth and data bases as SQL are too complex for most business owners as my self.

  • Marc B. commented  ·   ·  Flag as inappropriate

    I can´t believe that this is not possible. Most organizations are still worling with crm´s / erp`s that have their own folderstrukture so that you are searching at this space. But they have the need to work more and more together. So this would be one of the most needed feature, I thing.

  • Prashant B commented  ·   ·  Flag as inappropriate

    This indeed is a very needed feature. Today there is a need to have excels synced with my sharepoint list and the only way to accomplish this is via third party tools which is not good. Please have this implment as soon as possible

  • Anonymous commented  ·   ·  Flag as inappropriate

    Also important to note that the import Excel Spreadsheet option very often does not work. The Active X requirement is a real problem and there are regularly errors in IE as well that just seem to be 'unknown' errors - the whole excel spreadsheet connection in sharepoint lists scenario should be looked at very closely and improved upon please.

  • Angie Keller commented  ·   ·  Flag as inappropriate

    This is the missing functionality that would take SharePoint from "why do I need to use this?" to "WOW! this is great!!!"

  • Rich Stutzman commented  ·   ·  Flag as inappropriate

    Sharepoint list has export to Excel. Add upload from Excel. Keep it simple and insist all fields, data types & formats match for it to work. Get it out there and enhance later.

  • Stefan Schneider commented  ·   ·  Flag as inappropriate

    The excisting solution with a Makros für Excel 2003 ist too old - only .xls-files are supportet (up to max. 65000 rows)

Sites and Collaboration: Lists

Categories

Feedback and Knowledge Base

(thinking…)


SharePoint Tech Community

UserVoice Terms of Service & Privacy Policy