Excel Add-in for G Suite is a part of Excel import and export add-ins package, which allows you to easily synchronize data between Excel and various data sources, including popular databases, such as DB2, MySQL, SQL Server, Oracle, different CRMs, such as Microsoft Dynamics CRM, and other sources such as BigCommerce and FreshBooks.
Before you can start using the add-in, you must establish a connection to G Suite from the Import Data Wizard in Excel. There you can specify a few other connection parameters as well, and test if the connection is working. From Import Wizard you can also specify tables, columns, filters and ordering of data. In addition, you can also use custom SQL for data import, and you can also preview the data before importing it into Excel.
After you have successfully imported the data to Excel, you can start using all the Excel capabilities on this data. Data can be refreshed at any time from the source, and if you enable editing mode, you can also edit the data in Excel and then synchronize changes back to G Suite. And, if you change your mind, there is also an option to undo data changes to G Suite.
In addition, Excel Add-in for G Suite also instantly validates all entered data, and there are also a few options you can set, such as coloring for erroneous and modified cells, or for added, deleted and committed rows.
Reviewed by Tony Hill (editor rating 4 out of 5 stars)