EXCEL TUTORIAL · PREPARE · CLEAN · BUILD
Contents
Make spreadsheet work easier
Free online tools to clean CSV files, transform spreadsheet data and build Excel formulas. Choose a tool and preview the result before exporting.
Free online tools · Browser processing · No account needed
50free spreadsheet toolsFrom messy data to your next worksheet.
Showing all 50 tools.
No tools match your search. Try a different task or reset the search.
Clean and prepare CSV data
Clean CSV data, remove duplicates and standardise cells before importing.
Cleanup
CSV Cleaner Online
Trim field whitespace and remove empty CSV rows in your browser.Open tool
Cleanup
CSV Delimiter Converter Online
Convert comma, tab, semicolon, or custom delimiters while preserving quoted values.Open tool
Cleanup
CSV to UTF-8 Converter Online
Decode a local CSV file in a selected character encoding and export UTF-8.Open tool
Cleanup
Find Duplicate CSV Rows Online
Find all rows belonging to duplicate groups, with source row numbers and occurrence counts.Open tool
Cleanup
Remove Duplicate CSV Rows Online
Remove repeated rows while preserving the first occurrence and row order.Open tool
Cleanup
Split CSV Columns Online
Split one column into several using a literal text separator.Open tool
Cleanup
Merge CSV Columns Online
Combine selected columns into a new final column with a chosen separator.Open toolTransform spreadsheet data
Convert dates, preserve numeric identifiers and transform spreadsheet columns.
Workflows
Date Format Converter Online
Convert explicitly formatted dates in selected spreadsheet columns without guessing the day and month order.Open tool
Workflows
Preserve Leading Zeros in CSV
Pad numeric identifiers to a chosen minimum width and prepare them for import into Excel as text.Open tool
Workflows
Merge CSV Files Online
Combine two CSV tables vertically and align their columns by header name.Open tool
Workflows
Split CSV Files Online
Split a CSV into smaller files by data-row count, with the header repeated in every part.Open tool
Workflows
Find and Replace in CSV Columns Online
Find and replace text in selected columns while keeping the header row unchanged.Open tool
Workflows
Text Case and Whitespace Cleaner Online
Convert text case and remove extra whitespace in selected spreadsheet columns.Open tool
Workflows
Online Pivot Table Generator
Group spreadsheet rows by one or more columns and calculate sums, row counts or averages.Open toolReshape tables and build formulas
Reshape data, build formulas and prepare lookup operations.
Formulas
Unpivot a Table Online
Turn a wide table into tidy identifier, variable and value rows, ready for filtering or analysis in Excel.Open tool
Formulas
Join Two Tables Online
Merge two pasted tables by a chosen key with left, inner or full joins, duplicate diagnostics and unmatched row counts.Open tool
Formulas
XLOOKUP & VLOOKUP Formula Builder
Build a lookup formula from validated cell and range references, with exact or approximate matching and a choice of argument separator.Open tool
Formulas
SUMIFS & COUNTIFS Formula Builder
Build a multi-criteria sum or count formula with safely quoted criteria and checks for matching range dimensions.Open tool
Formulas
IF & IFS Formula Builder
Build nested IF or IFS formulas from ordered simple conditions, preserving numeric values and safely escaping text.Open tool
Formulas
Excel Formula Separator Converter Online
Convert comma and semicolon argument separators while preserving quoted text, sheet names and array constants.Open toolCompare and organize tables
Reshape, sort and filter tables into a useful worksheet layout.
Tables
Compare Spreadsheet Data Online
Compare two CSV tables by a unique key and report changed, added, and removed rows.Open tool
Tables
CSV Validator Online
Check CSV data against your explicit header, type, and blank-value rules.Open tool
Tables
Rename CSV Columns Online
Rename CSV headers using explicit source-to-target mappings.Open tool
Tables
Reorder CSV Columns Online
Reorder columns by number and optionally exclude unlisted columns.Open tool
Tables
Filter Spreadsheet Rows Online
Keep rows matching a text, numeric, or date condition in a selected column.Open tool
Tables
Sort Spreadsheet Rows Online
Sort CSV rows stably by text or numeric values while optionally preserving a header.Open tool
Tables
Transpose Spreadsheet Data Online
Turn CSV rows into columns and columns into rows.Open toolExcel dates and formula helpers
Convert dates and values and prepare spreadsheet references.
Helpers
Excel Date Serial Converter Online
Convert calendar dates and fractional Excel serial numbers using the 1900 or 1904 date system.Open tool
Helpers
Business Day Calculator
Count inclusive business days or add working days using your weekend mask and entered holiday dates.Open tool
Helpers
Excel Cell Reference Converter Online
Convert a cell or range between absolute, relative and mixed A1 references and show R1C1 relative to an origin cell.Open tool
Helpers
LEFT, RIGHT & MID Formula Builder
Build a text extraction formula with validated cell references, character lengths and MID start positions.Open tool
Helpers
Excel Percentage Change Formula Builder
Build a percentage change formula with an explicit choice for a zero baseline.Open tool
Helpers
Excel Rounding Formula Builder
Build ROUND, ROUNDUP or ROUNDDOWN formulas with validated digits and cell references.Open tool
Helpers
Excel Number Format Code Generator
Generate custom number, currency, percent and date format codes with a sample display preview.Open toolCheck data quality and analyze values
Check spreadsheet data for missing values and consistency.
Quality
Find Missing Spreadsheet Values Online
Count empty cells in every column and optionally list the source row of each missing cell.Open tool
Quality
Spreadsheet Number Format Normalizer Online
Convert numbers from explicitly chosen source separators to a dot decimal without thousands grouping.Open tool
Quality
Find Missing Numbers in a Sequence Online
Find missing integer ID ranges and duplicate IDs without generating enormous lists of missing numbers.Open tool
Quality
Value Frequency Table Generator Online
Count distinct values in a selected spreadsheet column and show each value’s percentage.Open tool
Quality
Weighted Average Calculator
Calculate a weighted mean from numeric values and nonnegative weights, with per-row contributions.Open tool
Quality
Correlation and Regression Calculator
Explore Pearson correlation and a simple least-squares linear fit between two numeric columns.Open toolAdditional spreadsheet and data tools
Free online calculators and Excel formula builders for statistics, schedules and everyday spreadsheet work.
Additional tools
Standard deviation calculator
Compute sample/population variance and SD, count, mean and Excel formula; robust numeric input.Open toolAdditional tools
Z-score calculator
Calculate a standardized score from a value and an entered mean and standard deviation.Open toolAdditional tools
Percentile calculator
Calculate inclusive or exclusive percentiles with linear interpolation and an Excel formula.Open toolAdditional tools
Excel weekly schedule generator
Generate editable timed weekly schedule with conflict detection and CSVexport; distinct fromdatedayscalculator.Open toolAdditional tools
Excel age and date difference calculator
Calculate complete years, months and days between Gregorian dates and see Excel formulas.Open toolAdditional tools
TEXTJOIN formula builder
Build TEXTJOIN with delimiter, ignoreempty and validatedranges, show exactpreview fromenteredstrings.Open toolAdditional tools
Quartile and IQR calculator
Sorted dataset quartiles with explicit inclusive interpolation, fences and outlier rows; Excel formula.Open toolAdditional tools
LET formula builder
Build validated LET variable definitions and finalexpression, copy/download with versionnotes, does notexecute arbitrary formulas.Open toolAdditional tools
LAMBDA formula builder
Build named parameter LAMBDA with call example and formulaexport,validate identifiers.Open toolAdditional tools