You can both import and update equipment in room into dRofus from Excel by going to dRofus->Import/update and choosing Import/update equipment in room. This will open a window where you can choose an Excel file from your computer. The file must contain data to identify existing rooms and existing Item and data to create a new or update an existing occurrence.
You can choose to either just import equipment which does not already exist, only update existing equipment or both. When you only import new equipment, all occurrences which already exist are ignored. When you only update equipment, all occurrences which do not exist are ignored.
You have to select the way in which the rooms are to be identified, for example, by specifying their room data sheet number. You also have to select the way in which the Item are to be identified, for example, by specifying their Item number.
Once you have specified the Excel file, dRofus will automatically suggest the first row of data and check if the program recognizes the column name which matches the selected identification type for room and for Item. This is only intended as a suggestion and must be double checked with the Excel spreadsheet before running the import. You must also check that the correct worksheet has been specified. It does not matter which column the data is entered in. Only the columns specified for import will be read. Even if you have other information in the spreadsheet, it will not be read.