Flexter for Excel

Excel and other office document formats are based on the Office Open XML (OOXML) industry data standard. Flexter can process Excel files into a relational database format.
At Sonra, we are working hard to make additional Excel features available.

Flexter for Excel

Excel and other office document formats are based on the Office Open XML (OOXML) industry data standard. Flexter can process Excel files into a relational database format.
At Sonra, we are working hard to make Flexter for Excel features available.

Flexter for Excel. Governance for your spreadsheets,

Excel is widely used in offices all around the world. In fact there are more than 500M users of Excel and other spreadsheet applications. And yet, many organisations struggle with this proliferation of spreadsheets in so called spreadmarts. The growth of spreadmarts poses tangible risks for companies, since this ungoverned and often unverified data is frequently used in decision making.

Flexter sets out to address this problem and to make spreadmarts and the information locked away in them searchable. We are building out the following features.

Excel metadata catalogue

Ingest thousands of Excel files and search for metadata, e.g. formulas, connections to external data sources (relational databases), styles, connection to other Excel files, pivot tables, keywords etc.

Excel mutant detection

Many companies use Excel templates as mini databases to capture data. Excel mutant detection automatically finds deviations of the Excel instances from the template.

Automated detection of errors in formulas

Detect common errors in Excel formulas, e.g. copy and paste errors.
Find formulas across thousands of Excel sheets.

Personally Identifiable Information (PII)

Search across thousands of Excel files and detect which data cells contain PII.

Fast ingestion of very large Excel files

It can be tricky to ingest very large Excel files into a database or data warehouse.

Data lineage

Organisations build spreadsheets on top of spreadsheets on top of spreadsheets.
With Flexter we can visualise the data lineage of formulas and trace them back to a connected data source.

 

Automated header detection

Automatically detect which cells in an Excel file are header cells, which ones are data cells, and which are derived or offer contextual information.

 

If you would like to become a beta tester for any of the features please express your interest and contact us.

Reduce costs

Reduce the cost of transforming complex XML structures by up to 80%.

User testing with Flexter eliminated a 120 day development project, saving 80,000 Euros in development costs and 10,000 Euros in annual maintenance costs.

Rapid XML processing

Flexter is extremely fast when processing XML data.

Using advanced algorithms and in-memory processing, user tests loading complex XML files performed an astonishing 600 times faster on the same hardware when using Flexter.

Keep on track

Flexter removes the risk of your XML project failing.

Data in XML files becomes available instantly without custom development or training.
Service Level Agreements are no longer missed.
Analysts and ETL developers can move away from endless lines of code - focusing on delivering real insights and value to decision makers.

Scale infinitely

Flexter handles any volume of XML data.

Built to work with multiple servers, it scales linearly - an important consideration in the current era of big data and exponential data growth.

Your opinion matters to us – which Excel feature would add value to your organisation?