data-analysis

Analyze Excel and CSV files with SQL queries via DuckDB.

Updated Jun 2, 2026

Search Tags:#data analysis #excel #csv #duckdb #sql query

Ready to run

npx skills add https://github.com/bettercallfan/deerflow --skill data-analysis-bettercallfan

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: data-analysis
Source: https://github.com/bettercallfan/deerflow/tree/main/skills/public/data-analysis
Command: npx skills add https://github.com/bettercallfan/deerflow --skill data-analysis-bettercallfan

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires python, duckdb, openpyxl, pandas, and includes scripts (resource) components.

What problem does it solve?

This Skill simplifies the process of analyzing Excel (.xlsx/.xls) and CSV files, allowing users to execute SQL queries, generate statistics, create summaries, pivot tables, and export results without manual data manipulation.

Core Features & Use Cases

Data Analysis: Execute arbitrary SQL queries to explore, manipulate, and aggregate data from uploaded files.
Statistics and Summaries: Generate statistical summaries and analyze specific data patterns using built-in functions.
Data Export: Export analysis results in various formats such as CSV, JSON, or Markdown for further use or presentation.
Use Case: Analyze sales data from a spreadsheet, generating a summary report and exporting it as a CSV for use in financial planning.

Quick Start

Use the 'data-analysis' skill to run a SQL query on your Excel/CSV data.

Frequently Asked Questions about data-analysis

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do I run SQL queries on Excel and CSV files without importing them into a database?▼

You can run SQL queries directly on Excel and CSV files using this Skill. It leverages DuckDB's in-memory SQL engine to analyze your uploaded spreadsheets, allowing you to explore, aggregate, and manipulate data without manual database setup.

Can I generate statistical summaries and pivot tables from a CSV file using DuckDB?▼

Yes, you can generate statistical summaries and pivot tables from a CSV file using DuckDB. The Skill supports built-in functions to analyze specific data patterns and create summaries from your uploaded files, simplifying complex data exploration.

What is the best way to export analyzed spreadsheet data into JSON or Markdown formats?▼

The best way to export analyzed spreadsheet data into JSON or Markdown is using this Skill's data export feature. After executing your SQL queries and generating summaries, you can export the results in multiple formats including CSV, JSON, and Markdown for presentations.

Do I need Python and Pandas installed to analyze Excel data with this Skill?▼

Yes, you need Python installed to analyze Excel data with this Skill. It requires Python for scripting, along with dependencies like openpyxl and pandas for file handling, and DuckDB to perform the in-memory SQL analysis.

Does this data analysis approach work with both .xlsx and .xls Excel file formats?▼

Yes, this data analysis approach works with both .xlsx and .xls Excel file formats. The Skill uses the openpyxl library to parse your spreadsheets, enabling schema inspection and SQL querying across these supported file types.

How do I inspect the schema of an uploaded CSV file before writing SQL queries?▼

You can inspect the schema of an uploaded CSV file using this Skill's schema inspection feature. It automatically reads your file's structure via pandas, allowing you to understand column names and data types before executing DuckDB SQL queries.