xlsx

Open, read, edit, and convert xlsx/xlsm/csv/tsv spreadsheets with Python.

19|4|Updated Jan 11, 2026
One-click install
npx skills add https://github.com/ZanebonoAlter/Syntopica --skill xlsx-zanebonoalter
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/ZanebonoAlter/Syntopica/tree/main/.claude/skills/xlsx
Command: npx skills add https://github.com/ZanebonoAlter/Syntopica --skill xlsx-zanebonoalter

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This skill automates the tedious, repetitive work of managing spreadsheets by enabling programmatic open, read, edit, format, clean, and convert operations across xlsx, xlsm, csv, and TSV formats. It helps transform messy data into clean, structured spreadsheets ready for analysis or reporting.

Core Features & Use Cases

  • Open, read, edit, format, and fix existing spreadsheets (xlsx/xlsm/csv/tsv) including adding columns, applying formulas, formatting, and charting.
  • Create new spreadsheets from scratch or from existing data sources and export to standard formats.
  • Convert between tabular file formats (e.g., csv/tsv/xlsx) while preserving data integrity and types.
  • Clean and restructure messy data (malformed rows, header issues, junk data) into well-formed spreadsheets.
  • Trigger when user references a spreadsheet by name or path; deliverable must be a spreadsheet file.

Quick Start

Provide the input spreadsheet path and your desired operation, and I will output a cleaned, formatted spreadsheet as the deliverable.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I automate spreadsheet data cleaning and formatting for xlsx and csv files?

You can automate spreadsheet data cleaning by programmatically opening, reading, and editing xlsx, xlsm, csv, and tsv files to fix malformed rows and restructure messy data into well-formatted spreadsheets ready for analysis.

What is the best way to convert csv to xlsx while preserving data types?

The best way to convert csv to xlsx is by using programmatic libraries that transform tabular file formats while preserving data integrity and types, ensuring your structured data exports accurately without formatting loss.

Can I add formulas and charts to an existing xlsx file through automation?

Yes, you can add formulas and charts to existing xlsx files through automation by programmatically editing the spreadsheet to apply new calculations, format columns, and generate visual charts directly within the file.

How do I fix malformed rows and header issues in messy spreadsheet data?

To fix malformed rows and header issues in messy spreadsheet data, you can automate data restructuring workflows that clean junk data and normalize headers, transforming chaotic inputs into well-structured tabular formats.

Does spreadsheet automation support xlsm files with macros and tsv formats?

Yes, spreadsheet automation supports xlsm and tsv formats, allowing you to open, read, edit, and convert these files across ingestion and transformation pipelines while handling common edge cases with robust validation.

How do I create a new spreadsheet from scratch and export it to standard formats?

You can create a new spreadsheet from scratch by defining your data structure programmatically and exporting it to standard formats like xlsx or csv, delivering a final formatted spreadsheet file as the output.