Import
chevron_right
Mapping
Map columns
Sample data
description
stonewater_planned_works_upload.xlsx
1,248 rows found
Auto-matched
38
Needs review
3
Column mapping
File → Ara| File column | Status | Ara field |
|---|---|---|
|
Asset Ref
e.g. 100245
|
check_circle | |
|
Works Order Number
e.g. WO-23881
|
check_circle | |
|
Address Line 1
e.g. 12 High St
|
check_circle | |
|
Postcode
e.g. SW1A 1AA
|
check_circle | |
|
warning
Work Type
e.g. Bathroom Programme
|
help | |
|
Contractor Name
e.g. Contractor A
|
check_circle | |
|
warning
Status
e.g. Assigned
|
help | |
|
Forecast Start
e.g. 2026-07-01
|
check_circle | |
|
Forecast End
e.g. 2026-07-15
|
check_circle | |
|
warning
Priority
e.g. Yes
|
help |
account_tree
Complete column mapping to map cell values
Workstream value mapping
Mapping distinct values from the Work Type column
| File value | Status | Ara workstream |
|---|---|---|
|
Window Programme
240 rows
|
check_circle | |
|
Door Replacement
180 rows
|
check_circle | |
|
Roofing Works
72 rows
|
check_circle | |
|
Cyclical Decorations
194 rows
|
check_circle | |
|
Kitchen Programme
210 rows
|
check_circle | |
|
Bathroom Programme
warning
195 rows
|
help | |
|
Asbestos Removal
44 rows
|
check_circle | |
|
Electrical Heating Works
96 rows
|
check_circle |