Workday Table Exporter

WHAT IT DOES

Workday Table Exporter scans Workday report tables and extracts structured HR and financial data including row labels, values, dates, employee names, employee IDs, department, job title, employment status, amounts, and totals. The tool aggregates all visible rows from the current report page into a clean table and exports the data as CSV or JSON with one click. You can also copy the data to your clipboard as tab-separated text for pasting into spreadsheets or HR analysis tools. The tool works across all Workday report types — employee lists, headcount reports, compensation summaries, and custom reports.

WHERE IT RUNS

This userscript runs inside Workday (workday.com) in your browser, powered by the free BotGentz extension. It operates entirely on the page you are viewing — it does not send your data anywhere else. All data extraction and processing happens locally in your browser. The script works on all Workday report pages including standard reports and custom report builder views.

HOW TO USE

Install the BotGentz extension, then install this userscript from the BotGentz catalogue. Navigate to any Workday report page. The tool will automatically scan the page and show the number of rows found. Use the "Scan Page" button to manually refresh the data. Toggle "Include totals" to control whether summary rows are exported. Select which columns you want to export by toggling the checkboxes. Choose your export format (CSV or JSON) from the dropdown. Click "Export" to download the file with the current date in the filename. Click "Copy to Clipboard" to copy tab-separated data for pasting into spreadsheets.

HOW IT WORKS UNDER THE HOOD

The script uses a multi-strategy extraction approach that adapts to Workday's dynamically rendered DOM structure. It first attempts to locate report tables using selectors like table.report-table, .report-table, .wd-table, and [data-testid="report-table"]. If those fail, it scans for any table containing Workday-related keywords like employee, department, job title, status, amount, or report. The script intelligently identifies table headers from the thead or first row, and maps values to their appropriate columns. It handles dynamic column counts, detects total rows by pattern matching, and applies deduplication. The CSV export handles proper escaping of fields containing commas, quotes, or newlines. The script is designed to handle Workday's complex table structures including nested headers and multi-level column groupings.

THE PANEL

The tool runs in the BotGentz panel, a draggable floating interface that stays on top of the page. You can drag the panel by its header, collapse it to a small bubble, and resize it. The panel remembers its position per site, so it stays where you left it when you return to Workday. Press Escape to close the panel when you are done. The panel includes status indicators showing how many rows were found, a format selector, a totals toggle, and checkboxes for selecting which columns to export.

PLEASE NOTE

This tool requires the free BotGentz extension to run. Workday frequently updates its interface — if the tool stops working, check for an updated version or report the issue. All data stays in your browser and is never sent to any external server. The tool works only on the current page; to export data from multiple pages, scan each page individually. The tool extracts visible data only and cannot access data not loaded on the current page. Report data should be verified against Workday's official reports for accuracy. The tool does not bypass any access controls — you must have permission to view the report data.