--- title: Excel Database Tasks (EDT) Reviews meta_title: 'Excel Database Tasks (EDT) Reviews 2026: Details, Pricing, & Features | G2' meta_description: Filter 17 reviews by the users' company size, role or industry to find out how Excel Database Tasks (EDT) works for a business like yours. aggregate_rating: rating_value: 4.4 review_count: 17 scale: '5' date_modified: '2026-07-07' parent_category: name: Database Software url: https://www.g2.com/categories/database-software --- # Excel Database Tasks (EDT) Reviews **Vendor:** Lean Software Ltd **Category:** [Database Management Systems (DBMS)](https://www.g2.com/categories/database-management-systems-dbms) **Average Rating:** 4.4/5.0 **Total Reviews:** 17 ## About Excel Database Tasks (EDT) Excel Database Tasks (EDT) enables you to easily build powerful data edit/processing, data load/transfer and reporting solutions. ## Excel Database Tasks (EDT) Reviews ### 1. Excel data base **Rating:** 5.0/5.0 stars **Reviewed by:** Saqlain H. | Relationship Officer, Mid-Market (51-1000 emp.) **Reviewed Date:** July 05, 2022 **What do you like best about Excel Database Tasks (EDT)?** EDT store data more efficiently, It can handle the volumes and can require a large amount of hard drive space for data storage **What do you dislike about Excel Database Tasks (EDT)?** There is nothing to dislike about it as it's makes our work easy and fast **What problems is Excel Database Tasks (EDT) solving and how is that benefiting you?** As it's help to add number of data and reduce the storage space an excel play a big role in each life ### 2. Great program to create tables and statistical information. **Rating:** 4.0/5.0 stars **Reviewed by:** Libio L. | Analista de Sistemas, Public Policy, Enterprise (> 1000 emp.) **Reviewed Date:** February 27, 2018 **What do you like best about Excel Database Tasks (EDT)?** It is very easy to use and can have multiple information contained in a single file. It allows me to manage the data individually to generate statistical tables, amortization tables, dynamic tables, control of loan management of statistical information on a large scale. I can use them to create small databases without having to have large database administrators. I can migrate the quarters as independent tables. The information can be synchronized with the microsoft database. The sheets can be used individually, being able to generate independent matrices and compare them to obtain statistical tables, as well as to relate them and obtain another matrix with the integrated information. I can convert the worksheets into a database for any database manager (dbase, Oracle, Informix, Postgrep, etc). **What do you dislike about Excel Database Tasks (EDT)?** Its capacity is limited to a number of cells, I can not work it multiuser, its license is very expensive, it loses the format when it is migrated to another platform. The generated files are not compatible with other programs. It requires computers with a lot of capacity to take advantage of all its benefits. **Recommendations to others considering Excel Database Tasks (EDT):** It is very didactic and easy to use, with the help you can generate the operations you want. **What problems is Excel Database Tasks (EDT) solving and how is that benefiting you?** It allows me to generate statistical tables with the data obtained from images to show how efficient a teacher is and the feasibility of selecting the most appropriate one to get the most out of it. With the statistics I can select the best product at the lowest cost and make future projections. ### 3. Powerful tool in data basing **Rating:** 5.0/5.0 stars **Reviewed by:** jigs e. | IT Consultant, Marketing and Advertising, Mid-Market (51-1000 emp.) **Reviewed Date:** April 04, 2018 **What do you like best about Excel Database Tasks (EDT)?** I like that I am able to import and export data easily. I like the ability to create formulas on my spreadsheets. User interface is very simple. can be used with minimum training. The sheets can be used individually, being able to generate independent matrices and compare them to obtain statistical tables, as well as to relate them and obtain another matrix with the integrated information. **What do you dislike about Excel Database Tasks (EDT)?** Not fully GUI, should be more versatile across platforms. row limitation. cannot import large quantity of data. row limitation. cannot import large quantity of data. Its capacity is limited to a number of cells, I can not work it multiuser, its license is very expensive, it loses the format when it is migrated to another platform. The generated files are not compatible with other programs. It requires computers with a lot of capacity to take advantage of all its benefits. **Recommendations to others considering Excel Database Tasks (EDT):** Excel offers a matrix platform where you can enter and transform data into formatted information. Whether you want to create charts, analyze trends in data points, clean data, automate a task, or run a complex system of equations, Excel can help you quickly get it done. **What problems is Excel Database Tasks (EDT) solving and how is that benefiting you?** Managing company data, pulling data linked to a front end interface and also streamline Excel-based tasks. EDT helps me manage inventory accounting and it has really saved me time without having to manually enter data. ### 4. The wonders of excel **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Insurance | Small-Business (50 or fewer emp.) **Reviewed Date:** August 16, 2018 **What do you like best about Excel Database Tasks (EDT)?** Excel is a numerical software that can do everything. It makes surprising formulas and easy to reproduce in the quantities you want **What do you dislike about Excel Database Tasks (EDT)?** I dislike that I'm sure I can achieve more goals with excel. But it is so broad that I still can not know it at all **What problems is Excel Database Tasks (EDT) solving and how is that benefiting you?** I solve all the budgetary calculations of the work. I control deviations in company numbers. ### 5. revision for douglas EXCEL **Rating:** 5.0/5.0 stars **Reviewed by:** douglas p. | Mid-Market (51-1000 emp.) **Reviewed Date:** April 22, 2018 **What do you like best about Excel Database Tasks (EDT)?** I LIKE TO CREATE DATABASES WITH WHICH I HELP MYSELF TO HANDLE CONFIDENTIAL AND IMPORTANT INFORMATION **What do you dislike about Excel Database Tasks (EDT)?** I HAVE NOT DISLIKED ANYTHING ABOUT THE PROGRAM YET **Recommendations to others considering Excel Database Tasks (EDT):** Let them release more tutorials for us to learn more formulas and functions beyond what we already know. Another thing is that in future updates, Excel should include more predefined formulas to facilitate work in offices and administrative departments. **What problems is Excel Database Tasks (EDT) solving and how is that benefiting you?** THE ONLY THING IS THAT WHEN THE EXCEL FILE IS FROM ANOTHER YEAR, THAT IS, OLDER, IT DOESN'T WANT TO OPEN ON MY COMPUTER, BUT OTHERWISE PERFECT, THE BENEFITS ARE VARIED FROM CREATING DATABASES TO THE FILTERS AND FORMULAS THAT ONE CAN MAKE AND LEARN. ### 6. Smart simple and intuitive **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Military | Enterprise (> 1000 emp.) **Reviewed Date:** January 30, 2018 **What do you like best about Excel Database Tasks (EDT)?** All functions were easy to navigate. Any formulas I was not aware of I could google quickly to get the answer. This program allowed me to manipulate data from other applications. **What do you dislike about Excel Database Tasks (EDT)?** Honestly not much, I like the program we had error messages come up a bunch but I believe thstwas more of an internal lack of support rather than a program issue. **What problems is Excel Database Tasks (EDT) solving and how is that benefiting you?** I was able to upload vendor reports out of GP directly into and sort and change multiple items before printing 1099's. This program allowed me to prepare taxes. ### 7. Works Very Well **Rating:** 3.0/5.0 stars **Reviewed by:** Verified User in Construction | Mid-Market (51-1000 emp.) **Reviewed Date:** March 20, 2018 **What do you like best about Excel Database Tasks (EDT)?** I like the ease of use and ability to find functions **What do you dislike about Excel Database Tasks (EDT)?** Printing from it can be challenging at times. **What problems is Excel Database Tasks (EDT) solving and how is that benefiting you?** Increase productivity ### 8. The best way to manage databases **Rating:** 4.5/5.0 stars **Reviewed by:** Jhoel M. | Coord. Planificacion y abastecimiento, Mid-Market (51-1000 emp.) **Reviewed Date:** July 26, 2016 **What do you like best about Excel Database Tasks (EDT)?** The software performs excellently when linking it with SQL databases. The add-in in Excel allows handling the information from there. **What do you dislike about Excel Database Tasks (EDT)?** Support response time should be improved, perhaps due to the time difference we have in Latin America. **What problems is Excel Database Tasks (EDT) solving and how is that benefiting you?** The information from 5 databases was successfully consolidated into a single program, which resulted in a reduction and better utilization of man hours. ### 9. Data Organization **Rating:** 2.5/5.0 stars **Reviewed by:** Verified User in Apparel & Fashion | Small-Business (50 or fewer emp.) **Reviewed Date:** September 16, 2016 **What do you like best about Excel Database Tasks (EDT)?** What I like most about Excel is that I can manage, sort and analyze data. I work with large amounts of data and I find it easy to maintain my data using Excel Spreadsheets. So the biggest benefit of Excel is its main function. Excel files can be sent as attachments, so that is a plus as well. **What do you dislike about Excel Database Tasks (EDT)?** I dislike the fact that Excel has no means to check for human error during data entry. I also dislike using formulas and calculations. It takes practice and if a person is not familiar with calculations they can easily become frustrated. **Recommendations to others considering Excel Database Tasks (EDT):** I highly recommend Excel to anyone who needs too sort, and analyze data. **What problems is Excel Database Tasks (EDT) solving and how is that benefiting you?** I am able to sort massive data into orderly logical spreadsheets. I am able to keep up with things and maintain my records. ### 10. An easy tool for database tasks **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Higher Education | Enterprise (> 1000 emp.) **Reviewed Date:** February 21, 2017 **What do you like best about Excel Database Tasks (EDT)?** Intuitive control, powerfull engine, good help system. **What do you dislike about Excel Database Tasks (EDT)?** Linking between fields using $ characters is counterintuitive until properly explained. **What problems is Excel Database Tasks (EDT) solving and how is that benefiting you?** Analysis of simple data sets. ### 11. Excel **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Aviation & Aerospace | Enterprise (> 1000 emp.) **Reviewed Date:** December 19, 2016 **What do you like best about Excel Database Tasks (EDT)?** I like that I can make useful charts and spreadsheets to display complex and massive amounts of information. **What do you dislike about Excel Database Tasks (EDT)?** Excel crashes a lot and I lose information sometimes. I don't like having to restart my software or "end task" so often. **Recommendations to others considering Excel Database Tasks (EDT):** yes I recommend to make useful charts and spreadsheets to display complex and massive amounts of information. **What problems is Excel Database Tasks (EDT) solving and how is that benefiting you?** taking complex data and turning it into charts and graphs to make it easier to read. ### 12. powerful database for light weight back-end support **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Mechanical or Industrial Engineering | Enterprise (> 1000 emp.) **Reviewed Date:** January 24, 2017 **What do you like best about Excel Database Tasks (EDT)?** User interface is very simple. can be used with minimum training. Easy to use interface. **What do you dislike about Excel Database Tasks (EDT)?** Not fully GUI, should be more versatile across platforms **Recommendations to others considering Excel Database Tasks (EDT):** fully recommend for small & medium sized companies **What problems is Excel Database Tasks (EDT) solving and how is that benefiting you?** Managing company data, pulling data linked to a front end interface ### 13. Great product! **Rating:** 4.5/5.0 stars **Reviewed by:** Lisa H. | Community Engagement Coordinator, Non-Profit Organization Management, Small-Business (50 or fewer emp.) **Reviewed Date:** July 21, 2016 **What do you like best about Excel Database Tasks (EDT)?** The ability to keep all of my contacts in separate categories, then the ease of merging for mailings and emailing. I couldn't do my work without this product. **What do you dislike about Excel Database Tasks (EDT)?** Nothing that I can think of right now. Works well. **What problems is Excel Database Tasks (EDT) solving and how is that benefiting you?** Contacting individuals is much easier that using access or other programs I've used in the past. ### 14. data import, data analysis, data mapping **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Financial Services | Enterprise (> 1000 emp.) **Reviewed Date:** August 25, 2016 **What do you like best about Excel Database Tasks (EDT)?** powerful tool for importing data from various sources **What do you dislike about Excel Database Tasks (EDT)?** row limitation. cannot import large quantity of data **What problems is Excel Database Tasks (EDT) solving and how is that benefiting you?** data analysis. ### 15. EDT is EZ **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Higher Education | Enterprise (> 1000 emp.) **Reviewed Date:** August 03, 2016 **What do you like best about Excel Database Tasks (EDT)?** ease of use, small learning curve even for technophobes **What do you dislike about Excel Database Tasks (EDT)?** bit rudimentary UI, seems stuck in the past **What problems is Excel Database Tasks (EDT) solving and how is that benefiting you?** streamline Excel-based tasks did that ### 16. Excel **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Wine and Spirits | Small-Business (50 or fewer emp.) **Reviewed Date:** February 09, 2016 **What do you like best about Excel Database Tasks (EDT)?** I like the ability to create formulas on my spreadsheets. **What do you dislike about Excel Database Tasks (EDT)?** How most of Excels really neat functions are hidden unless you have a lot of experience. **What problems is Excel Database Tasks (EDT) solving and how is that benefiting you?** By using sorting tools and the pivot table function I am able to gather the information I need for reporting so much faster. The Pivot table saves so many hours of work! I love this function. ### 17. If you like MS EXCEL, you will LOVE EXCEL Database Tasks (EDT). **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Mining & Metals | Enterprise (> 1000 emp.) **Reviewed Date:** January 05, 2016 **What do you like best about Excel Database Tasks (EDT)?** I like that I am able to import and export data easily. **What do you dislike about Excel Database Tasks (EDT)?** I dislike that once in awhile the references need to be updated. **Recommendations to others considering Excel Database Tasks (EDT):** If you don't understand MS Excel too well, then work on that before using some of the more advanced EDT features. **What problems is Excel Database Tasks (EDT) solving and how is that benefiting you?** EDT helps me manage inventory accounting and it has really saved me time without having to manually enter data. ## Excel Database Tasks (EDT) Discussions - [What is Excel Database Tasks (EDT) used for?](https://www.g2.com/discussions/what-is-excel-database-tasks-edt-used-for) - [View Excel Database Tasks (EDT) pricing details and edition comparison](https://www.g2.com/products/excel-database-tasks-edt/reviews?section=pricing&secure%5Bexpires_at%5D=2026-07-17+03%3A00%3A07+-0500&secure%5Bsession_id%5D=1a095fb5-2803-4e8e-955a-34e134f54f4a&secure%5Btoken%5D=d14eec10fdcb9293f0763f15e4d072c2f85f69b59f39ea3029a9f1b81aa061d3&format=llm_user) ## Excel Database Tasks (EDT) Features **Management** - Data dictionary - Data Replication - Query Language - Data Modeling - Performance Analysis **Maintenance** - Data Migration - Backup and Recovery - Multi-User Environment **Security** - Data Encryption - User Access Control ## Top Excel Database Tasks (EDT) Alternatives - [Snowflake](https://www.g2.com/products/snowflake/reviews) - 4.5/5.0 (706 reviews) - [Microsoft SQL Server](https://www.g2.com/products/microsoft-sql-server/reviews) - 4.4/5.0 (2,128 reviews) - [Databricks](https://www.g2.com/products/databricks/reviews) - 4.6/5.0 (1,316 reviews)