excel analysis

Turn Excel data into clean reports, pivots, and charts.

spreadsheet analysis

What it does

Analyzes Excel spreadsheets, cleans and combines data, and creates formatted workbooks, pivot tables, and charts.

When to use it

Use when analyzing Excel files, spreadsheets, tabular data, or .xlsx files.

Give it spreadsheet files and the desired work; it analyzes the data or creates workbook and chart files in the project.

What you provide

No additional actions listed in the analysis.

Requires Python to run the documented analysis code.

Uses pandas as the primary package for data analysis and manipulation.

Uses openpyxl for Excel file creation and formatting.

Enables reading older .xls files.