All Features

Undo Last→ Reverses the last XLMind data operation in this session. Excel's own Undo is unreliable after add-in changes, so use this to step back a XLMind action. Only the most recent operation can be undone. Auto Fit→ Adjusts the row heights and column widths on the active sheet so your data fits, like selecting the whole sheet and double clicking the row and column borders. You only need any single cell selected. There is no table selection and no dialog. If a column would get wider than about 50 width units, XLMind turns on wrap text and sets the row height again so long text stays readable.

Quick Table Format→ Turns the range you select into a clean, readable table in one step, with a header row, alternating row banding and tidy borders. Trim & Clean→ Removes leading and trailing spaces, doubled inner spaces, non-breaking spaces Fix Broken Characters→ Repairs garbled characters, sometimes called mojibake, in the selected text. This often happens after importing from a CSV file, the web, a PDF or an old export. Select the affected cells and run it. Only text cells change and formulas are left untouched. Everything runs on your computer. Clean Headers→ Cleans the column headers in the FIRST row of the selected table and leaves the data rows unchanged. It trims extra spaces, removes hidden characters and line breaks, gives a blank header a safe name, and makes repeated headers unique, such as Name_2 and Name_3. Select the table or its header row first. This prepares headers that came from a CSV, the web or an export so they work well with Excel Tables, PivotTables, Power Query and lookups. Unmerge and Fill→ Unmerges every merged area in the selection and copies each merged value down into the freed cells, so the data becomes filterable and sortable. Formatting is preserved and empty merged areas are skipped; you are asked to confirm first. Fill Blanks→ Fills each blank cell in your selection with the value from the cell above it. This is useful for flattening grouped reports before you build a PivotTable. Select the columns that have the gaps first. Only truly empty cells are filled and you can undo the change.

Delete Empty Rows→ Removes the fully empty rows inside the selected table area and moves the rest up, but only within that area. Cells outside your selection, including a table below in the same columns, are never moved. Selecting the exact table range is the safest. If you select whole columns, XLMind finds a single block of data and asks you for a clear range when the data spans several blocks. Formula cells and merged cells keep their row, and you confirm before it runs. You can undo the change. Delete Empty Columns→ Removes the fully empty columns inside the selected table area and moves the rest left, but only within that area. Cells outside your selection, including a table to the right in the same rows, are never moved. Selecting the exact table range is the safest. If you select whole rows, XLMind finds a single block of data and asks you for a clear range when the data spans several blocks. Formula cells and merged cells keep their column, and you confirm before it runs. You can undo the change.

Extract by Pattern→ Finds and pulls out parts of your text using a ready made pattern, and writes what it finds to a new column on the right. Pick a pattern from the list, such as email, phone, date, IBAN or a document code. Custom is at the top if you want to type your own pattern. Your original column is not changed, results are kept as text so codes and leading zeros stay correct, and everything runs inside Excel.

Extract Email→ Extracts email addresses from the selected cells into a new column immediately to the right. Original values are never changed. Extract Phone→ Finds phone numbers in your text and writes them to a new column on the right. Common local and international formats are supported. Leading zeros are kept and the result stays as text, so the numbers are not changed. Your original column is left as it is. Extract URL→ Extracts web addresses (http, https, www and common domains) into a new column to the right. Original values are never changed. Extract Number→ Finds the first number in each cell and writes it to a new column on the right, kept as text. Both comma and dot decimal styles are supported. Long identity numbers and phone numbers are left untouched so they do not lose digits.

Take Left→ Takes the first N characters of each cell into a new column to the right. Leading zeros and codes are preserved as text. Take Right→ Takes the last N characters of each cell into a new column to the right. Leading zeros and codes are preserved as text. Before / After→ Takes the text before or after a marker (first or last occurrence) into a new column to the right. Original values are never changed. Extract Between→ Extracts the text found between a start marker and an end marker into a new column to the right. Original values are never changed.

UPPERCASE→ Converts the selected text to UPPER CASE. lowercase→ Converts the selected text to lower case. Proper Case→ Capitalizes the first letter of each word in the selected text. Sentence case→ Converts the selected text to sentence case, capitalizing only sentence starts.

Add Prefix / Suffix→ Adds a prefix and/or a suffix to each cell and writes the result into a new column to the right. Blank cells can be skipped. Remove Duplicates in Cell→ Removes repeated items inside each cell (split by a delimiter) and writes the unique list into a new column to the right. Text to Numbers→ Converts numbers that are stored as text, including ones with a leading apostrophe, into real numbers so they can be used in calculations. Values that would lose a leading zero, such as a phone number, an identity number or a product code, are protected and reported. A dialog lets you choose Safe, Force or Keep as text. The change happens in place and you can undo it. Fix Apostrophe Numbers→ Removes the leading apostrophe that keeps numbers stored as text and turns them back into real numbers that calculate. Leading-zero, code, ID and phone-like values are protected so they don't lose their zeros. Leading Zeros→ Adds leading zeros to a fixed width (e.g. 42 → 00042) or removes them, for tidy codes and IDs. Formulas to Values→ Replaces the formulas in your selection with the results they currently show, so the cells hold plain values instead of formulas. This is a quick, safe way to freeze calculated results. Select the cells first. The change happens in place, you confirm before it runs, and you can undo it.

Date Picker→ Adds a small calendar button to the cell you selected. Click that button to open a calendar and choose a date, and the date is written into the cell for you. If the cell already has other content it asks before replacing it, and you can undo the change. Click the tool again on the same cell to remove the button. Fix Dates→ Turns text dates, number based dates and mixed styles into real Excel dates and applies the display format you choose. You can write the result to a new column, which is the safe option, or change the same cells. It recognizes dates written with dots, slashes, dashes or spaces, and plain date numbers such as 46590. An impossible date is left as it is so nothing is guessed wrong. Check Dates→ Looks at the dates in your selection and reports how many are real dates, how many are stored as plain numbers, how many are text, and how many look invalid or unclear. It only reports and does not change anything.

Create Date Hierarchy→ Add year, month, quarter, day and more columns next to the selected date column. Create Date Range→ Creates a list of dates between a start date and an end date on a new sheet. You can include every day or only working days. Your current data is not changed.

Mask Data→ Creates a masked copy of the columns you choose on a new sheet, so you can share the file without showing sensitive values. Your original sheet is not changed. Identity numbers, tax numbers, card like numbers, names, emails, phone numbers and account numbers can be hidden while the text still looks realistic and leading zeros are kept. This runs inside Excel and your workbook is not sent anywhere. There is no undo because a new sheet is created, so delete that sheet if you do not want it. Number to Words→ Spells out numbers and amounts in 16 languages, producing the written form contracts and checks require without touching your source data. Alternate Row Coloring→ Applies soft, modern banded shading to alternate rows in the selection to make long tables easier to read. Pick a color from the swatches; it is formatting only (not an Excel Table) and warns before replacing existing fills.

Image Validation→ Creates a visual selection list. Writes the selected text to the cell and places the matching image in the next cell. Create Barcode→ Creates a Code 128 barcode picture for each value in your selection and places the pictures on the sheet. The barcodes are generated on your computer with no font or internet needed. The value is used exactly as written, so codes with leading zeros are kept. Your source cells are not changed and you can undo to remove the pictures. Create QR Code→ Creates a QR code picture for each value in your selection and places the pictures on the sheet. The QR codes are generated on your computer, so nothing is sent to any website or service. Your source cells are not changed. You can undo to remove the pictures.

Color Picker→ Picks a color from a point on the screen and lets you copy its HEX code. Export to PDF→ Saves the range you selected as a PDF file on your computer. You choose portrait or landscape, and only the selected range is exported, not the whole sheet or workbook. Your data is not changed and nothing is sent anywhere. Select a normal range, not an entire column or row. Insert Checkboxes→ Inserts checkboxes into the selected cells. Add Bullets→ Adds bullet markers to text in the selected cells.

Append Worksheets→ Stacks the data from several worksheets into one combined table, one after another. It checks that the columns line up and stops with a clear message if they do not. The header is written once and the result goes to a cell you pick. Nothing is overwritten without asking, this runs inside Excel, and you can undo. Append Selected Tables→ Stacks several tables or ranges that you pick, even from different sheets, into one combined table. It checks that the columns line up first. The result goes to a cell you pick, nothing is overwritten without asking, and you can undo. Everything runs inside Excel. Lookup from Table→ Brings values from a second table into your main table by matching a key column. Multi Lookup→ Returns every matching row for a value from another table, not just the first.

Group By→ Builds a summary on a new sheet that groups your table by a column you choose and adds totals such as count, sum, average, smallest and largest. It is a plain summary sheet, not a live PivotTable. Your original data is only read and not changed, and everything runs inside Excel. Unpivot Columns→ Reshapes a wide table into a long one on a new sheet, turning columns into rows so the data is easier to filter and summarize. You keep the id columns you choose. Your original data is not changed and this runs inside Excel. Split Data→ Splits the selected table by the values in a column you choose. Each group can go to its own sheet in this workbook or to its own Excel file in a folder you pick. Your original table is not changed and no data leaves your computer. There is no undo because new sheets or files are created, so delete them if you do not want them.

Highlight Duplicates→ Highlights duplicate values in the selected cells. Blank cells and the header row are ignored by default; original values are not changed. Highlight Unique Values→ Highlights values that appear only once in the selected cells. Values are not changed and the operation can be undone. Add Duplicate Count→ Counts how many times each value appears in the selected column and writes the result into a new column on the right. The original column is not changed. Extract Unique List→ Writes the list of unique values from your selection to a cell you pick, in the order they first appear. Your source data is not changed, results are kept as text so codes and leading zeros stay correct, and you can undo. Nothing is overwritten without asking. Compare Two Lists→ Compares two lists, which can be on different sheets, and shows what is only in the first list, only in the second, and in both. The result is written to a place you pick as three columns. Your source lists are not changed and you can undo. Compare Rows→ Compares two adjacent columns row by row and writes Match/Different results into a new column.

Data Profile→ Builds a profile report of your table's health on a new worksheet, without touching the source data.

Highlight Formula Cells→ Color every cell that contains a formula. Values are not changed. Highlight Error Cells→ Color cells with an Excel error (#DIV/0!, #N/A, #REF!, #VALUE! and more). Highlight External Link Formulas→ Color formulas that reference another workbook. Formula Map Summary→ Analyzes every worksheet in your workbook and presents formulas, cross-sheet dependencies, external links, and formula errors in one professional report.

Highlight Constants→ Color non-formula, non-empty constant cells (codes like 0012 are kept). Highlight Blank Cells→ Color truly empty cells. A formula that returns "" is not counted as blank. Highlight Inconsistent Formulas→ For each column, colors the formulas that do not match the pattern used by most cells in that column, so an odd formula is easy to spot. Only colors are added and your formulas are not changed. Highlight Data Validation Cells→ Color cells that carry a data-validation rule. Rules are not changed. Highlight Conditional Formatting Cells→ Color cells that have conditional formatting. Existing rules are not modified. Highlight Locked Cells→ Color cells whose Locked attribute is on. Protection is not changed. Highlight Unlocked Cells→ Color cells whose Locked attribute is off. Protection is not changed. Highlight Rows with Errors→ Color entire rows (within the selection) that contain any error cell. Select Formula Cells→ Selects the cells in your range that contain formulas, so you can review or format them together. Nothing is changed. Only the selection changes. Select Constants→ Selects the cells in your range that hold typed values rather than formulas. Nothing is changed. Only the selection changes. Select Error Cells→ Selects the cells in your range that show an error, so you can find and fix them. Nothing is changed. Only the selection changes. Select Blank Cells→ Selects the empty cells in your range, which is handy before filling them in. Nothing is changed. Only the selection changes. Select Visible Cells→ Selects only the visible cells in your range and skips rows or columns that are filtered out or hidden, so a copy takes just what you see. Nothing is changed. Only the selection changes. Extract Formula Text→ Creates an exact copy of your selection in which every formula is written out as readable formula text instead of its calculated result. List External Link Formulas→ List formulas that reference another workbook to a range you pick. List Named Ranges→ List the workbook's defined names (name, scope, refers-to, visibility). List Hyperlinks→ List the hyperlinks in the selection (address, display text, link). List Comments and Notes→ List cells with comments or notes (address, type, author, text). List Worksheets→ List the workbook's sheets (name, visibility, used size, filters, freeze). Sheet Protection Summary→ List each sheet's protection state (no password is ever asked).

Count by Color→ Counts cells in the selected range that match the fill color of a reference cell. Sum by Color→ Sums numeric cells in the selected range that match the fill color of a reference cell.

Create Dashboard→ Builds one of four ready dashboard layouts (Executive, Sales, HR, Finance) from the selected data. Create Report→ Builds a tidy, printable report from the selected data.

Executive Overview→ A dark, executive-style board: a large hero ring and a combined trend chart put the overall state of the business on one screen. Sales→ A sales board that puts the period trend at the centre, summarising sales performance on a single sheet with combined charts. Human Resources→ An HR board that shows team metrics at a glance with a distribution donut and status tiles. Finance→ A finance board that sums up results with a waterfall chart, a target bullet and a margin ring, presented in your local currency.

Executive Report→ Produces a multi section executive report opening with a main chart. Sales Report→ Produces a sales report opening with a lollipop signature chart. Finance Report→ Produces a finance report opening with a waterfall signature chart. Human Resources Report→ Produces an HR report opening with a category signature chart. Inventory Report→ Produces an inventory report opening with category and top N charts. Project Report→ Produces a project report opening with a distribution signature chart. Data Quality→ Produces a data quality report summarising a data set's quality (no custom slots). General Report→ Produces a general purpose report opening with a main chart for any table.

KPI Cards→ Builds 12 KPI card layouts for values, targets, changes, trends, sparklines and progress indicators. Basic Value→ A clean, typography-led KPI value. Value and Sparkline→ A value with a trend sparkline. Donut Progress→ A percentage in a donut ring. Segmented Target→ A value with a segmented target bar. Mini Columns→ A value with a mini column chart. Benchmark→ A value compared to a benchmark. Area Trend→ A big value over a filled area trend. Gauge Target→ A gauge with a value and a target marker. Progress Rail→ A value on a continuous progress rail. Dual Comparison→ Current vs previous with the difference. Mini Columns Below Value→ A big value with a mini column chart below it. Card Grid→ Several mini KPIs in one card.

Charts→ Inserts professional chart and visualization options bound to your data.

Dot Plot→ Values as dots along an axis. Density Curve→ A smooth distribution curve. Radar→ Multiple criteria on radial axes. Correlation Matrix→ A pairwise correlation heatmap. Pareto→ Bars plus a cumulative line. Forecast Cone→ Actuals with a forecast band.

Gantt Chart→ Task bars across a time axis. Milestone Roadmap→ Key dates along a timeline. Funnel→ Stage by stage conversion. Process and Bottleneck→ Process stages with a bottleneck.

Gauge→ A value on a colored gauge with a needle. Bullet Chart→ Actual versus target on qualitative bands. Progress Ring→ A percentage in a ring. Thermometer→ A value filling a thermometer. Target vs Actual→ Actual against target per category. Status Spectrum→ A value on a red to green spectrum.

Waterfall Delta→ Cumulative increases and decreases. Before vs After Arrow→ The change from before to after. Step Delta→ Stepwise change across categories. Marimekko→ Share within share with variable widths. Variable Width Column→ Columns whose width also carries data. Bi-Directional Bar→ Two measures from a shared center. Treemap→ Nested rectangles sized by value.

Gender Ratio Card→ Female and male share. Pictogram Gender→ Gender split shown as figures. Gender and Age→ Gender split across age groups.

Turkey Map→ A choropleth of Turkiye's 81 provinces by value. World Map→ A world choropleth coloured by country value. United States Map→ A US choropleth of the 50 states plus Washington DC. Europe Map→ A choropleth of European countries by value. Germany Map→ A choropleth of Germany's 16 federal states. France Map→ A choropleth of France's regions by value. United Kingdom Map→ A choropleth of the UK regions and nations. Canada Map→ A choropleth of Canada's provinces and territories. Australia Map→ A choropleth of Australia's states and territories. Brazil Map→ A choropleth of Brazil's states by value. India Map→ A choropleth of India's states and union territories. Mexico Map→ A choropleth of Mexico's states by value. Spain Map→ A choropleth of Spain's autonomous communities. Italy Map→ A choropleth of Italy's regions by value. Japan Map→ A choropleth of Japan's 47 prefectures.