Skip to main content

Using the network bulk upload template – How to download, complete and import the bulk upload template for network segment changes

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.

att_0_for_1415643142.png
att_1_for_1415643142.png


3. Create a Network Update Request (NUR) or open a draft Network Update Request (NUR) for that network.

att_2_for_1415643142.png

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.

att_3_for_1415643142.png
image-20260604-041319.png

5. Select Import Network Segments.

att_4_for_1415643142.png
  1. 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.

att_5_for_1415643142.png

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.

att_6_for_1415643142.png
  1. A correctly formatted file will have a header row and one or more data rows.

image-20260604-041800.png

And when pasted into the input box it appears in CSV format….

image-20260604-041902.png
  1. Click Next

image-20260604-042111.png


10. Wait while the system checks the file. Any invalid fields will be highlighted (for example in red).

image-20260604-042147.png

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.

image-20260604-042223.png

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.

image-20260604-042250.png

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.

image-20260604-042321.png

Creating the data load file

  1. A spreadsheet with example data and a worksheet for creating the data upload file can be downloaded from the Import Data screen.

image-20260604-042348.png
image-20260604-042410.png

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
​

  1. 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.

image-20260604-053330.png
image-20260604-042646.png
image-20260604-042809.png
  1. 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.

image-20260604-042918.png

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
​Oversize Vehicles/Combinations requiring Pilot/Escort in Queensland
An eligible Agricultural Heavy Vehicle must operate in accordance with the access conditions as advised in the Critical Areas and Roads in Queensland for Vehicles/Combinations requiring Pilots/Escort.
For more information, visit QLD TMR's website at https://www.tmr.qld.gov.au/business-industry/heavy-vehicles/heavy-vehicle-route-maps-and-restrictions

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.

Related articles

Did this answer your question?