xlsx-lite

Totalize a numeric column in CSV data and append a Totals row.

Updated Oct 6, 2025

Search Tags:#scripting #csv #data-processing #data-cleanup #totals #sum-column

Ready to run

npx skills add https://github.com/OutfinityResearch/AchillesAgentLib --skill xlsx-lite

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: xlsx-lite
Source: https://github.com/OutfinityResearch/AchillesAgentLib/tree/main/evalsSuite/anthropic-skills/skills/xlsx-lite
Command: npx skills add https://github.com/OutfinityResearch/AchillesAgentLib --skill xlsx-lite

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) components.

What problem does it solve?

Use for simple spreadsheet-like tasks that can be handled as CSV files and performs simple transforms using a bundled Python script with no external dependencies.

Core Features & Use Cases

Totals: compute a numeric column total and append a Totals row to the CSV.
Column edits: support basic edits by producing a new CSV with the updated column values.
Use Case: quickly summarize a sales CSV by adding a Totals row for a specified numeric column.

Quick Start

Run the script to sum the specified column by executing python3 scripts/sum_column.py <input_csv> <output_csv> <column_name>.

Frequently Asked Questions about xlsx-lite

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

FAQPage Schema

How do I totalize a numeric column in a CSV file?▼

You can totalize a numeric column in a CSV file by running a bundled Python script that reads your input CSV, aggregates the specified column, and appends a totals row before writing a clean output CSV.

Can I add a totals row to CSV data without external dependencies?▼

Yes, you can add a totals row to CSV data without external dependencies by using a bundled Python script that processes the input file and writes a formatting-free output CSV with the aggregated row appended.

What is the best way to summarize a sales CSV with a quick totals row?▼

The best way to summarize a sales CSV with a quick totals row is executing a script that takes your input file, output path, and target column name to compute the aggregation and produce a clean CSV output.

Does this CSV data processing script support large datasets?▼

This CSV data processing script does not support large datasets; it is designed for small datasets where you need a quick totals row and a formatting-free CSV output for simple spreadsheet tasks.

How do I compute column totals and produce a clean CSV output?▼

You compute column totals and produce a clean CSV output by executing the sum column script with your input CSV, output CSV path, and the target column name to append the aggregated row.