skills.rest
aws-samples
aws-samplesOFFICIAL
Explore all skills by this author →
WebsiteGitHub

xlsx

Create and edit Excel workbooks from tabular data requests.

36|18|Updated Nov 23, 2025
Search Tags:#spreadsheet#xlsx#data manipulation#excel automation#formula generation#chart embedding#s3 artifacts
One-click install
npx skills add https://github.com/aws-samples/sample-aws-idp-pipeline --skill xlsx-aws-samples
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/aws-samples/sample-aws-idp-pipeline/tree/main/packages/agents/idp-agent/.skills/xlsx
Command: npx skills add https://github.com/aws-samples/sample-aws-idp-pipeline --skill xlsx-aws-samples

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires boto3, openpyxl, pandas, numpy, Pillow, matplotlib, lxml, and includes scripts (resource) components.

What problem does it solve?

This Skill removes the hassle of manually building or updating spreadsheets by generating correct, ready-to-use Excel workbooks from your request or existing tabular files.

Core Features & Use Cases

  • Create new Excel workbooks for tabular deliverables such as reports, trackers, and analysis sheets.
  • Edit and analyze existing spreadsheets by downloading from an S3 path, updating content, and uploading the updated .xlsx back to S3.
  • Ensure spreadsheet reliability by following execution guardrails (single sandbox execution, no formula error states like #REF!/etc.) and by embedding charts directly when possible.

Quick Start

Use the xlsx skill to create an Excel spreadsheet at the requested S3 location from your provided tabular requirements.

Frequently Asked Questions about xlsx

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I generate an Excel spreadsheet from raw tabular data?▼

You can generate an Excel spreadsheet by providing tabular data or requirements, which the Skill processes into a structured .xlsx workbook and uploads directly to a specified S3 path.

Can I edit an existing .xlsx file by downloading it from S3?▼

Yes, this Skill can download an existing .xlsx from an S3 path, update its content, clean messy tabular data, and upload the modified workbook back to S3.

Does this Skill support embedding charts in Excel workbooks?▼

Yes, the Skill supports embedding charts directly into Excel workbooks by using matplotlib and Pillow to generate and place visualizations within the .xlsx file.

What is the best way to clean and transform messy CSV data into a formatted report?▼

The best way to clean messy CSV data is using this Skill, which leverages pandas and numpy to transform tabular data, compute derived fields, and output a formatted .xlsx report to S3.

Are there limitations on spreadsheet formula generation to avoid broken references?▼

Yes, the Skill follows execution guardrails to guarantee zero spreadsheet formula errors in the final output, actively preventing broken reference states like #REF! in the generated workbook.

Do I need specific dependencies to automate Excel generation with Python?▼

Yes, Excel automation with this Skill relies on specific dependencies including openpyxl for workbook manipulation, pandas for data processing, and boto3 for S3 artifact uploads.

Related Skills

Explore More Data & Analytics Skills→
automate-me7automate-me7

xlsx

Prepare XLSX, XLSM, CSV, and TSV spreadsheets end-to-end.

Community
Advanced
cwstedctwcwstedctw

xlsx-author

Generate formula-driven Excel workbooks with Inputs, DCF, and Checks sheets.

Community
Intermediate
Ritabrata-ChakrabortyRitabrata-Chakraborty

matplotlib

Create and customize static and interactive data visualizations with Matplotlib.

Community
Advanced
kmshihab7878kmshihab7878
6

xlsx

Create, edit, and repair spreadsheet files into validated .xlsx workbooks.

Community
Advanced