You can both import and update equipment in room into dRofus from Excel by going to Rooms → Import/Export → Import/update Items to rooms . 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 Items 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 Function 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 within 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 columns in the spreadsheet, but are not specified for import, they will not be read.
If you import/update items in different item list, tick "item list" and indicate the column number that defines the item list. If your import/update concerns only one item list you can select it directly for your entire import:
