BigXL
FeaturesScalePrivacyCompareWho it's forDocsBlogPricingSupportDownload
User Guide

Everything BigXL does, in plain words.

Pick a topic below, or use ⌘K inside the app to search for what you want directly.

Start

Getting startedOpen your first file and see what BigXL does differently from a spreadsheet.Moving around a big fileNavigate, select, resize columns, freeze the ones you need, and reorder them.

Find and shape

Filtering and sortingNarrow a file down to the rows you need, and put them in order.Cleaning and fixing dataTrim, re-case, split, find and replace, remove duplicates, merge similar spellings, group and total rows, turn columns into rows, fix dates, and force columns to numbers, each with a preview before it runs.Formulas and computed columnsWrite an Excel-style formula to add a new column, including VLOOKUP across open files, date functions, and logic.Searching every open fileLook for a name, number or phrase in all your open files at once, see which files hold it, and jump to the cell.Colouring cells and rowsMark the values that matter with colour, by rule, on a file of any size. Nothing in the file changes, and every colour can be taken off.Spotting and fixing problem valuesSee at a glance how clean each column is, and fix the values that do not fit, with a preview before anything changes.

Combine

Joining and appending filesCombine two open files by matching a column, or stack one under the other.Comparing two filesSee which rows are new, which have gone, and which changed between two versions of the same export, with both values side by side.

Analyze

ChartsChart one column or compare two, with BigXL suggesting the picture that fits. 21 chart types, computed over the whole file.Pivot tablesTotal, average, count, or break down one column against another without writing a formula.The SQL consoleQuery a file directly with SQL, or describe what you want in plain English and let BigXL write the query.Bix, your offline assistantAsk Bix to query, filter, clean, chart or export in plain words. Bix runs entirely on your computer, so your data never leaves it.

Privacy

Redacting personal dataFind and mask names, emails, IDs and more before sharing a file, with presets for GDPR, HIPAA, and legal discovery.Compliance and evidentiary toolsBates numbering, HIPAA Safe Harbor, word list redaction, and compliance certificates for litigation and audits.

History and automation

Timeline and recipesEvery change is a step you can undo, rewind to, or save as a recipe and replay on another file.Exporting your fileSave what you are looking at, with all filters, sorting, and masking applied, as a new file in the format you need.Saving and reopening a sessionSave every open tab, filter, sort, and mask as one file and come back to it exactly where you left off.NotesA scratchpad to jot things down while you work, saved with your session or exported to a text file.

Reference

Keyboard shortcutsEvery shortcut in one place. On Windows and Linux, use Ctrl in place of Cmd.Licence and trialWhat the FREE edition includes, how the 14 day trial works, and how to activate, move or deactivate a licence, all without a network connection.
Download BigXLFree for any file size. macOS, Windows and Linux.