What building pages from your data involves
Before any template is built, we agree on what counts as one record, which pages show it and where each value is edited.
A review of the current setup
On a partly built site, we start with what exists: the sheets, the import settings, the custom fields and the page templates. We follow one record through each of them to its rendered page, then report what to keep and what to change, with a reason for each.
Spreadsheet structure and record IDs
Every row gets an ID that never changes, and rows in other tabs refer to it, so a result points to its profile by ID, not by name. Where a column mixes formats or one cell holds several values, we propose the smallest change that makes the import reliable.
A template for each record type
Profiles, results, schedules, standings or product pages each get one template, so image sizes, spacing and the order of details match on every page. We test each template with a complete record, a sparse one and one with many linked rows.
Linked records and calculated figures
A profile can list its own results, and standings or rankings can be calculated from the same rows. Each total or ranking gets one agreed source, so two pages showing the same figure read it from the same place.
Imports and updates
The import matches each row to its existing page by ID, so an edited row updates that page instead of creating a new one. We agree how imports are started, what an empty cell does, and whether a removed row unpublishes its page or leaves it online.
Front-end finishing and phone layouts
Unfinished components are completed within the design direction you already have, and each template is built for phones first. Wide tables of results or statistics get a phone layout that stays readable, and every template is tested at phone, tablet and desktop widths.
Accuracy checks against the sheet
We compare the sheet with the published pages: row counts against page counts, a sample of records field by field, linked rows on the right profiles, and the effect of renamed, emptied and removed rows.
Handover for your team
You receive the data map, the import settings and short written steps for adding a record, correcting one and confirming that an import finished. They are written for whoever maintains the sheet.