Question: How can you have two-way synchronization of data between Excel and a SharePoint list?

I've read the Office support [Manage large lists and libraries in SharePoint](https://support.office.com/en-us/article/Manage-large-lists-and-libraries-in-SharePoint-b8588dae-9387-48c2-9248-c24122f07c59) page and the limitation about Excel being one-way

> 
> Microsoft Excel You can export SharePoint lists to an Excel Table, which creates a one-way data connection between the Excel table and the SharePoint list.
> 
> 
> 

Is there anyway to have a two-way sync?

*... the end users want the speed and flexibility of editing, conditional formatting, freeze panes, etc. that they're used to in Excel*

Answer: 
There is no way to have two-way sync out of the box (OOTB) between Excel and a SharePoint List as Microsoft deprecated this feature 10 years ago. OOTB Options include creating a new SP list from an Excel file and exporting a list to an Excel file.

To have bi-directional sync, you need a third party tool such as [SharePoint List Synchronizer](https://www.synchronizer-for-excel-and-sharepoint.com). Disclaimer: this product is edited by SoftFluent, my employer.
I’m proposing a workaround to the suggested third party solution. It is a two-parter. **Part 1** addresses formatting and **Part 2** addresses speed. 

**Part 1:** Export the list to Excel and save the workbook back to SharePoint with a data connection. Format the workbook with all desired Excel features such as freeze panes, conditional formatting, etc.

1. Export the list or library to Excel.
2. Create a data connection to the list or library so that the workbook automatically syncs with list updates when opened.
3. Format the workbook for printing.
4. Save the workbook to SharePoint for users.
For step-by-step instructions view my post at <https://jennyssharepointtips.wordpress.com/2015/03/28/print-live-list-or-library-data-from-excel-workbooks-using-data-connections/>.

**Part 2:** Instruct users on editing lists using Quick Edit (SharePoint 2013 and later) or Datasheet view (SharePoint 2010 and earlier).

**Bonus speed option:** Add the out of the box “Edit" button to the list views. It makes it quick and easy to access an item's edit form.