Clean, transform, and convert .xlsx, .xlsm, .csv, and .tsv spreadsheets.
npx skills add https://github.com/RUSHYOP/imperium-cli --skill xlsx-rushyop
Please help me install this Agent Skill. Skill: xlsx Source: https://github.com/RUSHYOP/imperium-cli/tree/main/content/skills/xlsx Command: npx skills add https://github.com/RUSHYOP/imperium-cli --skill xlsx-rushyop
Use this skill to automate a wide range of spreadsheet tasks when a spreadsheet is the primary input or output. It covers opening, reading, editing, cleaning, formatting, and converting .xlsx, .xlsm, .csv, and .tsv files; it can create new spreadsheets from scratch or from other data sources and even convert between tabular formats. Trigger especially when a user references a spreadsheet by name or path (for example, "the xlsx in my downloads") and wants something done to it or produced from it. It also handles cleaning or restructuring messy tabular data into proper spreadsheets, ensuring the deliverable is a valid spreadsheet file.
Provide a sample spreadsheet and ask the skill to clean, transform, or convert it, then save the result as a new spreadsheet file.
High-intent search queries and answers about installing and using this skill.
To clean messy spreadsheet data, this skill restructures misplaced headers and removes junk rows, transforming unstructured tabular inputs into well-formed spreadsheets. It processes .xlsx, .xlsm, .csv, and .tsv files to ensure data integrity for downstream workflows.
Yes, you can convert CSV to XLSX while computing and maintaining formulas. This skill handles format conversion between tabular formats, ensuring the deliverable is a valid spreadsheet file with zero formula errors and preserved data integrity.
Automating spreadsheet transformation is best handled by applying scripts that open, read, edit, and format .xlsx, .xlsm, .csv, and .tsv files. This skill uses openpyxl and lxml to automate end-to-end spreadsheet tasks, including data cleaning and format conversion.
Yes, openpyxl supports creating new spreadsheets from scratch or by importing data from other sources. This skill leverages openpyxl to generate valid spreadsheet files, applying formatting and computing formulas while ensuring zero formula errors during the file creation process.
Spreadsheet format conversion can result in formula errors if the source data is unstructured or contains unsupported formatting. This skill prevents these issues by cleaning and restructuring messy tabular data before conversion, ensuring the output maintains strict data integrity and zero formula errors.
Yes, automating spreadsheet tasks requires Python dependencies like lxml, defusedxml, openpyxl, and validators. These libraries enable the skill to securely parse XML structures, open spreadsheet files, validate data, and perform format conversion without compromising data integrity.
zebbernAutomate spreadsheet cleaning, formatting, and conversion between .xlsx, .xlsm, .csv, and .tsv files.
albertdobmeyerProcess CSV, TSV, JSON, and JSON Lines files into cleaned, transformed, and summarized outputs.
SoftSystemsStudioCreate, edit, and validate Excel workbooks with formulas using openpyxl.
vuralserhat86Design and implement ETL/ELT pipelines with SQL, dbt, Python, and Airflow.
