Automates editing, cleaning, formatting and converting spreadsheet files using Python libraries like openPandas and openpyxl.
npx skills add https://github.com/xiaoshuangLi/aibo --skill xlsx-xiaoshuangli
Please help me install this Agent Skill. Skill: xlsx Source: https://github.com/xiaoshuangLi/aibo/tree/main/skills/xlsx Command: npx skills add https://github.com/xiaoshuangLi/aibo --skill xlsx-xiaoshuangli
This Skill addresses the tedious tasks of editing, cleaning, formatting, and converting spreadsheets by enabling automated, output-ready results from inputs like .xlsx, .xlsm, .csv, or .tsv.
Convert the provided input CSV to a clean, ready-to-use XLSX.
High-intent search queries and answers about installing and using this skill.
You can automate spreadsheet cleanup and convert CSV to XLSX by applying Python libraries like pandas and openpyxl to read, clean inconsistent headers, and write output files while preserving tabular structure.
The best way to apply formulas and add columns to an XLSX file is using openpyxl to read the spreadsheet, programmatically insert new columns with formula logic, and export the final formatted file.
Yes, you can convert between tabular formats like CSV, TSV, and XLSX automatically by using pandas to read the source file and export the transformed data into your desired output format.
Yes, this approach works for cleaning messy headers and restructuring spreadsheet data by leveraging pandas to normalize column names, fix inconsistencies, and reorganize rows for a final deliverable.
Limitations of using pandas and openpyxl include potential loss of complex visual formatting like charts or pivot tables, as these libraries primarily focus on cell-level data and basic formula transformations rather than advanced visual elements.
JosephWoodallProcess and transform XLSX, CSV, and TSV spreadsheets using openpyxl.
borgheiQuery SQL databases, create visualizations, and generate insights reports.
georgekhananaevCreate, edit, and analyze Excel workbooks in XLSX, XLSM, and CSV formats.
noartemOpen, read, edit, format, and convert spreadsheet files across tabular formats.
