ExtremeXL Tools Complete Feature List

Distribution Ready

Prepares workbooks for external distribution. Optionally flattens formulas, removes calculations, hidden sheets/rows/columns, and document metadata. Adds custom headers/footers and saves as a new distribution-ready file.

Use Cases: Board reports, client deliverables, external analysis, regulatory submissions

Quick Format Suite

One-click formatting for Currency, Number, Date, Percent, and Text values. Smart toggle between formats with and without decimal places (click repeatedly to cycle). User-configurable formats ensure consistency across all workbooks.

Features:

• Currency Quick Format ($) — Toggle between formats with/without decimals
• Number Quick Format (#) — Handles thousands separators and decimals intelligently
• Date Quick Format — Toggle between short and long date formats
• Percent Quick Format (%) — Apply percentage formatting with configurable decimal places
• Text Quick Format — Convert cells to text format, preserving leading zeros and preventing auto-formatting

Use Cases: Financial data formatting, report standardization, data cleanup, imported data correction

Toggle Zeros

Instantly show or hide zero values in cells throughout the active worksheet. Affects entire worksheet with single click. No formula changes needed.

Use Cases: Financial statements, variance reports, clean dashboards

Header/Footer Editor

Visual WYSIWYG editor for creating and managing custom headers/footers. Select which worksheets to apply templates to and save templates for reuse across workbooks. Real-time preview of final output.

Special Codes: &[Page], &[Pages], &[Date], &[Time], &[File], &[Path], &[Tab]

Use Cases: Professional document branding, consistent report footers, template creation

Insert/Delete Multiple Rows or Columns

Insert or delete a specified number of rows or columns at once. Choose direction (above/below for rows, left/right for columns) and quantity. Much faster than repetitive single insertions.

Use Cases: Adding data sections, report formatting, template preparation, bulk structure changes

Flatten Formulas

Convert formulas to their calculated values (static data). Two modes available:

• Flatten Range — Converts formulas only in the selected range to static values
• Flatten All Formulas — Converts ALL formulas in the entire worksheet to values

Use Cases: Breaking external links, preparing files for distribution, creating static snapshots, reducing file complexity

Copy As Image

Copies the current selection as a high-quality image to the clipboard. Ready to paste into PowerPoint, Word, emails, or any application that accepts images.

Use Cases: Creating presentation slides, documentation screenshots, email attachments, report snapshots

Find Duplicates

Scans selected cells or columns to identify and highlight duplicate values. Quickly spot repeated entries in large datasets without writing formulas or using conditional formatting rules manually.

Use Cases: Data deduplication, import validation, finding repeated customer or product entries, audit preparation

Convert Merged Cells to Center Across Selection

Replaces merged cells with Excel's Center Across Selection formatting. Maintains the visual appearance of centered text spanning multiple columns while preserving individual cell references, preventing sorting and filtering issues caused by merged cells.

Use Cases: Fixing reports that use merged cells, preparing data for sorting/filtering, cleaning imported spreadsheets, improving worksheet reliability

Swap Values

Swap the contents of two selected ranges. Select two ranges of equal size and swap their values instantly. Works with text, numbers, formulas, and formatting.

Use Cases: Rearranging columns or rows, correcting data entry errors, reorganizing report layouts

Delete Hidden Rows

Permanently removes all hidden rows from the active worksheet. Includes rows hidden by manual hiding, grouping, or any other method. Confirmation dialog shows count before deletion.

Warning: This action cannot be undone. Hidden rows may contain important data—consider unhiding first to verify.

Use Cases: Cleaning filtered exports, removing grouped detail rows, preparing data for distribution

Delete Hidden Columns

Permanently removes all hidden columns from the active worksheet. Offers to flatten formulas first since column deletion may break formula references. Works with columns hidden by any method.

Use Cases: Removing helper columns before sharing, cleaning imported data, reducing file size

Delete Blank Rows

Finds and deletes completely empty rows. Two modes available:

• In Selection — Deletes blank rows only within your current selection
• In Used Range — Scans entire worksheet used range and deletes all blank rows

Shows summary of rows removed after completion.

Use Cases: Cleaning imported data, removing separator rows, consolidating data

Delete Blank Columns

Finds and deletes completely empty columns. Two modes available:

• In Selection — Deletes blank columns only within your current selection
• In Used Range — Scans entire worksheet used range and deletes all blank columns

Shows summary of columns removed after completion.

Use Cases: Cleaning imported data, removing placeholder columns, optimizing worksheet structure

Row & Column Statistics

Click the Rows or Columns button directly (not the dropdown) to view statistics about your current selection including total count, hidden count, blank count, and data rows/columns.

Use Cases: Quick data assessment, verifying filter results, understanding worksheet structure

Workbook File Operations

Quick access to common file operations for the active workbook:

• Copy Full Path — Copies complete file path to clipboard (e.g., C:\Documents\Reports\Sales.xlsx). Useful for referencing file locations in emails or documentation.
• Copy Filename — Copies just the filename to clipboard (e.g., Sales.xlsx). Quick reference without the full path.
• Open Containing Folder — Opens Windows Explorer to the folder containing the workbook with the file pre-selected. Quick access to related files.

Use Cases: Email references, documentation, file management, sharing file locations

Worksheet Management

Tools for organizing and cleaning up worksheets in the workbook:

• Sort Sheets A-Z — Rearranges all worksheet tabs in alphabetical order. Useful for workbooks with many sheets.
• Sort Sheets Z-A — Rearranges all worksheet tabs in reverse alphabetical order.
• Copy Sheet Names — Copies all worksheet tab names to the clipboard as a list. Useful for documentation, reporting, or quickly referencing sheet names.
• Delete Blank Sheets — Finds and removes all completely empty worksheets. Shows confirmation with list of sheets to be deleted before proceeding.

Use Cases: Organizing large workbooks, cleaning up template files, standardizing workbook structure

Workbook Navigator

Visual navigation panel for quickly jumping between worksheets, named ranges, and tables in large workbooks. Provides an overview of the entire workbook structure in one place.

Use Cases: Navigating complex workbooks, auditing workbook structure, quickly locating data across many sheets

IFERROR Formula Wrapping

Wrap formulas with IFERROR to handle errors gracefully, or unwrap to remove IFERROR from formulas. Essential for cleaning up #DIV/0!, #N/A, #REF! and other Excel errors in your reports.

Wrap Options:

• Return Blank — Wraps formula to return empty cell ("") if error occurs
  Example: =A1/B1 becomes =IFERROR(A1/B1,"")
• Return Zero — Wraps formula to return 0 if error occurs
  Example: =A1/B1 becomes =IFERROR(A1/B1,0)
• Return Custom — Prompts for custom return value (text, number, cell reference, or formula)
  Example: =A1/B1 becomes =IFERROR(A1/B1,"N/A")

Unwrap: Removes IFERROR wrapper from formulas, restoring the original formula. Handles nested and embedded IFERROR instances.

Use Cases: Report cleanup, dashboard preparation, formula debugging, error handling standardization

Smart Table Formatter

Intelligent table creation and formatting wizard. Automatically detects data regions, creates/formats Excel tables, configures columns with proper data types, and optionally adds summary rows or top summary sections.

Features:

• Auto-detects data boundaries
• Formatting preset library
• Column configuration (Text, Number, Currency, Date, Percentage)
• Top summary section option
• Bottom summary row (Sum, Average, Count, Min, Max)
• Custom color overrides

Use Cases: Quick table creation, consistent formatting, imported data, template creation

Split Table by Filter

Splits a filtered table into separate tables based on visible and hidden rows. Options to create tables with visible rows only, hidden rows only, or both on separate worksheets. Perfect for categorizing data.

Split Options:

• Visible Only — Creates table with visible (filtered) rows
• Hidden Only — Creates table with hidden rows
• Both — Creates separate tables for visible and hidden rows

Example: Sales table with 1000 orders → Filter to "Complete" status (700 visible) → Split with "Both" → Result: Two new worksheets with 700 complete and 300 incomplete orders

Use Cases: Data categorization, creating subsets, department-specific data, multi-destination reporting

Delete Filtered Rows

Permanently delete all currently filtered (hidden) rows from the selected table. Confirmation dialog shows row counts. Warning: Irreversible operation—always save backup first.

Use Cases: Data cleanup, removing unwanted records, filter-based deletion, dataset reduction

Get Filters

Display a readable list of all active filters currently applied to the selected table. Report is automatically copied to clipboard with preview dialog. Works with complex multi-criteria filters.

Use Cases: Documenting analysis, sharing filter settings, filter validation, report documentation

Renamer

Powerful batch renaming tool for tables, table columns, and worksheet tabs. Preview changes before applying, with built-in validation to prevent naming conflicts and ensure Excel naming rules are followed.

Features:

• Three rename modes (Tables, Columns, Tabs)
• Preview before applying
• Unique name validation
• Invalid character removal

Use Cases: Cleaning imported data, standardizing naming conventions, template preparation

Template Systems

Import or export column definition templates for consistent table structures across workbooks. Templates include column names, data types, formats, and width settings. Save header/footer templates for reuse.

Use Cases: Standardized report structures, template creation, column format reuse, team standardization

BC Integration Clarification:

Excel Crusher's Business Central tools focus on navigation and filtering—launching from Excel data to BC pages and building filter strings. These tools don't pull data from BC into Excel; instead, they streamline your workflow between Excel analysis and BC record management.

BC Quick Launch

Select cell(s) containing BC record numbers and launch directly to the corresponding BC Card (single selection) or filtered List (multiple selections). Automatically detects record type from configured patterns.

Supported Record Types (Configurable):

• Customers, Vendors, Items
• Sales Orders, Purchase Orders
• Sales Invoices, Purchase Invoices
• Sales Shipments, Purchase Receipts
• And many more...

How It Works: Select cell(s) with BC numbers → Click Quick Launch → Pattern detected automatically → BC opens in default browser → Navigates to Card or filtered List

Use Cases: Quick record lookup, data verification, related record navigation, multi-record analysis

BC Build Filter

Generate pipe-separated filter strings from selected cell values. Simply select cells containing BC values (customer numbers, item numbers, etc.) and click Build Filter. The filter string is automatically copied to clipboard and ready to paste into any BC filter field.

How It Works:

• Select cells: C00010, C00025, C00130
• Click "BC Build Filter"
• Result copied to clipboard: C00010|C00025|C00130
• Paste into BC filter field (uses OR logic)

Use Cases: Multi-value BC filtering, customer/vendor/item subset analysis, quick filter creation from Excel lists

Multi-Environment Support

Configure BC environment URLs for Quick Launch. Set up Production, Sandbox, Test, Development, and custom environments. Set default target environment.

Use Cases: Multi-environment access, testing workflows, development/UAT, environment switching

Pattern Configuration

Configure pattern recognition for BC record number series. Define prefix, suffix, and digit length for each record type. Specify whether patterns use BC Number Series or manual entry.

Pattern Configuration:

• Prefix: Characters before number (e.g., "C", "V-")
• Digit Length: Number of digits (e.g., 5 for "00001")
• Suffix: Characters after number (optional)
• Pattern Type: Number Series or Manual Entry

Pattern Examples:

• Customer: C + 5 digits = C00010
• Vendor: V- + 5 digits = V-00025
• Item: I + 6 digits = I000123
• Sales Order: S-ORD + 6 digits = S-ORD001234

Use Cases: BC configuration matching, custom number series, record type detection, organization-specific patterns

Professional Excel Functions:

ExtremeXL includes 121+ specialized Excel functions (User Defined Functions/UDFs) that work just like Excel's built-in formulas. Type them into any cell, use them in calculations, and integrate them with your existing spreadsheets. All functions are included in both Standard and BC editions.

Unit Conversions

Convert between units of measure including temperature, distance, weight, volume, area, and specialized textile industry calculations.

Categories:

• Temperature — Celsius/Fahrenheit conversions
• Distance — cm, ft, in, m, mm, yd with numeric codes
• Weight — g, kg, lbs, oz, tons with numeric codes
• Volume — L, mL, fl oz, gal, qt with numeric codes
• Area — sq ft, sq m, sq km, acres with numeric codes
• Textile Calculations — oz/sq yd, g/sq m, yds/lb conversions for fabric

Example: =exl.scaleunit(5, "cm", "in") returns 1.97 inches

Use Cases: International trade, manufacturing, textile industry, scientific calculations

Barcode Operations

Generate, validate, format, and manipulate barcodes including UPC-A, EAN-13, EAN-8, ISBN, ISSN, and Interleaved 2 of 5.

Supported Formats:

• UPC-A — Calculate check digits, validate, format for display
• EAN-13 / EAN-8 — European article numbers with validation
• ISBN-10 / ISBN-13 — Book identification with conversion
• ISSN — Periodical identification
• Interleaved 2 of 5 — Warehouse and logistics barcodes

Key Functions: Generate barcodes with check digits, validate existing barcodes, format for human-readable display, detect barcode types, clean formatting

Example: =exl.Barcode.UpcA("01234567890", "Y") returns formatted UPC with check digit

Use Cases: Inventory management, product data validation, retail operations, publishing

Pricing & Finance

Comprehensive pricing calculations including standard pricing, retail markup/margin, break-even analysis, and financial ratios.

Standard Pricing — Calculate selling price from cost and GP%, reverse calculations, markup vs margin conversions, discount analysis

Retail Pricing — Keystone pricing, initial markup, maintained markup, contribution margin, wholesale/retail conversions

Break-Even Analysis — Calculate break-even price, quantity, revenue, required pricing for target profit

Financial Ratios — Current ratio, quick ratio, ROA, ROE, ROI, profit margins, asset turnover, inventory turnover, debt ratios, P/E ratio

Payment Terms — Calculate payment due dates from terms (Net 30, 2/10 Net 30), discount dates, mail-by dates

Example: =exl.Pricing.Standard.PriceFromCost(10, 0.40) returns $16.67 selling price for 40% GP

Use Cases: Financial analysis, pricing strategies, retail operations, business planning

Carton & Shipping Calculations

Specialized logistics functions for carton calculations, pallet optimization, dimensional weight, and freight costing.

Key Functions:

• Carton Calculations — Full cartons, remaining pieces, total weight including packaging
• Dimensional Weight — Calculate DIM weight with configurable divisors (166, 139, 194)
• Chargeable Weight — Determine greater of actual or dimensional weight
• Volume Calculations — Cubic feet and cubic meters per carton and total
• Pallet Optimization — Calculate cartons per pallet, pallets needed, utilization percentage
• Costing — Weight per carton, cost per carton, cost per unit

Example: =exl.Carton.DimensionalWeight(20, 16, 12, 166) calculates DIM weight for shipping

Use Cases: Freight quotes, warehouse operations, logistics planning, shipping optimization

Data Utilities

Format and validate phone numbers, ZIP codes, SSN, credit cards, email addresses, and perform text manipulation operations.

Formatting Functions:

• Phone Numbers — Multiple formats including extensions, validation
• ZIP Codes — Maintain leading zeros, handle ZIP+4 format
• SSN — Format with dashes, maintain leading zeros, validation
• Credit Cards — Format with spaces/dashes, optional masking
• Email — Clean and validate email addresses

Text Functions: Clean whitespace, extract digits/letters, remove prefix/suffix, split by delimiter, case conversions (Upper, Lower, Title, Proper, Sentence)

Special Functions: Convert currency to text (for checks), convert numbers to Roman numerals

Example: =exl.Data.Phone.Format(3307731084, 0) returns (330) 773-1084

Use Cases: Data cleanup, validation, standardization, report formatting

Date Utilities

Business day calculations, fiscal period functions, date range operations, and age calculations.

Business Day Functions:

• Workdays — Add workdays to dates, count workdays between dates (holiday-aware)
• Business Day Checks — Determine if date is business day
• Period Boundaries — First/last business day of month, quarter, year

Fiscal Period Functions:

• Quarters — Calculate fiscal quarters with configurable start month
• Week Functions — Week of date, week ranges, ISO week numbers

Other Functions: Calculate age (years, months, days), end of month, date ranges

Example: =exl.Date.WorkdaysAdd(TODAY(), 5) returns date 5 business days from today

Use Cases: Project planning, aging analysis, fiscal reporting, deadline calculations

Math Functions

Percentage change calculations, reverse calculations, and smart rounding to multiples.

Percentage Functions:

• Calculate Changes — Percent increase, decrease, or change with validation
• Apply Changes — Apply percentage increase or decrease to values
• Reverse Calculations — Calculate original value from new value and percent change

Rounding: Round to nearest multiple (5, 10, 25, etc.) with direction control (up, down, nearest)

Import Math: Square feet calculations, cubic feet conversions, container capacity calculations

Example: =exl.Math.PercentChange(100, 125) returns 25% increase

Use Cases: Variance analysis, pricing calculations, capacity planning

Business Central Functions - BC Edition Only

Generate Business Central URLs directly in Excel formulas for dynamic hyperlinks to BC records. Automatically detect patterns and build card/list URLs.

Key Functions:

• BC.Url — Auto-detect BC patterns and generate appropriate URLs
• BC.CardUrl — Create direct links to BC card pages
• BC.ListUrl — Generate filtered list URLs from cell ranges
• BC.PageUrl — Build simple page URLs without filters

Example: =HYPERLINK(BC.CardUrl(A2, 22, "No."), "Open Customer")

Use Cases: Dynamic BC links in reports, drill-through functionality, automated documentation

Function Documentation:

Complete function reference with syntax, parameters, examples, and use cases is available in the ExtremeXL help system. All functions include IntelliSense tooltips in Excel for parameter guidance.

🔍 Browse All 121+ Functions

Search by category, explore examples, and find the perfect function for your needs. Complete reference with syntax and use cases.

AI in Cells, Not Sidebars:

These functions use the Anthropic Claude API and work just like any other Excel formula. Type them in a cell, drag down a column, and they recalculate automatically. Requires your own Anthropic API key (Bring Your Own Key). Available in both Standard and BC editions.

AI Classify

Classify text into categories you define. Works on free-text descriptions, notes, feedback, or any unstructured data.

Example: =exl.AI.Classify(A2, "Hot Lead, Warm Lead, Cold Lead")

Use Cases: Lead scoring, support ticket routing, sentiment analysis, product categorization

AI Extract

Pull structured data out of unstructured text. Extract company names, dollar amounts, dates, email addresses, or any specific information from free-text fields.

Example: =exl.AI.Extract(A2, "company name")

Use Cases: Data cleanup, parsing email bodies, extracting key fields from notes, normalizing imported data

AI Summarize

Summarize text or an entire range of text values into a concise summary. Works on single cells or multi-cell ranges.

Example: =exl.AI.Summarize(A2:A50, 30) returns a 30-word summary

Use Cases: Meeting notes, customer feedback, survey responses, long descriptions

AI Formula Writer

Describe what you need in plain English, get a working Excel formula back. No more searching for the right function syntax.

Example: =exl.AI.FormulaWrite("sum of column B where column C is greater than 1000")

Use Cases: Complex SUMIFS, nested IFs, INDEX/MATCH patterns, array formulas

AI Formula Explainer

Paste a complex formula and get a plain English explanation of what it does. Ideal for inherited spreadsheets with formulas nobody remembers writing.

Example: =exl.AI.FormulaExplain("=SUMPRODUCT((B2:B100>1000)*(C2:C100))")

Use Cases: Formula auditing, documentation, onboarding new team members, debugging

AI Fuzzy Match

Find the best match for a value in a list, even with abbreviations, synonyms, spelling variations, or alternate names. "IBM Corp" matches "International Business Machines".

Example: =exl.AI.Match(A2, D2:D100)

Use Cases: Customer deduplication, vendor matching, reconciliation, data merging from different sources

AI Translate

Translate cell content to any language. Works with single cells or use in a column to translate entire lists.

Example: =exl.AI.Translate(A2, "Spanish")

Use Cases: International trade, multilingual reports, product description localization

BYOK (Bring Your Own Key):

AI functions use your personal Anthropic API key. Get one at console.anthropic.com. Your key is stored locally on your machine and is only sent to Anthropic's API. Results are cached to minimize API usage. Configure your key in Extreme XL > Setup > AI Settings.

Quick Format Settings

Configure default formats for Currency, Number, and Date quick format buttons. Set both primary and alternate formats for smart toggle functionality. Preview panel for each format with preset examples or custom format codes.

Context Menu Setup

Customize which Extreme XL Tools features appear in Excel's right-click context menus. Enable only the features you use frequently to keep context menus uncluttered and efficient.

Table Defaults

Configure default naming conventions and table creation preferences. Settings apply to all new tables created with Extreme XL Tools. Configure table name prefix, suffix, auto-numbering format, and default table style.