Merge Excel files by stacking rows
Join several Excel or CSV files into one, putting each file's rows below the previous ones.
All tools
Pick the task you need to solve.
33 tools are available right now, out of a catalogue of 33.
Merge and split
6 of 6 availableJoin several files into one, break a workbook into pieces, or split a sheet by row count or by the value of a column.
Merge Excel files into sheets
Join several files into a single workbook, keeping each original file as its own sheet.
Combine all sheets of an Excel file
Merge every sheet of a workbook into one continuous table.
Split an Excel file by sheet
Turn a multi-sheet workbook into one separate file per sheet.
Split an Excel file by row count
Break a large spreadsheet into several files of N rows each.
Split an Excel file by column value
Produce one file per distinct value of a column: one per region, per salesperson or per month.
Format conversion
8 of 8 availableGo from Excel to CSV, JSON, SQL, PDF, HTML or XML and back, choosing delimiter and encoding so it opens correctly wherever you need it.
Convert Excel to CSV
Convert an Excel file to CSV, choosing the separator and the encoding so it opens correctly in any program.
Convert CSV to Excel
Turn a CSV into an .xlsx file, detecting delimiter and encoding automatically.
Convert Excel to JSON
Turn a spreadsheet into JSON with one property per column, ready for an API.
Convert JSON to Excel
Turn an array of JSON objects into a spreadsheet with one column per property.
Convert Excel to SQL
Generate INSERT statements from your spreadsheet, using the table name you choose.
Convert Excel to PDF
Turn your spreadsheet into a PDF with fitted columns and the header repeated on every page.
Convert Excel to HTML
Turn your spreadsheet into an HTML table ready to paste into a web page.
Convert Excel to XML
Turn your spreadsheet into XML, with one element per row and a nested one per column.
Cleaning and transformation
10 of 10 availableStrip duplicates and blank rows, normalise dates and numbers, unpivot cross-tabs and replace text in bulk.
Clean spreadsheet data
Strip stray spaces, collapse double spaces and normalise upper and lower case.
Remove duplicate rows in Excel
Strip repeated rows from an Excel or CSV spreadsheet, comparing every column or only the ones you pick.
Remove empty rows and columns
Strip the rows and columns that hold no data at all.
Normalise dates in Excel
Unify into a single format the dates that arrived mixed from several sources.
Convert numbers stored as text
Turn into real numbers the cells Excel treats as text and therefore cannot sum.
Transpose an Excel table
Swap rows for columns, rotating the orientation of the whole table.
Unpivot an Excel table
Turn a cross-tab (months or categories spread across columns) into the tabular shape that pivot tables and every analysis tool expect.
Find and replace in Excel
Replace text across a whole spreadsheet, or several at once, without opening them one by one.
Fill down in Excel
Copy each cell's value into the empty cells beneath it, up to the next value.
Split or merge text columns
Break a column by a delimiter, or join several into one with the delimiter you choose.
Analysis and comparison
6 of 6 availableCompare two spreadsheets cell by cell, join them on a key column, summarise columns and spot data quality problems.
Compare two Excel files
Show the cell-by-cell differences between two spreadsheets, highlighting what changed.
Join two Excel files on a key column
Merge two spreadsheets on a shared column, like a VLOOKUP but without formulas.
Column statistics summary
Compute sum, average, minimum, maximum, count and nulls for every numeric column.
Group and count by value
Count how often each value of a column appears: a pivot table in one click.
Highlight duplicates in Excel
Colour the repeated rows or cells without deleting them, so you can review them yourself.
Data quality report
Detect nulls, inconsistent types and outliers, and tell you which column has the problem.
Advanced utilities
3 of 3 availablePull tables out of a PDF, consolidate monthly sheets into a yearly one, and remove sheet protection from your own files.
Extract PDF tables to Excel
Rebuild into a spreadsheet the tables trapped inside a PDF.
Consolidate monthly spreadsheets
Join twelve monthly files into a yearly consolidation, with totals computed.
Remove Excel sheet protection
Remove sheet protection from YOUR OWN files when you have lost the password.