skills.rest
takusaotome
takusaotomeCOMMUNITY
Explore all skills by this author β†’
GitHub

uat-testcase-generator

Generate standardized UAT test case Excel workbooks for Salesforce CRM projects.

5|4|Updated Nov 9, 2025
Search Tags:#python#acceptance criteria#excel#test cases#test documentation#uat#salesforce crm
One-click install
npx skills add https://github.com/takusaotome/claude-skills-library --skill uat-testcase-generator
Or copy as Structured Prompt for Agentβ–Ό
Please help me install this Agent Skill.
Skill: uat-testcase-generator
Source: https://github.com/takusaotome/claude-skills-library/tree/main/skills/uat-testcase-generator
Command: npx skills add https://github.com/takusaotome/claude-skills-library --skill uat-testcase-generator

SYSTEM DOCUMENTATION & REQUIREMENTS

πŸ’‘ This Skill requires pandas, openpyxl, json, argparse, and includes scripts (resource) and references (resource) and assets (resource) components.

What problem does it solve?

This skill removes the manual effort of writing consistent, complete Salesforce UAT test cases by generating a ready-to-use Excel document with the right structure and fields.

Core Features & Use Cases

  • Standardized UAT Excel output: Produces an Excel file with a β€œγ‚΅γƒžγƒͺー” sheet (category/priority counts and progress placeholders) and a β€œε…¨γƒ†γ‚Ήγƒˆγ‚±γƒΌγ‚Ήβ€ sheet (complete test case fields).
  • Salesforce-focused UAT structuring: Uses a Salesforce CRM UAT-oriented schema including test case ID, priority, category/subcategory, scenario, preconditions, steps, expected results, and measurable pass criteria.
  • Japanese field readiness: Outputs Japanese column headers and categories suitable for Japanese project documentation and review workflows.

Quick Start

Tell the skill to create UAT test cases for your Salesforce CRM project and specify the project name, requirements source, test categories, and priority rules, then provide the resulting test cases as JSON so it can generate the Excel file.

Frequently Asked Questions about uat-testcase-generator

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

FAQPage Schema
How do I generate standardized Salesforce UAT test cases in Excel?β–Ό

Yes, you can create a UAT test case Excel workbook directly from JSON data using pandas and openpyxl, producing a structured document with summary and complete test case sheets.

What fields are required for Salesforce CRM UAT test case documentation?β–Ό

Required fields for Salesforce CRM UAT test case documentation include test case ID, priority, category, subcategory, scenario, preconditions, steps, expected results, and measurable acceptance criteria.

How do I structure Excel sheets for UAT test planning and progress tracking?β–Ό

Structure UAT test planning Excel sheets by generating a summary sheet with category and priority counts plus progress placeholders, alongside a full test case sheet documenting complete testing fields.

Can I output Japanese column headers for UAT test case Excel files?β–Ό

Yes, you can output Japanese column headers for UAT test case Excel files, making them suitable for Japanese project documentation and review workflows.

What is the best way to automate test documentation generation for acceptance criteria?β–Ό

Automate test documentation generation for acceptance criteria by passing structured JSON data to a Python script that builds a formatted Excel workbook with numbered test steps and measurable pass criteria.

Do I need Python and pandas to generate UAT test case Excel documents?β–Ό

Yes, you need Python with the pandas and openpyxl libraries installed to parse structured JSON data and generate the formatted Excel workbook for UAT test cases.

Related Skills

Explore More Software Engineering Skills→
ConsiliencyConsiliency
8

spec-discovery

Parse specs to extract IDs, titles, and SHA-256 hashes into a JSON or TOON manifest.

Official
Basic
gaogg521gaogg521
33

officecli-data-dashboard

Convert CSV input into a two-sheet .xlsx workbook with a KPI Dashboard.

Community
Advanced
AlpacaLabsLLCAlpacaLabsLLC
304

product-enrich

Infer and standardize FF&E product category, color, material, and style tags from CSV or Google Sheets inputs.

Official
Advanced
wuzinongwuzinong

behavior driven test

Transform user stories and acceptance criteria into executable Gherkin BDD scenarios.

Community
Advanced