xlsx

Name: xlsx
Availability: InStock
Author: novolei

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

Ready to run

npx skills add https://github.com/novolei/if2Ai --skill xlsx-novolei

💬 Prompt for ChatGPT / Claude Chat▼

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.