Using the Bulk Upload feature, you can import data which has been entered into a preformatted spreadsheet and generate multiple reports at once. Only one type of report (Plant, Animal, or Vernal Pool) can be imported at a time. The Bulk Upload feature is one of the more complex functions of the system and therefore several help guides are available below.

Bulk Upload Tutorial pdf format of Bulk Upload Tutorial
file size 2MB

Vernal Pools

Vernal Pools Bulk Upload Instructions  pdf format of Vernal Pools Bulk Upload Instructions

Vernal Pools Bulk Upload example spreadsheet  xls format of Vernal Pools Bulk Upload example spreadsheet

Vernal Pools Bulk Upload Field Directory  pdf format of Vernal Pools Bulk Upload Field Directory

Vernal Pools Bulk Upload Template  xls format of Vernal Pools Bulk Upload Template

Plants

Plants Bulk Upload Instructions  pdf format of Plants Bulk Upload Instructions

Plants Bulk Upload example spreadsheet  xls format of Plants Bulk Upload example spreadsheet

Plants Bulk Upload Field Directory  pdf format of Plants Bulk Upload Field Directory

Plants Bulk Upload Template  xls format of Plants Bulk Upload Template

Animals

Animals Bulk Upload Instructions  pdf format of Animals Bulk Upload Instructions

Animals Bulk Upload example spreadsheet  xls format of Animals Bulk Upload example spreadsheet

Animals Bulk Upload Field Directory  pdf format of Animals Bulk Upload Field Directory

Animals Bulk Upload Template  xls format of Animals Bulk Upload Template

Additional Spreadsheets

All three bulk import spreadsheets require that you input a Town. This must be one of the 351 towns listed in the VPRS system, please refer to the "Towns" Excel spreadsheet  xls format of "Towns" Excel spreadsheet
for the official town names.

The Plant and Animal bulk upload spreadsheets require that you input a Scientific Species Name. If the name is not entered correctly the system will not match the report up with the appropriate species within the system. Please refer to the "Species" Excel spreadsheet  xls format of "Species" Excel spreadsheet
for the species listed in our database.

Please note: There have been some issues with the Bulk Upload feature when using newer versions of Microsoft Excel (file extensions ending in .xlsx). If you receive a message that states "There was a problem processing your request.  It is recommended you close your browser and restart the VPRS system.", save your spreadsheet to an older version of Excel with a file extension in .xls.

Comments

The NHESP is very interested in hearing your feedback! Please send any comments using the “Send Feedback” button on your home page within the VPRS system. If you need additional assistance, please contact us at ContactVPRSAdmin@state.ma.us.