Excel Data Transformer

📁

Drop your Excel file here or click to select

Supports .xlsx and .xls files • File is processed locally in your browser

Column Mapping Configuration

Map your source file columns to the target Elker import template fields. Select the appropriate source column for each target field.

Presets:

Parse timestamp-separated content

Where no file upload date is found, use the report submission date

Author Field Replacements (Find & Replace)

▼

Define text replacements for Author fields (e.g., convert names to emails, fix misspellings like "Whistleblower"). Applied to Message_Author, Case_Note_Author, Report_Assignees, etc.

Find	Replace with	Action

Status Change Configuration

▼

Rename status values and optionally add a final "Closed" status change for each report.

Status Name Remapping

Rename status values from the source data (e.g., "New" → "Pending"). Applied to Status_Changed_To values.

Source Status	Rename To	Action

Initial Status

Set initial "from" status for each report

Status Pattern Extraction

Extract status changes from text column

Auto-Close Reports

Add final "Closed" status change for each report

Report Field Validation Rules

▼

Configure which Report Attribute fields should be validated after transformation. Choice fields are pre-populated with their expected values from the Elker system.

On	Field	Kind	Expected Values	Wildcard	Allow Blank

Value Replacement Rules

Define find-and-replace rules that are applied automatically after transformation. These are saved with presets.

Field	Find Value	Replace With	Action