# Format Data To Copy Paste Tables

> How to use AI as an instant ETL engine to parse messy raw text, emails, and receipts into clean, spreadsheet-ready TSV/CSV tables.

- Skill: `alivirgo/format-data-to-copy-paste-tables` (Agent Skill)
- Install (CLI): `npx skillmds@latest add alivirgo/format-data-to-copy-paste-tables`
- Raw SKILL.md: https://api.skillmd.com/api/skills/alivirgo/format-data-to-copy-paste-tables/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Data & Analytics
- Author: alivirgo (https://skillmd.com/u/alivirgo)
- Updated: 2026-09-17
- Page: https://skillmd.com/skills/alivirgo/format-data-to-copy-paste-tables

---


# Format Unstructured Data into Copy-Paste Tables (AI Skill)

## Overview
Manually copying and pasting names, dates, amounts, and notes from 50 different emails or receipt PDFs into Excel or Google Sheets is tedious, error-prone manual labor.

The **Unstructured-to-Tabular ETL Protocol** transforms raw, chaotic text dumps into clean, standardized, copy-pasteable **TSV (Tab-Separated Values)** or **Markdown tables** in seconds.

---

## The Unstructured-to-Tabular ETL Pipeline

```
┌─────────────────────────────────────────────────────────────┐
│                 Unstructured-to-Table Pipeline              │
│                                                             │
│  [ RAW UNSTRUCTURED TEXT / INVOICES / CHAT LOGS ]           │
│  "Paid John $450 on June 12 for logo design via PayPal..."  │
│                           │                                 │
│                           ▼                                 │
│  [ AI PARSER & SANITIZATION ENGINE ]                        │
│  • Standardize Dates $\rightarrow$ `YYYY-MM-DD`             │
│  • Clean Currency $\rightarrow$ Clean Float / Integer       │
│  • Normalize Categories $\rightarrow$ Fixed Enum List       │
│                           │                                 │
│                           ▼                                 │
│  [ TSV / MARKDOWN TABLE: 1-Click Direct Paste into Excel ]  │
└─────────────────────────────────────────────────────────────┘
```

---

## Master Data Formatting Prompt Templates

### Pattern 1: The Direct 1-Click Excel TSV Converter
Outputs text separated by tabs (`\t`), allowing you to copy the block and hit `Ctrl + V` directly into Excel or Google Sheets with zero import wizard hassle:

```markdown
Here is messy unstructured text:
[PASTE MESSY DATA]

Task:
Extract and normalize this into a TSV (Tab-Separated Values) code block with these exact columns:
1. `Date (YYYY-MM-DD)`
2. `Vendor / Person`
3. `Category (Design / Development / Marketing / Operations)`
4. `Amount (USD Number Only)`
5. `Status (Paid / Pending)`

Rules:
- Output ONLY the raw TSV code block.
- Format numbers cleanly (no `$` signs or commas in the number column so math formulas work in Excel).
```

---

### Pattern 2: The Customer Feedback Categorization Matrix

```markdown
Convert these customer feedback snippets into a Markdown table:
[PASTE CUSTOMER REVIEWS]

Columns:
| Customer ID | Sentiment (Positive/Neutral/Negative) | Primary Feature Mentioned | Core Friction Point | Actionable Recommendation |
```

---

## Real-World Case Study

### Scenario: Parsing Freelance Expense Receipts

#### Raw Unstructured Text Dump
> *"Spent $120 on Figma subscription on 05/10/24. Also bought domain from Namecheap for $14.50 on May 11th. Paid Sarah $800 on May 14 for landing page copy. AWS bill was $245.80 on May 31."*

#### AI Tabular Extraction (Markdown & TSV Ready)

```markdown
| Date | Vendor | Category | Amount ($) | Description |
| :--- | :--- | :--- | :--- | :--- |
| **2024-05-10** | Figma | Software / SaaS | 120.00 | Monthly team design subscription |
| **2024-05-11** | Namecheap | Infrastructure | 14.50 | Domain name registration |
| **2024-05-14** | Sarah | Contractor | 800.00 | Landing page copywriting deliverable |
| **2024-05-31** | AWS | Hosting | 245.80 | Cloud infrastructure monthly bill |
```

---

## 3 Secrets for Flawless Spreadsheet Pasting
1. **Request TSV over CSV**: When pasting into Google Sheets, copying TSV from a markdown code block pastes instantly across cells without triggering comma-split bugs in addresses or notes.
2. **Enforce ISO Dates (`YYYY-MM-DD`)**: Prevents US/UK date format confusion (`05/06` vs `06/05`).
3. **Strip currency symbols from numeric columns**: Keeps numbers formatted as pure digits (`120.00` instead of `$120.00`) so spreadsheet `=SUM()` formulas work instantly.