Load your substation file
SubRoute does not include any substation database in this version. Each user loads their own authorised CSV, Excel, JSON or clickable PDF file. The data stays in that user’s browser/device.
CSV/Excel columns accepted: Substation_Name, Substation_Number, Postcode, Latitude, Longitude. Also accepts name/number/postcode/lat/lon style headers. Excel import reads the first non-empty worksheet. PDF import works with clickable map links that contain coordinates.
File note: imports are read locally in your browser. Large PDFs can take a minute. Excel import may need an internet connection the first time so the spreadsheet reader can load. If PDF import cannot read clickable coordinates, use the CSV/Excel template instead.
Plan a route
Paste the substation names and numbers, then let SubRoute order them.
Best results: enter substation name + number. Number-only searches are allowed, but duplicate numbers will be flagged.
Postcode lookup works online. Coordinates work offline.
Phones can behave differently to laptops. 3-stop sections are safest for multi-stop apps. Point-to-point apps create one link per stop.
Choose which map app the route buttons open.
Install this as a phone app once hosted online, or use it as a local field route planner.