What this guide does
This guide explains how to access and use the network bulk upload Excel template.
This guide shows how to download the template, enter your data and upload it through a Network Update Request.
This guide is for road managers who need to make large changes to network segments in a single import.
Prerequisites
NHVR Portal (NHVR Go) account with Road Manager access.
Access to Network Management and the relevant network in your area of responsibility.
Permission to create and edit a Network Update Request (NUR) for that network.
Microsoft Excel (or equivalent) to edit the template.
Date of last review
Date of last review: [04 06 2026]
Step-by-step instructions
Note: The Bulk Import tool can be used directly when accessing a Standalone network or via an NUR. NURs are created by Road Managers, and changes are loaded under the RM account and privileges. For Standalone networks it is possible for some changes to be made directly using the NHVR administrator account and privileges. Other changes can be made using the RM account.
1. Log in to NHVR Go and open Access Management.
2. Open Vehicle networks and select the network you want to update.
3. Create a Network Update Request (NUR) or open a draft Network Update Request (NUR) for that network.
4. After the NUR is created, locate the NUR number and click the three dots (⋯) to the right of the NUR.
Note: The network should Not be put into Edit mode.
5. Select Import Network Segments.
The following screen is presented. A list of network segments will be presented showing all the segments that are already on the network and their current access status. Click on the Import Segments button on top right.
7. Choose the option to upload from source file.
This is where the list of changes required are to be loaded into the tool. There are two ways to load the data.
Option 1 is to import a data file by dragging the file into the selection box. The file must either be a correctly formatted CSV or an Excel spreadsheet. The Excel file must only contain one tab and be formatted with the correct columns.
Option 2 is to copy the data directly from the source file and paste it into the input box. This option is useful for multi-tab excel files.
A correctly formatted file will have a header row and one or more data rows.
And when pasted into the input box it appears in CSV format….
Click Next
10. Wait while the system checks the file. Any invalid fields will be highlighted (for example in red).
11. Correct any errors in your template if needed, then re-upload.
12. When the file is valid, click Import. The system processes your changes and generates a notification when the import is complete.
13. After the import is completed, review the results table for the NUR and then click Back to return to the NUR, where all imported segments are now included. Adjust or remove segments as required using normal NUR tools.
14. The Import network segments screen will now show the segments that are on the network with their current access status. Note that one of the Bulk Tool options is to remove segments from the network and as such any removed segments will no longer be visible in this screen, only segments that are currently on the network.
Creating the data load file
A spreadsheet with example data and a worksheet for creating the data upload file can be downloaded from the Import Data screen.
There are 3 tabs:
· Bulk Load Work Sheet – this can be used to build up a set of changes that need to be made to the network
· Example Data – There are examples of changes that can be made
· Lookup – This is used by the Work Sheet as drop downs in the various columns
The lookup tab has the various valid options that can be used and can be selected via drop down on the worksheet.
Those options in yellow are not fully tested and currently are not supported.
Where None is specified, both None and leaving the field blank are valid and identical options.
When preparing the worksheet, the columns may be presented in any order, and not all columns are required. Columns that are blank may be removed. However, the column headings must be typed exactly as shown. E.g.
Examples
Adding free form condition text to a road segment - a generic Condition Code is selected from the library
Selection type | Access change | Condition or restriction | Road Segment Id |
Road segment | Approved with Conditions | TMRCRMR01 - Critical Areas and Roads in Queensland | 15181160 |
Adding free form condition text to a road segment - generic Restricted Code is selected from the library
Selection type | Access change | Condition or restriction | Road Segment Id |
Road segment | Restricted | Mass limited to 70t | 15181164 |
Add road segment as "Approved" to the network
Selection type | Access change | Road Segment Id |
Road segment | Approved | 15181164 |
Remove road segment from the network
Selection type | Access change | Road Segment Id |
Road segment | Remove | 15181164 |
Add all roads owned by the specified road manager to the network as "Approved"
Selection type | Access change | RM Id |
All managed roads | Approved | RMNSW1 |
Remove all roads owned by the specified road manager from the network
Selection type | Access change | RM Id |
All managed roads | Remove | RMNSW1 |
Add all network segments from another network that are not already on this network, without changing access - Road Manager must be specified
Selection type | Apply only if imported segment is | Network Id | RM Id |
Other Network | Not on network | 5973 | RMNSW1 |
Add all network segments from another network that are already on this network and change them to "Approved" - Road Manager must be specified
Selection type | Apply only if imported segment is | Access change | Network Id | RM Id |
Other Network | On network | Approved | 5973 | RMNSW1 |
Add all network segments from another network for the specified Road Manager without changing access - overwriting any segments that are already on the network
Selection type | Network Id | RM Id |
Other Network | 5973 | RMNSW1 |
Change all segments that are on this network for this road manager to a different access state
Selection type | Apply only if imported segment is | Access change | Condition or restriction | RM Id |
This Network | On network | Restricted | Access not permitted | RMNSW1 |
Approve all segments on this network for the specified road manager
Selection type | Access change | RM Id |
This Network | Approved | RMNSW1 |
Tips and common issues
Use the example row at the bottom of the template as a guide for how to format your data.
Always check that you are working on the correct network and NUR before running a bulk upload, as large changes can be applied in one step.
If the system marks fields as invalid, review the exact text in the template (for example spelling, codes or IDs) and correct them before retrying.
Keep a copy of the completed template file as a record of the bulk change performed.
Where to get help
Check your organisation’s internal process for bulk network changes and approvals.
Contact the NHVR Network Management or Spatial support team if you are unsure which template or scenario to use.
