app icon Excel Sync eXsync

A handy tool for data management

of eProducts and SharePoint.

excel sync introduction

eXsync is seamlessly integrated into Microsoft Excel, enabling full CRUD data synchronization with various data sources. Users can work within spreadsheets using all Excel functionalities. eXsync provides bi-directional updates for data from SharePoint, SharePoint Online, Dataverse, and other platforms.
Excel Sync introduction

Managing data of eProducts and SharePoint via Microsoft Excel

Enhance data visualization in eProducts and SharePoint, and manipulate data from SharePoint and SharePoint Online.

excel sync managing data eProducts sharepoint via microsoft excel visualization data eProducts img

Synchronize data from eProducts/SharePoint to MS Excel for comprehensive management using Excel's functions, including filtering, validation, and pivot tables. Once processed, sync data back to eProducts/SharePoint for immediate updates.
app excel sync managing data eProducts sharepoint via microsoft excel visualization data eProducts
app excel sync managing data eProducts sharepoint via microsoft excel manipulate data sharepoint sharepointonline

Ensure the accuracy of the data prior to synchronization.

excel sync managing data eProducts sharepoint via microsoft excel manipulate data sharepoint sharepointonline img

Always remind to double-check data accuracy to ensure smoothly and error-free synchronization. Avoid errors or inconsistencies, as they may lead to larger issues downstream.

Control multiple sites, projects at once.

excel sync managing data eProducts sharepoint via microsoft excel control multiple sites projects img

Each sheet represents a site or project in eProducts, it allows you to add as many projects as you can to have an overview of them. Furthermore, you can execute data from multiple projects to provide an overall for them. Combine data, merged, or re-format data to have a better quick glance.
app excel sync managing data eProducts sharepoint via microsoft excel control multiple sites projects
app excel sync managing data eProducts sharepoint via microsoft excel working offline verify integrity sync site stay connected

Working offline, verify integrity and sync to site when stay connected.

excel sync managing data eProducts sharepoint via microsoft excel working offline verify integrity sync site stay connected img

Allows you to continue your work even when you are not connected to Internet. You can still work while Excel Sync validate your data and ensure that your data is always valid unless you modify the settings of System. The system will also verify the configurations to ensure your spreadsheet is ready to connect with System when you get back online.

Analyse, manage large amount of data with Excel functions.

excel sync managing data eProducts sharepoint via microsoft excel analyse manage data excel functions img

Centralize all data from projects or SharePoint site, and generate data into pivot or charts so you can analyze the data easily. You can also filter, reformat, rearrange, or export data with Excel.
app excel sync managing data eProducts sharepoint via microsoft excel analyse manage data excel functions

The capabilities of eXsync with eProducts

app icon get work items eProducts SharePoint SharePointOnline img

Get work items from eProducts, SharePoint, or SharePoint Online.
Simple configuration to get your data from server to local and start working on those data with full Excel functions.

app icon provide CRUD work items SharePoint items img

Provide CRUD on work items and SharePoint items.
Simply view, create, update, delete items in Excel and sync to those changes to server.

app icon sync compare changes img

Sync and compare changes.
Sync changes to compare data different between local and server data. Show alert on which rows have been modified.

app icon verify integrity goes from offline online img

Verify integrity when goes from offline to online.
Working offline and validate data with existing local settings, verify integrity to allow sync back to server once online again.