Untangler® - intelligent spreadsheet conversion technology
Untangler® is an intelligent transformation service for inconsistent and unpredictable input spreadsheets. Supply it with arbitrary input data and it will locate and extract records that are a best match to your pre-defined requirements.
A typical application would be where an organisation receives spreadsheet data from a number of other entities, in a variety of formats, which then have to be processed into a common internal format. A good example is an insurance company processing quotations. Currently the insurance company would be manually handling the input spreadsheets, locating the required data, converting/mapping fields such as dates (with possible errors) and then saving them to a standard internal format for further processing, typically for use in an existing internal system.
Untangler® is designed to automate this process saving hours of laborious and expensive human time. We work with you to define the nature of the data that you need and, after training Untangler, we set up your user accounts and output templates.
Your users then log on, upload the files that need converting and download the results.
An API is available if you'd prefer to integrate the service into your own systems.
- Opens any type of spreadsheet, which means there is no need to manually open and prepare the data.
- Data recognition - Untangler’s unique pattern recognition strategies automatically identify the information you need and removes extraneous data.
- Data validation - Use Untangler’s library of dictionaries and pre-built strategies, combined with your input, to achieve amazing results.
- Analyses - Instant analysis provides a detailed analysis of your inbound data, identifying key information and insights.
- Error fixing - Untangler’s strategy engine and libraries run at lightning speed to check and query or fix data that falls outside expected ranges.
- Automated calculations - Supercharge your business processes with a range of real-time predefined and custom calculations to enrich your data.
- Huge productivity gains for any process reliant on external spreadsheets (life, P&C, reinsurance, etc.).
- Increased data accuracy - query or reject poor quality data with Untsngler spotting suspect inputs including dates, numbers, names, prices, addresses plus many more.
- Release your skilled employees from the mundane task of basic data preparation.
- Typical conversion takes less than 5 seconds compared to 20 minutes for a human to complete the same task.
- Low internal disruption - Designed to augment existing processes, with minimal impact to existing systems.