Format Converter

😫 The Pain Point

CRM exports CSV. Boss accepts Excel. Developers send JSON. You are stuck in the middle converting formats. And Excel often messes up foreign characters (UTF-8) when opening CSVs directly.

🚀 Agentic Solution

The Swiss Army Knife: Takes any data format in, spits any data format out.

Key Features:

• Encoding Fix: Handles UTF-8 (Asian characters/Emojis) correctly where Excel fails.
• Batch: Converts entire folders.

⚔️ Phase 1: Commander (Quick Fix)

For a single file conversion.

Prompt:

“Convert this data.json to an Excel file data.xlsx using Pandas.”

Result: Converted file.

🏗️ Phase 2: Architect (Permanent Tool)

For Data Coordinators.

Engineering Prompt:

**Role:** Python Data Developer
**Task:** Create a "Universal Data Converter" App.
**Requirements:**
1.  **GUI:**
    *   Select Input Files (Limit to .csv, .json, .xlsx, .xml).
    *   Select Output Format (Radio: To Excel, To CSV, To JSON).
    *   "Convert" button.
2.  **Logic:**
    *   Use Pandas to ingest data (auto-detect format).
    *   Export to target format.
    *   *Tip:* Enforce `encoding='utf-8-sig'` for CSVs to ensure compatibility with Microsoft Excel.
3.  **Deliverables:** `data_converter.py`, `run.bat` (Windows), `run.sh` (Mac).

🧠 Prompt Decoding

• UTF-8-SIG: A specialized encoding that adds a “Signature” (BOM) to the file. This tells Excel “Hey, this is UTF-8”, preventing it from looking like scrambled characters. Critical for non-English data.

🛠️ Instructions

1. Copy Prompt -> Paste -> Run.
2. Select Input -> Select Target -> Convert.