Choose suitable libraries for converting spreadsheet data and image files, or extracting text and tables from documents. Covers supported format pairs and identifies conversions unavailable in the described environment before work begins.
Use this skill when the user asks to convert a file from one format to another (e.g. csv to xlsx, xlsx to json, pdf text to csv) and you're not sure which library handles that specific pair, or whether it's supported in this environment at all. Dispatches to the right library per format pair and explicitly lists conversions that are NOT supported here so you don't attempt one that will silently fail or produce a wrong result.
Review the instructions the agent will receive before you install.
| From | To | Default (Node) | Fallback (Python) |
|---|---|---|---|
| csv | xlsx / json / html | papaparse (parse to array of objects) → exceljs (xlsx) / JSON.stringify (json) / a hand-rolled <table> loop (html — no library needed for this) | pandas.read_csv → .to_excel / .to_json / .to_html — reach for this when the conversion needs real reshaping (pivots, group-by, dtype coercion) along the way, not as a first choice |
| xlsx | csv / json / html | exceljs (read) → papaparse.unparse (csv) / JSON.stringify (json) / hand-rolled html | pandas.read_excel → .to_csv / .to_json / .to_html |
| json (tabular/list-of-records shape) | csv / xlsx | JSON.parse → papaparse.unparse (csv) / exceljs (xlsx) | pandas.read_json → .to_csv / .to_excel |
| image (png/jpg/webp/etc.) | different image format, resize, basic edits | sharp (.toFormat(...), .resize(...)) | Pillow (Image.open(...).save(new_path)) |
| docx | plain text | — (no solid Node equivalent for structured docx parsing) | python-docx / docx2python — extract paragraph and table text |
| plain text / csv (tables) | — (no solid Node equivalent for table-aware extraction) | pdfplumber — extract_text() / extract_tables() → build a DataFrame if tabular |
For plain csv/xlsx/json reshuffling, default to the Node path (an array of plain objects is the common intermediate, playing the same role pandas.DataFrame plays on the Python side) per this environment's Node-first policy — reach for pandas only when the conversion needs real data reshaping along the way. docx/pdf extraction and structure-aware parsing have no solid Node equivalent here, so those stay Python regardless of format on the other end.
These all require a document-rendering engine (LibreOffice) that is not installed in the sandbox yet. Tell the user directly rather than attempting a workaround (e.g. do not try to fake a "pdf" by screenshotting text, and do not claim success on a conversion you didn't actually perform):
docx → pdfpptx → pdfdoc (legacy binary Word format) → docxxlsx → pdfIf the user's underlying goal is "get the numbers out of this PDF/docx into a spreadsheet" rather than literally "convert this file", extracting the relevant data and writing exactly the columns/rows they need is usually a better outcome than a generic whole-file conversion — ask yourself which one they actually need before picking an approach.
No reviews yet. Tell others what you thought.
No login needed. Share how it worked for you, ask a question, or note where it did not run.
No comments yet. Be the first to write one.
Build or extend a PipesHub connector, an integration that syncs content from an external service or database. The skill guides API research, design decisions, permission mapping, implementation, testing, and documentation of what was actually verified.
Load, clean, summarize, and join tabular data from CSV, Excel, JSON, or database exports using pandas. Check missing values, data types, and row counts, then independently verify key figures before reporting numbers printed by the code.
Turn data into charts suited to comparisons, trends, distributions, relationships, or shares. Add clear titles, units, and accessible colors, then export a static PNG or interactive HTML with hover details and zoom controls.
Create Word reports, memos, letters, and proposals with headings, tables, lists, and a table of contents. Also supports targeted edits to existing .docx files and reading or summarizing their text and tables.
Unpack Word and PowerPoint files to inspect and edit their internal XML, the markup that stores document content. Repack targeted changes with XML syntax checks while preserving the original archive entry order.
Create PDF reports, invoices, and letters, extract text or tables from existing PDFs, and fill interactive form fields. The skill also guides table layout, text wrapping, and page breaks so generated documents fit their pages.