When you work with large Excel spreadsheets, tasks like joining several tables into one, removing duplicates, complex filtering, grouping, sorting, etc. become a challenge. SQL Queries App offers a new approach to accomplish these tasks easily. Now users who are familiar with structured query language can run SQL queries directly against Excel tables. Here is just a short list of what you can do:
• Automatically generate SELECT and JOIN queries and edit them manually
• Work with many tables in any open spreadsheet using SELECT queries
• Join two or more tables by a key column using JOIN statements
• Remove duplicates using DISTINCT or GROUP BY statements
• Apply complex filtering with a certain criteria using WHERE statements
• Apply complex sorting, grouping and aggregation using SUM, COUNT, MIN, MAX statements, and much more!