Wrangle - A Microsoft Excel Addin for Data Analysis

About Customer

Based in Texas, the client is a prominent data automation services provider in the United States. Their expertise lies in helping businesses improve their downstream systems and processes through data transformation. Additionally, they offer Excel Add-in services to boost business productivity.

Challenge

The client wanted to build a tool by using that users can easily authenticate with different connectors like Salesforce with an OAuth login option. After connecting to one connector users can select tables that are available for that connector and can perform SQL query operations. Based on the query result, data will be displayed on an Excel sheet, so that users can easily analyze the data and perform different Excel sheet operations.

wrangle-a-microsoft-excel-addin-for-data-analysis-01.webp

wrangle-a-microsoft-excel-addin-for-data-analysis-02.webp

wrangle-a-microsoft-excel-addin-for-data-analysis-03.webp

wrangle-a-microsoft-excel-addin-for-data-analysis-04.webp

Technology Used

Microsoft Office Add-in

Platform
React JS, Fluent UI

Frontend Technologies
Node JS

Backend Technologies
MS Excel Add-in

Type
MySQL

DataBase
GIT

Version Control

Solution

iFour Technolab - an esteemed Excel Add-in development company, came up with a solution to cope with these concerns. We built an Excel add-in that is easily installable on any version of Microsoft Office. This add-in helps users select connectors like Salesforce and authenticates with the help of a secure OAuth login flow.

After authentication, this add-in provides a list of tables that are available in the connector with a user-friendly interface for end users. Here, users can select any one table from a list and can generate SQL queries that are in human-readable form. We display this SQL query result on an Excel sheet so that users can easily analyze the data and perform different Excel sheet operations. Apart from this, users can save the SQL queries, reuse them in the future, and also can modify it.

Microsoft Excel Addins - Wrangle comprises the following features:

1. OAuth authentication - The user can authenticate with a secure OAuth login flow.
2. SQL query generation – Generate the SQL query and convert it into a human-readable format by using table fields.
3. Print data on the sheet – Print data on the sheet – The user can print the SQL query result on Excel sheets.

Our solution performed outstandingly in the market and helped the client reach more than 1000+ users and 80+ businesses worldwide.

iFour Technolab believes in quality outcomes, and our team of professionals works to build the best match solution for our clients that satisfies their precise business goals and prospects. And this is one of our custom solutions that helped a client to upgrade the functionality in Microsoft Excel.

Conclusion/Results

iFour Technolab USA. starves to serve clients with goal-oriented solutions so we developed a robust Excel add-in, which can help users authenticate with secure OAuth flow, generate SQL queries, and print the results into an Excel sheet for better analysis. Based on the query result, data is displayed on an Excel sheet, allowing users to easily analyze data insights and perform various Excel sheet operations. Want to kick off your business inefficiencies? Get in touch with us today to build your custom Office 365 Add-in development project.