Excel Importer

Cubix allows for the import and treatment of data directly from Microsoft© Excel for use within its Taskflow engine.

The simple to use engine is highly configurable to define what information is imported, and from what tabs. As part of the import, data can be converted into ISO standards for dates and language codes, as well as split or joined as needed. Imports are based on column names rather than positions, and so this protects against issues that occcur when Excel templates change in structure.

Whilst many organisations are trying to move away from storing data in worksheets - we find that there is still alot of data stored and manipulated in this way. Having the ability to take this data directly provides efficient solutions for where a migration to a more Cubix based workflow is occurring - or for where operators wish to manipulate data "en masse" and then re-import it.