Openclaw Skills turns raw ESG data into validated, standards-aligned reports with charts and PDF/HTML export.
Install & Download
1. ClawHub CLI
The fastest way to install a skill directly from the registry.
npx clawhub@latest install skill-esg-report-compiler
2. Manual Installation
Copy the skill folder to one of these locations
~/.openclaw/skills/ <project>/skills/ Priority: Workspace > Local > Bundled
3. Prompt Installation
Copy this prompt to OpenClaw to install it automatically.
Help me install skill-esg-report-compiler using Clawhub. If Clawhub is not installed, install it first (npm i -g clawhub).
Prefer to download?
Get the raw skill files in a ZIP archive.
What is ESG Report Compiler?
Openclaw Skills for ESG reporting turns fragmented sustainability data into a clean, repeatable workflow for enterprise disclosure. It helps teams move from raw CSV or Excel inputs to structured JSON, standard-aware validation, visual analysis, and polished report export.
Use this skill when you need to compile annual ESG reports, prepare GRI or TCFD disclosures, compare ESG performance across periods, or package results into PDF and HTML formats for stakeholders. The pipeline is designed for practical reporting operations, with strong data-quality checks and clear CLI-driven steps.
ESG Report Compiler Use Cases
- Building a first annual ESG report from scratch with a template-driven workflow.
- Validating ESG datasets against GRI, TCFD, or SASB requirements before publication.
- Analyzing quarterly ESG performance and comparing it with industry benchmarks.
- Generating stakeholder-ready PDF or HTML sustainability reports from structured source data.
- Converting scattered CSV or Excel ESG inputs into a normalized, report-ready dataset.
How ESG Report Compiler Works
The Openclaw Skills workflow follows a deterministic reporting pipeline:
- Collect ESG source data from CSV or Excel and normalize it into structured JSON with
esg_data_collector.py. - Validate the normalized dataset with
esg_validator.pyto detect missing indicators, range issues, inconsistencies, and completeness gaps. - Generate ESG charts with
esg_visualizer.py, including composition, trend, radar, and benchmark views. - Export the final deliverable with
esg_exporter.pyin PDF or HTML format, passing the company name for branded output. - Review validation results, correct any source-data issues, and rerun the pipeline until the disclosure is ready.
ESG Report Compiler Setup
Openclaw Skills is Python-based and expects Python 3.9+ with pandas, matplotlib, and reportlab installed.
- Create and activate a virtual environment.
python3 -m venv .venv
source .venv/bin/activate
- Install the required dependencies.
pip install pandas matplotlib reportlab
- Generate the starter ESG template for first-time use.
python scripts/esg_data_collector.py --generate-template --output references/esg_data_template.csv
Prepare your ESG source file in CSV or Excel format and keep the template indicator IDs unchanged.
Run the workflow scripts in order: collect, validate, visualize, export.
python scripts/esg_data_collector.py --input data/esg_input.csv --output data/esg_structured.json
python scripts/esg_validator.py --input data/esg_structured.json --standard GRI
python scripts/esg_visualizer.py --input data/esg_structured.json --output-dir output/charts
python scripts/esg_exporter.py --input data/esg_structured.json --output output/esg_report.pdf --format pdf --company Example Enterprise
ESG Report Compiler Data Schema & Taxonomy
Core data flow
| Layer | File / Output | Purpose | Key notes |
|---|---|---|---|
| Input sources | CSV, Excel | Raw ESG metrics and disclosure data | Must be mapped to the template structure |
| Template | references/esg_data_template.csv |
Canonical starter schema | Indicator IDs are immutable and drive data mapping |
| Structured dataset | JSON | Normalized records used downstream | Produced by esg_data_collector.py |
| Validation report | Errors, warnings, completeness score | Completeness and compliance output | Generated by esg_validator.py for GRI, TCFD, or SASB |
| Visual assets | Chart output directory | Bar, pie, radar, trend, and benchmark charts | PNG is preferred, with SVG fallback if needed |
| Final report | PDF or HTML | Branded ESG disclosure deliverable | Requires company name at export time |
Metadata taxonomy
indicator_id: Stable identifier used for mapping, validation, and cross-script consistency.standard: Reporting framework selected for checks, such as GRI, TCFD, or SASB.company: Entity name shown in the final exported report.period: Reporting window, such as annual or quarterly.quality_flags: Error and warning markers produced by validation.visual_type: Chart family generated for the dataset.
Reference resources
references/gri_standards.mdfor GRI-aligned disclosure logic.references/tcfd_framework.mdfor climate-related reporting guidance.references/esg_data_template.csvfor the canonical input template and indicator definitions.
Schema rules
- Do not modify template indicator IDs.
- Validate before visualization to avoid publishing low-quality charts.
- Keep the structured JSON as the source of truth for downstream steps.
ESG Report Compiler Advanced Features
- Standards-aware mapping across GRI, TCFD, and SASB workflows.
- Validation-first pipeline that surfaces missing indicators, range issues, cross-metric inconsistencies, and completeness scores before export.
- Multi-format publishing to PDF and HTML from the same normalized dataset.
- Visualization toolkit with bar charts, composition pies, radar charts, trend lines, and industry benchmark comparisons.
- Template generation for first-time data onboarding with immutable indicator IDs.
- Chinese-font-friendly chart generation, plus SVG fallback when PNG rendering is unavailable.
- TRACE five-dimensional self-assessment support introduced in version 1.1.0.
- Openclaw Skills integrates cleanly into automation-friendly CLI pipelines for batch reporting and internal tooling.
SKILL.md
Loading
Related Openclaw Skills
Drawing Diff Analyzer
Openclaw Skills' Drawing Diff Analyzer compares 2D engineering drawings with 3D models, detects dimension and outline mismatches, and generates review-ready JSON and Markdown reports.
Emergency Plan Builder
Builds structured, executable emergency response plans from scenario inputs, using a template-driven workflow for roles, alerts, response, and recovery.
Complaint Quality Analysis
Openclaw Skills standardizes complaint data, surfaces recurring quality issues, and generates management-ready HTML and Markdown reports.
DOE Experiment Design Skill
Generates standard DOE experiment plans—full factorial and fractional factorial—with configurable factors, levels, resolution, and CSV export.
FMEA Analysis Assistant
Guides FMEA 2019 workflows with RPN calculation, risk ranking, and mitigation tracking for DFMEA, PFMEA, and SFMEA.
ISO14001 EMS Planning
An Openclaw Skills workflow that helps you scope, design, and document an ISO14001:2026-aligned environmental management system.
Featured*
