skills.rest
novolei
novoleiCOMMUNITY
Explore all skills by this author →
GitHub

xlsx

Clean and transform CSV, TSV, and XLSX data into formatted XLSX workbooks.

Updated Apr 14, 2026
Search Tags:#formatting#formulas#xlsx#data-transformation#data-cleaning#data-wrangling#csv-to-xlsx
One-click install
npx skills add https://github.com/novolei/if2Ai --skill xlsx-novolei
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/novolei/if2Ai/tree/main/src-tauri/resources/bundled-skills/xlsx
Command: npx skills add https://github.com/novolei/if2Ai --skill xlsx-novolei

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This skill streamlines the process of opening, cleaning, transforming, and converting tabular data into high-quality Excel workbooks, reducing manual toil and errors.

Core Features & Use Cases

  • Open and read data from .xlsx, .xlsm, .csv, and .tsv files, and write back to .xlsx format.
  • Clean and restructure data (fix headers, handle missing values, deduplicate rows, normalize formats), apply formulas, format cells, and generate charts.
  • Convert between tabular formats (CSV to XLSX, TSV to XLSX, XLSX to CSV) and prepare data for reporting.
  • Use Case: you have a messy CSV dump with inconsistent headers; run this skill to normalize headers, fill missing values, and export a clean XLSX ready for analysis.

Quick Start

Load a messy dataset (e.g., data.csv), clean it, and save as output.xlsx.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I convert CSV to XLSX and clean messy data headers automatically?▼

To convert CSV to XLSX and clean data, load your messy dataset and the skill normalizes headers, fills missing values, deduplicates rows, and exports a polished .xlsx file ready for analysis.

What is the best way to prepare a CSV dump for Excel reporting and dashboards?▼

The best way to prepare a CSV dump for Excel reporting is to run it through a data cleaning and transformation workflow that normalizes formats, applies formulas, formats cells, and saves as a polished XLSX output.

Can I apply Excel formulas and format cells when converting TSV files to XLSX?▼

Yes, you can apply Excel formulas and format cells when converting TSV files, because the skill computes formulas and applies formatting during the deterministic export process to generate a .xlsx file.

Does this data transformation process support reading and converting .xlsm files?▼

Yes, the data transformation process supports reading .xlsm files alongside .xlsx, .csv, and .tsv inputs, allowing you to open, clean, and restructure the data before writing back to a standard .xlsx format.

How do I consolidate data and fix inconsistent formats in a spreadsheet workflow?▼

To consolidate data and fix inconsistent formats in a spreadsheet workflow, the skill executes reproducible steps to open, read, clean, compute formulas, format, and save data to a polished spreadsheet.

When do I need to use a dedicated data wrangling workflow for spreadsheet preparation?▼

You need a dedicated data wrangling workflow for spreadsheet preparation when you have raw tabular data dumps with inconsistent headers, missing values, or mixed formats that require cleaning before reporting.

Related Skills

Explore More Data & Analytics Skills→
GayanKavindaGayanKavinda

xlsx

Create, edit, and repair spreadsheet files from raw tabular data.

Community
Advanced
h4vzzh4vzz
33

report-generation

Generate data-driven reports from JSON, CSV, or API payloads.

Community
Advanced
AlterLab-IEUAlterLab-IEU
58

alterlab-xlsx

Automate spreadsheet cleaning, formatting, and conversion between .xlsx, .csv, and .tsv files.

Community
Advanced
xiechyxiechy
3

dask

Parallelize pandas and NumPy workflows with Dask DataFrames and Arrays.

Community
Intermediate