Solve Excel Problems Online
Clean, compare, calculate and transform spreadsheet data directly in your browser.
Focused help for spreadsheet tasks
These tools are on the dotXLS roadmap. Preview their place while the processing engine is built.
Excel Data Cleaner
Clean common spreadsheet problems directly in your browser.
activeCompare Excel Columns
Compare two spreadsheet columns and quickly find matches, differences, and missing values.
activeRemove Duplicate Rows
Find and remove duplicate spreadsheet rows directly in your browser.
activeCSV to Excel Converter
Convert CSV files to Excel XLSX directly in your browser.
activeSplit Column
Separate combined values into useful columns.
activeMerge Columns
Combine values with predictable formatting.
activeSort Data
Sort worksheet rows while keeping every row together.
activeFilter Data
Filter complete worksheet rows using conditions from one column.
activeFind & Replace
Find spreadsheet values and replace them safely in the current worksheet.
activeTrim & Clean Text
Trim spaces and clean common hidden or repeated whitespace from worksheet text.
activeRemove Blank Rows
Find and remove empty spreadsheet rows without disturbing the header or remaining data.
activeRemove Empty Columns
Find and remove spreadsheet columns that contain no data below the header.
activeFill Blank Cells
Fill missing worksheet cells with a fixed value or nearby data.
activeConvert Text to Numbers
Detect numeric text and convert safe values to real spreadsheet numbers.
activeTranspose Data
Switch spreadsheet rows and columns while preserving cell values.
activeRemove Line Breaks
Find and remove line breaks inside spreadsheet cells with a safe replacement.
activeConvert Text to Dates
Detect recognizable date text and convert safe values to real spreadsheet dates.
activeRemove Formulas Keep Values
Replace Excel formulas with their current calculated values while preserving the visible results.
activeExtract Numbers from Text
Extract number sequences from mixed spreadsheet text into a clean result column.
activeExtract Text from Cells
Extract text from mixed alphanumeric spreadsheet cells into a clean result column.
activeFind Duplicate Values
Find repeated values in one spreadsheet column and mark every duplicate occurrence.
activeHighlight Duplicate Values
Highlight repeated values in one spreadsheet column and preserve the highlight in Excel export.
activeRemove Special Characters
Remove unwanted punctuation and symbols from spreadsheet text while keeping the characters you need.
activeSplit Full Name into Columns
Split full names into separate first, middle, and last name columns.
activeAdd Prefix / Suffix to Cells
Add custom text before or after spreadsheet cell values in a selected column.
activeDelete Rows Containing Specific Text
Find and delete complete spreadsheet rows that match text in a selected column.
activeDelete Rows with Blank Cells
Delete complete spreadsheet rows when a selected column contains a blank cell.
activeRemove Rows with Errors
Find spreadsheet error values and remove the complete affected rows safely.
activeExcel Lookup & Join
Match a key between two worksheets and bring selected lookup columns into your source data without formulas.
activeGroup & Summarize Data
Group spreadsheet rows and create a summarized table using common aggregations without formulas or PivotTables.
activeUnpivot Data
Convert wide spreadsheet columns into normalized attribute and value rows for analysis and reporting.
activePivot Data
Convert long spreadsheet rows into a wide pivot table with configurable aggregation.
activeAppend / Stack Tables
Combine rows from multiple Excel worksheets into one aligned table by matching column headers.
activeCompare Excel Worksheets
Compare two Excel worksheets by key and identify added, removed, modified, and unchanged records.
activeRemove Duplicate Columns
Find and remove duplicate spreadsheet columns while preserving the header and unique columns.
activeSplit Worksheet by Column
Split one worksheet into separate worksheets based on unique values in a selected column.
activeMerge Duplicate Rows by Key
Consolidate duplicate records by key while filling complementary blank values and reporting conflicts.
activeFind Missing Numbers in Sequence
Find gaps, duplicates, and missing values in a numeric spreadsheet sequence.
activeCombine Columns
Combine values from two or more spreadsheet columns into one clean result column.
A clear path from input to result
Start with the outcome you need
Clean Data
Remove inconsistencies and prepare tables for use.
Transform Data
Reshape text, columns and spreadsheet structure.
Calculate
Solve focused spreadsheet calculations.
Create
Generate formulas and useful spreadsheet outputs.
Convert
Move tabular data between practical formats.
Bring your spreadsheet problem to dotXLS.
dotXLS is being designed to solve focused spreadsheet tasks directly on the page, with clear controls and results you can inspect before export.