format-data-to-copy-paste-tables

format-data-to-copy-paste-tables is a skill for Claude Code from alivirgo/Major-AI-Skills. It costs 28 tokens per session (1,022 once invoked), scanned A, original, MIT.

A method for turning messy text such as emails, receipts, invoices, or chat logs into clean tab-separated or comma-separated tables. The tables can be pasted into spreadsheet software.

In plain words
What is it for?
Use it to extract fields from unstructured text, standardize dates and currency values, normalize categories, and prepare data for Excel or Google Sheets.
Why use it?
It removes repetitive manual copying and makes dates, amounts, and categories more consistent.

Skill for Claude Code

Written for Claude Code: shipped in a Claude Code plugin. Also seen: mentions Codex.

Part of the major-ai-skills plugin — 147 skills, 8 plugins shipped together

Good fit Use it to extract fields from unstructured text, standardize dates and currency values, normalize categories, and prepare data for Excel or Google Sheets.

Compare 6 skills from other repositories ↓
Install with agentmods
npx agentmods add skills/alivirgo/major-ai-skills/format-data-to-copy-paste-tables
Install

Getting it into your agent

One page per mod, every tool's command on it. A separate URL per tool would split the same page into five that compete with each other.

Any agent
npx skills add alivirgo/Major-AI-Skills --skill format-data-to-copy-paste-tables
Clone the repo
git clone --depth 1 https://github.com/alivirgo/Major-AI-Skills

Made for: Claude Code.

Or install major-ai-skills, the plugin that ships this one along with the rest of its 147 skills, 8 plugins.

Wrote this? Show the measurements

A badge with what this costs and how it scanned, read live from this page, so it follows the numbers instead of freezing them. Markdown for a README, HTML for a documentation site or a project page.

agentmods badge for format-data-to-copy-paste-tables

README.md
[![agentmods](https://agentmods.dev/badge/skills/alivirgo/major-ai-skills/format-data-to-copy-paste-tables/github.svg)](https://agentmods.dev/skills/alivirgo/major-ai-skills/format-data-to-copy-paste-tables)
Your own site
<a href="https://agentmods.dev/skills/alivirgo/major-ai-skills/format-data-to-copy-paste-tables"><img src="https://agentmods.dev/badge/skills/alivirgo/major-ai-skills/format-data-to-copy-paste-tables/github.svg" alt="Measured on agentmods" height="20"></a>

Or the 80×15 button, for a site that already has a row of RSS and ATOM ones. Only the verdict fits; the numbers stay here.

agentmods 80×15 button for format-data-to-copy-paste-tables

Your own site · 80×15
<a href="https://agentmods.dev/skills/alivirgo/major-ai-skills/format-data-to-copy-paste-tables"><img src="https://agentmods.dev/badge/skills/alivirgo/major-ai-skills/format-data-to-copy-paste-tables.svg" alt="Reviewed on agentmods" width="80" height="20"></a>
Per session 28 Skills are progressive disclosure: only the name and description are preloaded; the body loads when the skill is used.
When invoked 1,022 The whole file, excluding the scripts and references it only reads on demand.
Security scan A 0 findings. A grade says what 26 rules found in the file — not that it is safe.
Origin original No closer match found in the catalogue.
Token cost

What it costs to keep this loaded

Counted locally with the o200k_base tokenizer, which is exact for GPT models; Claude uses its own tokenizer and its counts differ. Treat this as one consistent yardstick across the catalogue rather than a bill. Prices are per million input tokens.

ModelPer sessionOnce invoked
Fable 5.1 $0.00028 $0.01022
Opus 5 $0.00014 $0.00511
Sonnet 5 $0.00006 $0.00204
Haiku 4.5 $0.00003 $0.00102

Measured yesterday against content hash f5c40e7f8ba3, method: parsed. Prices are Anthropic first-party input rates as of 2026-09-12, from the pricing page.

Security

Grade A, and why

format-data-to-copy-paste-tables scanned grade A with 0 findings against 26 rules in 11 categories — prompt injection, anti-refusal, data exfiltration, privilege escalation, supply chain, agent snooping, system-prompt leakage, SSRF and excessive agency — measured yesterday.

A static scan of the body, not an audit. Every finding is printed with the line that produced it so you can judge whether it matters here. A mod is markdown that instructs an agent; that is exactly why what it instructs is worth reading.

Nothing flagged

None of the 26 patterns this scan looks for appear in this file: no shell pipes, no recursive deletes, no credential paths, no hidden text, no instruction-override or anti-refusal phrasing, no agent-config snooping. That is not a guarantee, it is the absence of the things that are checkable.

skills/format-data-to-copy-paste-tables/SKILL.md · 104 lines

How it starts

The opening of the file, as written. The whole thing — 104 lines — stays where its author put it; the contents beside it link to each section on GitHub.

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:

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).

Read the full file on GitHub · 104 lines

Changes

What this file has done since we first saw it

Hashed on every crawl. A supply-chain change to an agent config is a question of when, not whether, so the history is kept rather than the latest state alone.

  1. yesterday Changed · -11 tokens per session f5c40e7f8ba3
  2. 7d ago First seen · 104 lines · 39 tokens per session scan A a507d92b4645

Subscribe to this mod's changes

format-data-to-copy-paste-tables is a skill published in the GitHub repository alivirgo/Major-AI-Skills (1 stars, last pushed today), licensed MIT. It adds 28 tokens to every session and 1,022 once invoked, about $0.0001 per session on Opus 5. A static security scan graded it A with 0 findings. No closer match exists in the catalogue, so it is treated as the original; first seen 2026-09-05.

Related

Other skills, from other repositories

xlsx-edit

Edit or generate xlsx workbooks using either deterministic V1 office tools or a Python workbook script when higher fidelity is needed.

matingai/crab · 28 tokens

Workspace Data Analyst

Analyze CSV files in the workspace and summarize insights.

VoltAgent/voltagent · 14 tokens

fill-template

Bulk-fill ONE master template — a Word (.docx) letter/form or an Excel (.xlsx) form — from a data table, producing one filled file per row (mail-merge). Use whenever the user wants to "fill in this letter for each person", "mail merge", "generate letters for this list", "run this template over a spreadsheet", or hands…

moonlight-lupin/agent-skills · 215 tokens

people-enrichment

Enrich and search People Data Labs (PDL) Person and Company data, writing results to .xlsx. Five operations: enrich named PEOPLE into a profile, employment history and LinkedIn URL; IDENTIFY an ambiguous person as several scored candidates; SEARCH people by criteria (company, title, location); enrich COMPANIES into…

moonlight-lupin/agent-skills · 203 tokens

spreadsheet-analysis

Inspect, profile, clean, reconcile, analyze, visualize, and verify spreadsheet data while preserving formulas, formatting, types, and source files. Use when working with .xlsx, .xlsm, .xls, .ods, .csv, or .tsv files; answering questions from a workbook; auditing formulas or data quality; comparing sheets or versions…

seb1n/awesome-ai-agent-skills · 102 tokens

xlsx

Read, create, and convert Microsoft Excel (.xlsx) and CSV spreadsheets — extract sheets and tables to JSON, build workbooks from JSON/CSV, and export to PDF.

zhixuli0406/DuDuClaw · 37 tokens