Spreadsheet Export Agent Skill
CSV/Excel/PDF generation from app data, streaming large datasets, and formatting.
The Skill
Full content, every format. Copy it, download it, or install with one command.
---
description: CSV/Excel/PDF generation from app data, streaming large datasets, and formatting.
homepage: https://yepapi.com/skills/spreadsheet-export
metadata:
tags: [export, csv, excel, pdf]
---
# Spreadsheet Export
## Rules
- CSV: use `papaparse` for generation — handles escaping, delimiters, and unicode correctly
- Excel: use `exceljs` for .xlsx — supports styling, multiple sheets, formulas, and streaming
- PDF: use `@react-pdf/renderer` for React-based PDF or `pdfkit` for server-side generation
- Stream large datasets: use `exceljs` streaming writer or generate CSV row-by-row — never load entire dataset into memory
- Set proper response headers: `Content-Type: text/csv`, `Content-Disposition: attachment; filename="export.csv"`
- Date formatting: export dates in ISO 8601 or locale-aware format — never raw timestamps
- Number formatting: preserve precision, use explicit column types in Excel — avoid Excel auto-formatting numbers as dates
- Column headers: human-readable labels, not database column names — map `created_at` to `Created Date`
- Implement export as a server-side API route — client triggers download via `fetch` + `blob` + `URL.createObjectURL`
- Add progress indicator for large exports — use streaming response or background job with polling
- Limit export size: cap at a reasonable row count (50K-100K), offer background email delivery for larger datasets
## Avoid
- Building CSV by string concatenation — breaks on commas, quotes, and newlines in data
- Loading millions of rows into memory — stream from database cursor
- Synchronous PDF generation for large reports — use background jobs
- Exporting sensitive fields (passwords, tokens) — filter columns before exportInstall
Why Use the Spreadsheet Export Skill?
Without this skill, your AI guesses at spreadsheet export patterns. It might hallucinate deprecated APIs, use outdated conventions, or miss best practices entirely. With it, your AI follows a proven ruleset — every suggestion aligns with current standards.
Drop this skill into your project and your AI instantly knows the rules. Better code suggestions, fewer errors, faster shipping.
Try These Prompts
These prompts work better with the Spreadsheet Export skill installed. Your AI knows the context and writes code that fits.
"Build a CSV/Excel export feature that handles large datasets with streaming"
"Create a report generator that exports formatted Excel files with charts and styling"
"Add a data export system with column selection, date filtering, and scheduled reports"
Works Great With
Spreadsheet Export skill — FAQ
It provides CSV, Excel, and PDF generation patterns with streaming for large datasets. Your AI builds export features that handle large data volumes with proper formatting.
Run `npx skills add YepAPI/skills --skill spreadsheet-export` in your project root. This copies the skill file into your repo where your AI coding tool can read it automatically.
The skill uses streaming patterns that process rows in chunks. For CSV, it writes directly to a ReadableStream. For Excel, it uses streaming XLSX writers that flush periodically.