WranglesXL

Most departmental data work and analysis still happens in Excel -- its flexibility and familiarity can’t be beat. Even so, wrangling in Excel doesn’t have to be laborious. Our WranglesXL add-in brings the power of AI to your local sheets via cloud-based APIs. With WranglesXL, you can transform and integrate raw data with a few clicks…hours of work done in minutes.

What Can WranglesXL Do?

• Clean & Enrich Wrangles: preparing data in Excel is no longer a manual task. With our Standardize, Format, Classify, and Extract Wrangles, normalizing data is done in a snap. WranglesXL comes with dozens of out-of-the-box and configurable Wrangles. Once you get going, you'll understand why we always say, "There's a Wrangle for that!"

• Map: restructuring inconsistent columns and rows to align with target schemas is time consuming and error prone. With our AI-powered Map Wrangles, getting your data into the desired structure takes just a few clicks. And once the model has learned your mappings, it's all automatic.

• Recipes: WranglesXL offers automation scripts that run a series of Wrangles. Recipes are "low code" YAML scripts that not only run Wrangles, but can also read from and write to other apps and data sources via APIs. Recipes are executed in Python at Wrangles Cloud, much like Microsoft's new Python in Excel feature. But Receipes offer much more -- simpler authroing with YAML, access to more Python packages, and custom Python functions. Recipes are the best way to automate your data work.

There's a Wrangle for That!

The free version of WranglesXL comes with dozens of stock Wrangles, with many more on the way. If you upgrade, you can also create custom DIY Wrangles. DIY Wrangles require nothing more than the right training data. Paste data into Excel, click 'Train', and voila -- a powerful classification or extraction Wrangle specific to your needs.

For more complex requirements, WrangleWorks can design and deploy model-based Wrangles. Our turnkey data science program is extremely efficient -- Bespoke Wrangles can be live within weeks. In addition to Excel, Bespoke Wrangles can also be run programmatically via APIs.

Custom Wrangles, combined with Recipes, are game changer. With them, even your most convoluted data work can be automated! Given the inherently scalability of automation, it's far faster and more affordable than manual data work. WranglesXL Free edition includes stock Wrangles, Mapping, and 3 DIYs. Unlimited DIYs, Recipes, and Bespoke Wrangles require a Premium SaaS license.

Use Cases:

Wrangles can be applied to any type of data or process. One compelling use case is product data cleaning and enrichment. Rich, reliable product data is foundational to eCommerce, but producing high quality product information at scale is difficult, especially when the raw data comes from outside suppliers. With WranglesXL, onboarding supplier product data is a breeze.

Another key use case is entity recognition and classification. Ecommerce, CRM, marketing automation, and analytics all require categorization of products and customers. Bespoke Classification and Matching Wrangles can accurately group items and companies together and cross-reference them across systems and data sources.

Wrangling Automation:

WranglesXL not only enables complex data work to be done inside of Excel, but it also offers complete automation of repetitive data flows. Recipes can automate any data workflow, and can be coordinated with Microsoft Office Scripts and Power Automate workflows. WrangleWorks also offers a hosted data automation solutions on WranglesCL. Automating data work produces multiple benefits -- increased digital capacity, faster data-dependent processes -- all while freeing key people to do more important things.

AUTOMATE DEPARTMENTAL DATA WORK. Start using WranglesXL today to eliminate manual data work and scale your data-dependent processes.