Excel and CSV import
Drag and drop .xlsx, .xls or .csv files. The current tool reads the first worksheet and recognises ADI product and pricing columns.
CUSTOMISABLE OFFICE TOOL
SheetClarity
From a messy spreadsheet to a clear, searchable workspace.
THE TOOL
Make your data
easier to use.
The problem
Large supplier spreadsheets can make simple tasks slow: finding a product, comparing prices or sharing a readable list with colleagues.
The current version
SheetClarity reads ADI price lists in Excel or CSV format and organises products into divisions and categories. Search, filter and sort the results, then export them to Excel or a standalone HTML file.
Built to be tailored
Commission a version around your own spreadsheet structure, product categories, branding and workflow. The supplied version uses ADI-specific column mappings and classification rules; other file layouts can be supported through custom development.
CURRENT CAPABILITIES
Clear data. Useful outputs.
Organised product lists
Products are grouped by division, category and manufacturer. Fire products also receive protocol classifications, with uncertain results flagged for review.
Search, filter and sort
Search product information, narrow by manufacturer or protocol, and sort table columns.
Readable exports
Export an Excel workbook with a sheet per division, save selected results as a searchable standalone HTML file, or print the view.
Product references
Copy part numbers and follow product lookup links to ADI.
Browser processing
The supplied tool reads the selected file in the browser. Its spreadsheet library loads from an external CDN; the exported HTML is self-contained.
CUSTOMISE IT FOR YOUR BUSINESS
Your file structure, your categories, your branding. A practical tool built around the way your team uses spreadsheets.
CUSTOM DEVELOPMENT
Shape your version.
Tell us what your files contain, who uses them and what the final output needs to do.
Your data
Custom column mappings, supplier formats, category rules and validation checks.
Your brand
Company colours, logo, labels, currencies and branded exports.
Your workflow
Filters, reports and outputs designed for the tasks your staff repeat.
Software integration
Discuss connections to your catalogue, quoting or business management software as part of a bespoke build.
TRY THE CURRENT TOOL
The ADI price-list version.
Use an ADI-format file to explore the current tool. This demo uses ADI-specific rules; request a custom version for other layouts.
Open interactive tool ↓
The spreadsheet library needs an internet connection when the tool loads.
A custom version for your company.
Customisation and pricing are agreed around your requirements. Tell us about the spreadsheet you use and the results you need.