xlsx

Convert, clean, and repair spreadsheet files into valid .xlsx/.xlsm deliverables.

1|Updated Mar 21, 2026
One-click install
npx skills add https://github.com/dashkan/pivox --skill xlsx-dashkan
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/dashkan/pivox/tree/main/.agents/skills/xlsx
Command: npx skills add https://github.com/dashkan/pivox --skill xlsx-dashkan

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) components.

What problem does it solve?

This Skill removes the tedium and risk of manually cleaning spreadsheet data, repairing broken workbooks, and converting tabular files into the right Excel format for downstream use.

Core Features & Use Cases

  • Create and edit spreadsheets from scratch or from messy tabular inputs (e.g., adding columns, restructuring headers, cleaning junk rows, fixing malformed data).
  • Convert between spreadsheet tabular formats such as .csv and .tsv into .xlsx/.xlsm workflows and vice versa.
  • Ensure reliability for deliverables by requiring a spreadsheet output and (when formulas are used) running LibreOffice-based recalculation with error scanning for #REF!, #DIV/0!, #VALUE!, #NAME?, and similar issues.

Quick Start

Use the xlsx skill to repair formulas and restructure the attached spreadsheet so it becomes a valid .xlsx with zero Excel formula errors.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I convert a CSV file to xlsx while fixing formatting issues?

Converting CSV files to xlsx involves cleaning messy tabular inputs, restructuring headers, and removing junk rows to produce a valid Excel deliverable. The xlsx skill handles this conversion automatically while enforcing spreadsheet-specific correctness requirements.

How do I repair broken Excel formulas showing #REF! and #VALUE! errors?

Repairing broken Excel formulas requires recalculating the workbook to identify error states like #REF!, #DIV/0!, #VALUE!, and #NAME?. The skill uses LibreOffice-based recalculation with error scanning to ensure zero formula errors in the final xlsx deliverable.

What's the best way to clean messy spreadsheet data with malformed rows and headers?

Cleaning messy spreadsheet data involves restructuring malformed tables, fixing broken headers, and removing junk rows to produce a valid xlsx file. The skill automates this process by applying pandas-based data conversion and tabular data restructuring.

Can I use this to convert TSV files to xlsx format for downstream analysis?

Converting TSV files to xlsx format is fully supported as part of the tabular format conversion capabilities. The skill processes TSV inputs, cleans the tabular data, and outputs a corrected xlsx or xlsm file suitable for downstream spreadsheet workflows.

Does this skill validate Excel files after LibreOffice recalculation?

Excel file validation after LibreOffice recalculation is a core feature that scans for formula errors including #REF!, #DIV/0!, #VALUE!, and #NAME?. The skill enforces zero formula errors as a correctness requirement before delivering the final xlsx output.

Why do my spreadsheet formulas break after converting between tabular formats?

Spreadsheet formulas often break during format conversion due to lost cell references or incompatible formula syntax. The skill addresses this by running LibreOffice recalculation with comprehensive error scanning to detect and repair formula issues in the converted xlsx file.