It is possible to both import and update room Functions into dRofus from Excel by using the Import/Export tab from within the Rooms module.
This will open a window where you can choose an Excel file from your computer. Once you have done this, dRofus will automatically suggest the first row of data and check whether the program recognizes the column name which matches either with the Number field in dRofus. This is only intended as a suggestion and must be double-checked in the Excel spreadsheet before running the import. It is important to also check that the correct worksheet has been specified. It does not matter which columns contain the data, however, it must be specified in the import dialog window. Only the columns specified for import will be read.
You can choose to either only import Functions that do not already exist, only update existing Functions, or both. When using Import no identifier is needed, but for update Function ID, or Function Full Number is needed. If you only import new Functions, all Functions which match existing Functions in dRofus will return an error message that will detail the issue to resolve. The same will occur if you only want to update Functions but one or more Functions do not match those existing in dRofus.