Excel Add-In for Gmail

In the eventuality that your business regularly deals with customer orders or sales confirmations, then there is a very good chance that you are looking for a solution that enables you to retrieve the emails to a more adaptable environment where you can edit and manage it better.

As the name suggests, Excel Add-In for Gmail is a utility designed to help you retrieve all sorts of data you have on your email client – contacts, directories, events, tasks or messages – to an Excel spreadsheet.

First off, you should know that you are required to establish a connection with your Gmail account before you can use the application. While it may sound complicated, you will be glad to learn that this is a straightforward process.

More precisely, you can type down your Gmail username and password in the dedicated fields and then hit the OK button. In case the app cannot connect to your email account, then you should verify whether you introduced your credentials correctly.

As far as the GUI is concerned, since this is an add-in for Microsoft Excel, the utility borrows the looks and functionality of the spreadsheet application. You can enable various options for the connections, namely inserts, updates and deletes.

You can retrieve data from your Gmail directories by accessing the CData Data Selection window. It is important to note that the add-in uses SQL to communicate with your Gmail, so if you are familiar with the database functions, you can configure it to extract the exact data you want as tables or views.

The program allows to extract a wide variety of data, including but not limited to messages, events, the address book, notes or custom directories, to name a few. You can specify the maximum number of records you want to obtain and define a name for the worksheet.

Excel Add-In for Gmail enables you to perform SQL queries to extract valuable data from your Gmail account to Excel, so you can manage the information better and answer requests or pass orders faster.