Excel File Merger
Combine many Excel or CSV files into one sheet, or into one workbook with a sheet per file. Matching columns line up automatically.
๐ Runs in your browserโก Instant results๐ค No sign-upโญ Downloads with Pro
Frequently asked questions
What if my files have different columns?
Columns with the same header name are lined up automatically. Any extra columns are added on the end, and rows without them are left blank.
Can I merge CSV and Excel files together?
Yes. You can mix .csv, .xlsx, .xls and .ods files in one merge.
Is there a file limit?
There is no fixed limit. Merging happens in your browser, so very large merges depend on your device memory.
More data analysis & spreadsheet tools
๐
Excel Data AnalyserInstant KPI dashboard, insights, report & slides
๐Instant DashboardPower BI style dashboard from any Excel file
๐CSV โ Excel ConverterConvert CSV, XLSX, XLS, ODS and JSON
๐งฉExcel File MergerCombine many spreadsheets into one
๐งนDuplicate RemoverFind and delete duplicate rows
๐Chart MakerPaste data, get a chart, download PNG or PowerPoint
๐๏ธExcel to SQLCREATE TABLE & INSERT statements from any spreadsheet
๐งฎSQL Query BuilderBuild SQL with clicks, explained in English, run on your data
โจSQL FormatterMake messy SQL clean and readable
๐งฝData CleanerFix spaces, capitals, text numbers, dates, blanks and duplicates
๐VLOOKUP / Merge Two SheetsMatch two files on a shared column, no formulas
๐Compare Two Excel FilesSee added, removed and changed rows and cells
๐งPivot Table BuilderGroup, total and chart your data with clicks
๐Web Table to ExcelCopy tables from websites into clean Excel
๐ฃJSON โ Excel ConverterFlatten JSON into a spreadsheet, or Excel into JSON
๐UK Postcode Lookup (Bulk)Add council, region and lat/long to postcodes
๐Unpivot / Reshape DataColumns to rows and back, ready for Power BI
๐ฏOutlier FinderSpot unusual values, typos and errors
๐Statistics CalculatorMean, SD, correlation, t-test, chi-square explained
๐ฒRandom Sample PickerRandom rows for audits, surveys and prize draws
๐ง DAX Measure GeneratorYTD, YoY %, rank and % of total for Power BI
๐
Date Table GeneratorPower BI / Excel calendar with UK bank holidays
๐งฉExcel Formula BuilderXLOOKUP, SUMIFS, IF and more in plain English
โ๏ธPower Query SnippetsCopy-paste M code to clean and reshape data
๐๏ธSQL PlaygroundRun SQL queries and JOINs on Excel & CSV files
๐Large CSV ViewerOpen & filter CSVs with millions of rows
โ๏ธSplit Excel by ColumnOne sheet or file per region, rep or month
๐Fuzzy Match (Fuzzy VLOOKUP)Match similar names between two lists
๐ก๏ธData AnonymiserMask, hash or code personal data for GDPR
๐Extract Emails, Phones & PostcodesPull contact details out of any text or file
๐ฎForecast & RegressionSales forecast and what drives your numbers
๐RFM Customer SegmentsFind champions, loyal and at-risk customers
๐Cohort RetentionHow many customers come back month by month
๐
ฐ๏ธABC / Pareto AnalysisThe 20% of products that make 80% of sales
โ๏ธA/B Test CalculatorIs version B really better? p-value and sample size
๐งชTest Data GeneratorRealistic fake UK data for testing and demos