dokument-xlsx

What problem does it solve?

This Skill streamlines any workflow where a spreadsheet file is the primary input or output, removing manual steps for opening, reading, editing, cleaning, converting, and producing .xlsx/.xlsm/.csv/.tsv deliverables while ensuring professional formatting and error-free formulas.

Core Features & Use Cases

• Spreadsheet creation and conversion: Build new workbooks from data sources or convert CSV/TSV files into polished Excel files with proper headers, number formats, and charts.
• Cleaning and restructuring: Repair malformed rows, fix misplaced headers, normalize types, and transform messy tabular exports into structured worksheets ready for analysis.
• Formula-first modelling and verification: Insert Excel formulas (never hardcode calculations), enforce number and color-coding conventions for financial models, and validate that no formula errors remain using LibreOffice recalculation.
• Use Case: Convert a teacher's exported grades CSV into a formatted .xlsx with calculated averages, conditional formatting, a summary sheet, and verified formulas.

Quick Start

Open 'grades.csv' and produce a formatted Excel workbook with formulas for averages, validated number formats, and a summary chart.