![Screenshot of Aqua Data Studio version 17.0.0 connected to a Microsoft Excel database. The editor displays a SQL query (SELECT * FROM [bistudio_example].[Orders]) for retrieving data from the Orders table within the bistudio_example schema. The left panel shows the hierarchical structure of the Excel database, including tables from multiple folders such as New folder (2). A context menu is open for the Orders table, showing options like Edit Table Data (Top 1000), Script Object to Window As, and Script Object to New Window As, highlighting Aqua Data Studio’s functionality for interacting with Excel files as databases.](https://aquadatastudio.com/wp-content/uploads/2024/09/aquadatastudio_excel_schema_browser.png)
Aqua Data Studio provides a SQL management tool for Excel files. The visual administration features provide users the ability to browse workbooks, worksheets and column structures. An integrated query tool allows you to quickly create, edit and execute SQL.
ExcelSQL is a SQL-92 based SQL language that offers a rich syntax to execute queries with WHERE, JOIN, ORDER BY, GROUP BY, HAVING and UNION clauses. Subqueries, derived tables, JOINs across multiple workbooks and many convenient DB functions are also supported.
