[color=#FF0000]SOLUTION USING EXCEL[/color]
Import the contents of the attached attached Query definition file (Menu -> Admin -> Queries -> Import Query).
View a Group (I'd suggest Windows or Computers) and run the Query 'Export Details'. Select the Export to Excel button (Menu bar, right hand side) and save the Excel file. Edit any fields you need to change and save the file. Import the file via Menu -> Admin -> Devices -> Add Multiple Devices (using a spreadsheet).
Done
Just make sure you don't change the text of the column headings. They are used to match the rows (individual devices) to the database entries upon import. Resizing columns is fine.