Format Markdown Table

by maslennikov-ig

data

Generate well-formatted markdown tables from data with proper alignment and spacing. Use for report statistics, comparison tables, or summary data presentation.

Skill Details

Repository Files

2 files in this skill directory


name: format-markdown-table description: Generate well-formatted markdown tables from data with proper alignment and spacing. Use for report statistics, comparison tables, or summary data presentation.

Format Markdown Table

Create properly formatted markdown tables with alignment and consistent spacing.

When to Use

  • Report statistics tables
  • Comparison tables
  • Summary data presentation
  • Metric dashboards in reports

Instructions

Step 1: Receive Table Data

Accept headers and rows as input.

Expected Input:

{
  "headers": ["Column 1", "Column 2", "Column 3"],
  "rows": [
    ["Value 1", "Value 2", "Value 3"],
    ["Value 4", "Value 5", "Value 6"]
  ],
  "alignment": ["left", "center", "right"]
}

Alignment (optional):

  • left: Left-aligned (default)
  • center: Center-aligned
  • right: Right-aligned

Step 2: Calculate Column Widths

Determine maximum width for each column.

Width Calculation:

  • Include header width
  • Include all row values
  • Add padding (1 space on each side)
  • Minimum width: 3 characters

Step 3: Format Header Row

Create header row with proper spacing.

Format:

| Header 1 | Header 2 | Header 3 |

Step 4: Format Separator Row

Create separator with alignment indicators.

Alignment Indicators:

  • Left: :--- or ---
  • Center: :---:
  • Right: ---:

Format:

|----------|:--------:|---------:|

Step 5: Format Data Rows

Create data rows with consistent spacing.

Format:

| Value 1  | Value 2  | Value 3  |
| Value 4  | Value 5  | Value 6  |

Step 6: Return Complete Table

Return formatted markdown table.

Expected Output:

| Column 1 | Column 2 | Column 3 |
|----------|:--------:|---------:|
| Value 1  | Value 2  | Value 3  |
| Value 4  | Value 5  | Value 6  |

Error Handling

  • Empty Headers: Return error requesting headers
  • Empty Rows: Return warning, create table with headers only
  • Mismatched Columns: Pad short rows with empty cells
  • Invalid Alignment: Use 'left' as default, warn

Examples

Example 1: Simple Statistics Table

Input:

{
  "headers": ["Metric", "Count", "Percentage"],
  "rows": [
    ["Critical Bugs", "3", "13%"],
    ["High Bugs", "8", "35%"],
    ["Medium Bugs", "12", "52%"]
  ],
  "alignment": ["left", "right", "right"]
}

Output:

| Metric        | Count | Percentage |
|---------------|------:|-----------:|
| Critical Bugs |     3 |        13% |
| High Bugs     |     8 |        35% |
| Medium Bugs   |    12 |        52% |

Example 2: Comparison Table

Input:

{
  "headers": ["Feature", "Before", "After"],
  "rows": [
    ["Build Time", "45s", "12s"],
    ["Test Time", "2m 30s", "1m 15s"],
    ["Bundle Size", "2.3 MB", "1.8 MB"]
  ],
  "alignment": ["left", "center", "center"]
}

Output:

| Feature     | Before  |  After  |
|-------------|:-------:|:-------:|
| Build Time  |   45s   |   12s   |
| Test Time   | 2m 30s  | 1m 15s  |
| Bundle Size | 2.3 MB  | 1.8 MB  |

Example 3: Priority Distribution

Input:

{
  "headers": ["Priority", "Open", "Fixed", "Total"],
  "rows": [
    ["P0", "2", "5", "7"],
    ["P1", "5", "3", "8"],
    ["P2", "12", "8", "20"]
  ]
}

Output:

| Priority | Open | Fixed | Total |
|----------|------|-------|-------|
| P0       | 2    | 5     | 7     |
| P1       | 5    | 3     | 8     |
| P2       | 12   | 8     | 20    |

Example 4: Empty Rows (Header Only)

Input:

{
  "headers": ["Name", "Value", "Status"],
  "rows": []
}

Output:

| Name | Value | Status |
|------|-------|--------|

Validation

  • Formats headers correctly
  • Creates proper separators
  • Aligns columns as specified
  • Handles various data types (numbers, text)
  • Pads columns for consistent width
  • Handles empty rows gracefully

Supporting Files

  • examples.md: Table formatting examples (see Supporting Files section)

Related Skills

Xlsx

Comprehensive spreadsheet creation, editing, and analysis with support for formulas, formatting, data analysis, and visualization. When Claude needs to work with spreadsheets (.xlsx, .xlsm, .csv, .tsv, etc) for: (1) Creating new spreadsheets with formulas and formatting, (2) Reading or analyzing data, (3) Modify existing spreadsheets while preserving formulas, (4) Data analysis and visualization in spreadsheets, or (5) Recalculating formulas

data

Clickhouse Io

ClickHouse database patterns, query optimization, analytics, and data engineering best practices for high-performance analytical workloads.

datacli

Clickhouse Io

ClickHouse database patterns, query optimization, analytics, and data engineering best practices for high-performance analytical workloads.

datacli

Analyzing Financial Statements

This skill calculates key financial ratios and metrics from financial statement data for investment analysis

data

Data Storytelling

Transform data into compelling narratives using visualization, context, and persuasive structure. Use when presenting analytics to stakeholders, creating data reports, or building executive presentations.

data

Kpi Dashboard Design

Design effective KPI dashboards with metrics selection, visualization best practices, and real-time monitoring patterns. Use when building business dashboards, selecting metrics, or designing data visualization layouts.

designdata

Dbt Transformation Patterns

Master dbt (data build tool) for analytics engineering with model organization, testing, documentation, and incremental strategies. Use when building data transformations, creating data models, or implementing analytics engineering best practices.

testingdocumenttool

Sql Optimization Patterns

Master SQL query optimization, indexing strategies, and EXPLAIN analysis to dramatically improve database performance and eliminate slow queries. Use when debugging slow queries, designing database schemas, or optimizing application performance.

designdata

Anndata

This skill should be used when working with annotated data matrices in Python, particularly for single-cell genomics analysis, managing experimental measurements with metadata, or handling large-scale biological datasets. Use when tasks involve AnnData objects, h5ad files, single-cell RNA-seq data, or integration with scanpy/scverse tools.

arttooldata

Xlsx

Spreadsheet toolkit (.xlsx/.csv). Create/edit with formulas/formatting, analyze data, visualization, recalculate formulas, for spreadsheet processing and analysis.

tooldata

Skill Information

Category:Data
Last Updated:11/11/2025