skills.rest
canvascoding
canvascodingCOMMUNITY
Explore all skills by this author →
Website𝕏@frankmaaanGitHub

xlsx

Clean, format, and convert spreadsheet files across .xlsx, .xlsm, .csv, and .tsv formats.

10|2|Updated Jan 12, 2026
Search Tags:#automation#pandas#openpyxl#spreadsheet#xlsx#data-cleaning#format-conversion
One-click install
npx skills add https://github.com/canvascoding/canvas-notebook --skill xlsx-canvascoding
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/canvascoding/canvas-notebook/tree/main/seed_skills/xlsx
Command: npx skills add https://github.com/canvascoding/canvas-notebook --skill xlsx-canvascoding

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires defusedxml, lxml, and includes scripts (resource) components.

What problem does it solve?

Use this skill any time a spreadsheet file is the primary input or output. This includes tasks like opening, reading, editing, or fixing existing .xlsx, .xlsm, .csv, or .tsv files (e.g., adding columns, computing formulas, formatting, charting, cleaning messy data); creating a new spreadsheet from scratch or from other data sources; or converting between tabular formats. Trigger especially when the user references a spreadsheet file by name or path — even casually (like "the xlsx in downloads") — and wants something done to it or produced from it. Also trigger for cleaning or restructuring messy data to produce a proper spreadsheet output. The deliverable must be a spreadsheet file. Do NOT trigger when the primary deliverable is a Word document, HTML report, standalone Python script, database pipeline, or Google Sheets API integration, even if tabular data is involved.

Core Features & Use Cases

  • Open, read, edit, format, and convert spreadsheet files across .xlsx, .xlsm, .csv, and .tsv formats.
  • Create new spreadsheets from data sources or transform messy tabular data into clean, well-structured files.
  • Convert between tabular formats (e.g., CSV to XLSX) and apply deterministic formulas using openpyxl/pandas as needed.
  • Real-world scenario: you have a messy CSV you want converted to XLSX with formulas and formatting preserved.

Quick Start

Open a spreadsheet file and perform cleaning, formatting, and format-conversion tasks in one step.

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 format conversion for multiple file types?▼

Automating spreadsheet data cleaning and format conversion is handled by processing .xlsx, .xlsm, .csv, and .tsv files using pandas and openpyxl. This ensures deterministic operations for opening, editing, and creating tabular files while applying formulas and formatting.

Can I convert a messy CSV to XLSX while preserving formulas and formatting?▼

Converting a messy CSV to XLSX with formulas and formatting preserved is fully supported. The workflow cleans and restructures the raw tabular data, applying deterministic formulas via openpyxl and pandas to output a well-structured spreadsheet file.

Does this openpyxl and pandas workflow support macro-enabled spreadsheet files?▼

Macro-enabled spreadsheet files (.xlsm) are supported for opening, reading, editing, and formatting tasks. You can process .xlsm inputs alongside standard .xlsx, .csv, and .tsv files to automate data restructuring and formula recalculation.

What is the best way to create a new spreadsheet from other data sources?▼

Creating a new spreadsheet from other data sources is achieved by transforming and cleaning messy tabular data into a proper spreadsheet output. This workflow uses pandas and openpyxl to structure the data deterministically into a new .xlsx or .csv file.

When should I not use an automated spreadsheet formatting approach?▼

Automated spreadsheet formatting should not be used when the primary deliverable is a Word document, HTML report, standalone Python script, database pipeline, or Google Sheets API integration. This workflow is strictly restricted to producing spreadsheet file outputs.

Related Skills

Explore More Data & Analytics Skills→
ChenYCLChenYCL

xlsx

Create, read, edit, and analyze Excel spreadsheet files with openpyxl and pandas.

Community
Intermediate
tiankong0101-bytetiankong0101-byte

minimax-xlsx

Create, read, and analyze XLSX spreadsheet data for tabular workflows.

Community
Intermediate
loganylchenloganylchen

spreadsheet

Create, edit, analyze, and visualize .xlsx, .csv, and .tsv spreadsheets with Python.

Community
Intermediate
iredrion-imgiredrion-img

xlsx

Clean, transform, and format Excel, CSV, and TSV files with openpyxl.

Community
Intermediate