data-analysis

You can run SQL queries on an Excel file by using DuckDB to directly query your uploaded .xlsx or .xls data. This allows you to perform custom data analysis and extract specific insights without manual spreadsheet manipulation.

Yes, you can join data across multiple CSV files. The data analysis process supports cross-file joins using SQL, allowing you to combine datasets from different CSV files for comprehensive data exploration and reporting.

You generate statistical summaries for CSV data by executing analytical commands against the uploaded file. This automatically calculates and returns key statistics for both numeric and text columns, providing quick insights into your dataset.

The best way to export SQL query results to JSON or Markdown is by using the data analysis tool's export feature. After executing your custom SQL queries, you can directly save the output results in CSV, JSON, or Markdown formats.

Yes, this data analysis approach fully supports multi-sheet Excel workbooks. You can inspect the schema and execute arbitrary SQL queries across multiple sheets within a single .xlsx or .xls file to explore all your data comprehensively.

To inspect the schema of an uploaded Excel file, you simply need your .xlsx or .xls dataset ready. The analysis tool automatically reads the file structure, allowing you to understand its columns and data types immediately without complex software.