daten-aufbereiten

Clean CSV and spreadsheet files into analysis-ready tables with a change log.

Updated Jul 8, 2026
One-click install
npx skills add https://github.com/CeeKay1901/pilot-skillmarkt --skill daten-aufbereiten
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: daten-aufbereiten
Source: https://github.com/CeeKay1901/pilot-skillmarkt/tree/main/skills/daten-aufbereiten
Command: npx skills add https://github.com/CeeKay1901/pilot-skillmarkt --skill daten-aufbereiten

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill removes the repetitive cleanup work that blocks analysis when spreadsheets and CSV exports are messy, inconsistent, or incomplete. It helps you turn raw tables into reliable data without overwriting the original file.

Core Features & Use Cases

  • Duplicate removal: Detects and removes duplicate rows using a clear rule, then records what changed.
  • Format standardization: Harmonizes dates, numbers, currency values, and text categories into consistent analysis-ready formats.
  • Missing-value handling: Marks empty required fields instead of guessing, so gaps stay visible and auditable.
  • Use case: Prepare an exported sales table before reporting by cleaning duplicates, normalizing dates and currencies, and producing a revised file with a change log.

Quick Start

Clean the attached CSV or Excel file, keep the original unchanged, and return a new analysis-ready version with a short log of every cleanup step.

Frequently Asked Questions about daten-aufbereiten

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

FAQPage Schema
How do I clean messy CSV data and remove duplicates before analysis?

To clean messy CSV data, this Skill removes duplicate rows, standardizes formats for dates and currencies, and marks missing required fields. It processes your exported spreadsheet into an analysis-ready table while preserving the original file and generating a change log.

What is the best way to standardize formats in an Excel workbook for reporting?

The best way to standardize formats in an Excel workbook is to apply deterministic cleanup rules that harmonize dates, numbers, and text categories. This Skill normalizes inconsistent data into a consistent reporting format without overwriting your original file.

Can I prepare exported business data for analysis without losing the original file?

Yes, you can prepare exported business data without losing the original file. This Skill preserves your source spreadsheet untouched and returns a new analysis-ready version alongside a change log that records every modification made during the data cleaning process.

How does missing-value handling work when preprocessing spreadsheets for data analysis?

Missing-value handling marks empty required fields instead of guessing values, so data gaps stay visible and auditable. This approach ensures your cleaned spreadsheet maintains integrity for downstream analysis without introducing fabricated data.

Does this data cleaning approach work with both CSV and Excel files?

Yes, this data cleaning approach works with both CSV exports and Excel workbooks. It applies deterministic cleanup rules to tabular files, removing duplicates and normalizing formats to produce a revised file ready for analysis or reporting.