Create, edit, and analyze .xlsx, .csv, and .tsv files with Python.
npx skills add https://github.com/northseadl/skillwisp --skill spreadsheet-northseadl
Please help me install this Agent Skill. Skill: spreadsheet Source: https://github.com/northseadl/skillwisp/tree/main/skills/%40openai/spreadsheet Command: npx skills add https://github.com/northseadl/skillwisp --skill spreadsheet-northseadl
This Skill streamlines the creation, modification, and analysis of spreadsheet files, enabling efficient data management and reporting.
.xlsx, .csv, or .tsv files with formulas, formatting, and structured layouts.Use the spreadsheet skill to create a new Excel file named 'sales_report.xlsx' with columns for 'Date', 'Product', and 'Revenue'.
High-intent search queries and answers about installing and using this skill.
Create Excel files with formulas and formatting using Python by leveraging openpyxl to build structured workbooks. This approach allows you to programmatically define columns, apply layouts, and insert calculations into new .xlsx files.
Yes, you can modify existing Excel spreadsheets while preserving formulas, references, and formatting. This ensures workbook integrity is maintained when updating data or adjusting structured layouts within your .xlsx files.
Analyze CSV or TSV tabular data for reporting using pandas to read, filter, and aggregate datasets. This process computes key metrics from raw tabular data, enabling efficient data analysis and reporting.
Yes, this spreadsheet automation approach supports data visualization by creating charts and tables directly within spreadsheets. You can present analyzed data visually alongside computed metrics in your generated Excel files.
The best way to generate a monthly sales report from raw data is to use pandas for analysis and openpyxl for output. This combination calculates performance indicators and exports formatted results into a structured Excel file.
Yes, you need pandas and openpyxl to build and edit xlsx files effectively. Pandas handles data analysis and aggregation, while openpyxl manages workbook creation, formatting, and formula preservation.
JosephWoodallProcess and transform XLSX, CSV, and TSV spreadsheets using openpyxl.
soq123Generate and format Excel workbooks with formulas, charts, and pivot summaries using Python.
silvainfmRun SQL analytics directly on CSV, Parquet, and JSON files and Pandas or Polars DataFrames.
MooseGoose0701Create, edit, analyze, and visualize .xlsx, .csv, and .tsv files with Python.