Excel Spreadsheet to Upload
NOTE: You Have To Be Logged In For The Validate and Validate/Upload Buttons To Be Enabled
Check Excel Upload File For Formatting/Invalid Values Errors
We are having problems with uploads. After validating your spreadsheet and getting the GUIDS, please email it to tim.phillips@vermont.gov so he can do the upload
List All Fields Required in Excel spreadsheet and information about them
The Excel Spreadsheet must be a) in XLS format. b) have a sheet labeled UpLoad that will the source of the data imported c) the 1st row on the UpLoad sheet must be the column headers. d) the column headers must match the names in the listing visible from the FIELDS LIST button to be recognized. e) all columns in the FIELDS LIST must be on the Upload sheet or the spreadsheet will fail the validity check. Extra fields not in the list are not a problem, they will be ignored. The order of the columns in the spreadsheet is not significent for the upload. f) in columns where multiple values can be entered (examples, DnBedScours,Obstructions,UpDeposits) the values must be separated by commas. A space after a comma should be automatically removed if that style helps you with readability in the spreadsheet.
