xlsx

Fix and automate spreadsheet data preparation across XLSX, XLSM, CSV, and TSV formats.

1|2|Updated Feb 28, 2026
One-click install
npx skills add https://github.com/zhangdszq/vk-skills --skill xlsx-zhangdszq
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/zhangdszq/vk-skills/tree/main/xlsx
Command: npx skills add https://github.com/zhangdszq/vk-skills --skill xlsx-zhangdszq

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This skill helps users automate spreadsheet work when a spreadsheet is the primary input or output. It enables opening, reading, editing, and fixing existing files in formats such as .xlsx, .xlsm, .csv, and .tsv; it also supports creating new spreadsheets and converting between tabular formats. It triggers particularly when the user references a spreadsheet by name or path and wants something produced from it or updated.

Core Features & Use Cases

  • Open, read, and modify existing spreadsheets; apply formulas and formatting; and generate clean outputs.
  • Create new spreadsheets from structured data or other sources, and convert between CSV, TSV, and Excel formats.
  • Use case: you have a messy CSV of survey results and need a fully formatted XLSX with computed columns and charts.

Quick Start

Feed the input spreadsheet and request the final formatted workbook with formulas and charts.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I clean and transform a messy CSV file into a formatted Excel spreadsheet?

Spreadsheet cleaning and transformation automates fixing messy CSV files by reading inputs in CSV or XLSX formats, applying deterministic Excel formulas, computing new columns, and outputting a final formatted workbook with charts.

Can I convert data between CSV, TSV, and XLSX formats automatically?

Yes, format conversion supports reading tabular data in CSV, TSV, XLSX, and XLSM formats, then converting and exporting the structured data into a newly generated spreadsheet while preserving original data whenever possible.

What is the best way to add computed columns and formulas to an existing XLSX file?

The best way to add computed columns is to open the existing XLSX file, apply deterministic Excel formulas using explicit cell references to calculate new values, and generate a clean, formatted output spreadsheet.

Does this spreadsheet automation approach work with XLSM and TSV files?

Yes, spreadsheet automation works directly with XLSM and TSV files, allowing you to open, read, edit, and fix existing tabular data across business, research, and education scenarios without needing external tools.

Why does my spreadsheet data preparation tool report data quality issues?

Data quality issues are reported when the spreadsheet automation encounters inconsistent or problematic entries during data cleaning and transformation, ensuring errors are flagged explicitly rather than silently corrupting the final formatted workbook.

How do I create a new spreadsheet from structured data and add formatting?

To create a new spreadsheet, feed structured data into the automation tool, request the final formatted workbook, and apply deterministic Excel formulas alongside formatting rules to produce a polished output file.