ΒΆ Excel Import
The Excel Import (reachable via Administration -> Manage -> Excel Import) is an easy
way to transfer simple data from an Excel Sheet into an object in the cockpit.
To import the data, one has to specify the name of the XLS file (new XSLX file type is not supported as of Nov 12th 2013),
the target object and how to match the columns in the Excel table with the entries in the given object (see screenshot above).
After having run the Import, the data should be transferred to the respective object. If the rows are all red, one has to
trigger a recalculation (right click in the grid view, select Recalculate -> All records) to correctly set the IS_VALID entry to 1.