Can we do a two-way sync of data between Excel and SharePoint list in SharePoint online

%3CLINGO-SUB%20id%3D%22lingo-sub-1165649%22%20slang%3D%22en-US%22%3ECan%20we%20do%20a%20two-way%20sync%20of%20data%20between%20Excel%20and%20SharePoint%20list%20in%20SharePoint%20online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1165649%22%20slang%3D%22en-US%22%3E%3CP%3EExport%20the%20SharePoint%20List%20to%20excel%20.%20Now%20if%20we%20make%20the%20changes%20in%20Excel%20%2C%20will%20it%20get%20updated%20in%20SharePoint%20List.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1165649%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESites%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1165856%22%20slang%3D%22en-US%22%3ERe%3A%20Can%20we%20do%20a%20two-way%20sync%20of%20data%20between%20Excel%20and%20SharePoint%20list%20in%20SharePoint%20online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1165856%22%20slang%3D%22en-US%22%3ENo%20it%20doesn't%20get%20updated%2C%20it's%20a%20one%20way%20refresh%20of%20data.%3CBR%20%2F%3E%3CBR%20%2F%3EWe%20just%20make%20sure%20that%20all%20data%20is%20edited%20in%20SharePoint%20and%20excel%20is%20used%20for%20making%20pretty%20reports.%3C%2FLINGO-BODY%3E
Highlighted
Senior Member

Export the SharePoint List to excel . Now if we make the changes in Excel , will it get updated in SharePoint List. 

1 Reply
Highlighted
No it doesn't get updated, it's a one way refresh of data.

We just make sure that all data is edited in SharePoint and excel is used for making pretty reports.