# SQL Server Excel Add-In by Devart Reviews
**Vendor:** Devart  
**Category:** [Spreadsheets Software](https://www.g2.com/categories/spreadsheets)  
**Average Rating:** 5.0/5.0  
**Total Reviews:** 1
## About SQL Server Excel Add-In by Devart
Devart Excel Add-in for SQL Server allows you to connect Microsoft Excel to SQL Server, quickly and easily load data from SQL Server to Excel, instantly refresh data in an Excel workbook from the database, edit these data, and save them back to SQL Server. It enables you to work with SQL Server data like with usual Excel worksheets, easily perform data cleansing and de-duplication, and apply all the Excel&#39;s powerful data processing and analysis capabilities to these data.



## SQL Server Excel Add-In by Devart Pros & Cons
**What users like:**

- Users appreciate the **easy data management** capabilities, enabling quick connections and efficient editing of SQL data. (1 reviews)
- Users find the **installation and usability simple** , allowing quick connections to SQL tables with minimal effort. (1 reviews)
- Users appreciate the **easy integrations** of SQL Server Excel Add-In, enabling seamless connections with just a few clicks. (1 reviews)
- Users appreciate the **easy installation and intuitive use** , making SQL data management straightforward and efficient. (1 reviews)

**What users dislike:**

- Users find the **Excel compatibility limitations** frustrating, particularly with refreshing and editing queries in spreadsheets. (1 reviews)

## SQL Server Excel Add-In by Devart Reviews
  ### 1. Excellent and very simple to use.

**Rating:** 5.0/5.0 stars

**Reviewed by:** Julio B. | Assistant coach, Small-Business (50 or fewer emp.)

**Reviewed Date:** January 05, 2025

**What do you like best about SQL Server Excel Add-In by Devart?**

Easy to install and easy to use. Just with a few clicks you are able to connect to SQL tables and to SQL queries.
Editing SQL data from a table or even a query is impressive. It will highlight new, edited and deleted rows, so while editing your data, you know exactly where you are. The commit and rollback features are great.

**What do you dislike about SQL Server Excel Add-In by Devart?**

It would be great if the "refresh data" process could be limited to one query at a time, instead of having to refresh all the queries you created in one spreadsheet.
Also, when editing a query and putting the data back to the Excel sheet, it would be good if it allowed you to decide where to put it (or leave it where the previous data was).

**What problems is SQL Server Excel Add-In by Devart solving and how is that benefiting you?**

Two main business uses:
1. Editing data inside Excel (much easier when prototyping new columns, calculations, etc.)
2. Application data inserting and editing from Excel. I avoided having to create a complete new UI from scratch (woring with zero budget in a non for profit / voluntary situation). The application manages Rugby (youth) players' basic stats like, attendance, conditioning tests results, minutes played, game results, and overall performance measures.



- [View SQL Server Excel Add-In by Devart pricing details and edition comparison](https://www.g2.com/products/sql-server-excel-add-in-by-devart/reviews?section=pricing&secure%5Bexpires_at%5D=2026-05-16+08%3A21%3A30+-0500&secure%5Bsession_id%5D=004e0889-c590-4486-859e-61504ed0bde0&secure%5Btoken%5D=cb9007da09f4ba3e7cb1f151ca6f82fce7af83ffa1507e47f019842dda35ef46&format=llm_user)

## SQL Server Excel Add-In by Devart Features
**Calculating**
- Functions
- Auto Recalculation

**Insights**
- Charts and Graphs
- Tables

**Editing**
- Templates
- Collaborative Editing
- Filtering

**Functionality**
- Addons
- Multi Device Functionality
- Importing and Exporting
- Autosave

## Top SQL Server Excel Add-In by Devart Alternatives
  - [Google Workspace](https://www.g2.com/products/google-workspace/reviews) - 4.6/5.0 (45,397 reviews)
  - [Microsoft 365](https://www.g2.com/products/microsoft365/reviews) - 4.6/5.0 (5,500 reviews)
  - [Microsoft Excel](https://www.g2.com/products/microsoft-excel/reviews) - 4.7/5.0 (3,070 reviews)

