Price: $
Excel Add-in for G Suite icon

Excel Add-in for G Suite

2.9.1323

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
0
/ 0 ratings

Use Excel to modify data from G Suite

Devart | 110 more apps |
updated on February 29, 2024
Download
57.3mb | trialware

Pros

Work with G Suite data directly from Excel

Cons

None
Excel Add-in for G Suite
Price: $
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 (editor rating 4 out of 5 stars)
on

Additional info

Minimum requirements

• .NET Framework 4.0 or higher

Licence limitations

• 30-day trial

Previous versions

Operating system

Windows

Supported languages

English

Downloads

Total: 0
Last week: 0

You might be also interested in