How to Use Our Free Tools

Start by uploading two or more Excel files using the drag-and-drop zone on the home page. You can upload XLS (Excel 97-2003), XLSX (Excel 2007+), and CSV files — and even mix different formats in a single merge. Files are listed below the upload zone with their name, size, and detected sheets. You can reorder files by dragging the grip handle, or remove individual files with the delete button.

On the right side panel, select one of three merge modes: Single Spreadsheet stacks all data into one continuous sheet, perfect for combining similar data. Multiple Sheets places each uploaded file as a separate tab in one workbook, ideal for organizing data by source. Selective Merging lets you pick specific sheets from each uploaded workbook — great when files contain multiple sheets but you only need certain ones.

Customize how your merge works with advanced options. Choose Header Handling to control how column headers are treated — preserve only the first row's headers, add sheet name labels to identify data source, or skip header handling entirely. Set a custom Data Range by specifying start and end cells (e.g., A1 to Z1000) to merge only a portion of each file. Enable Preserve Formatting to keep original cell styles, colors, and formatting in the merged output.

When merging in Single Spreadsheet mode, the tool automatically analyzes column headers across all files. If columns do not match exactly — for example, 'Customer Name' in one file and 'Client Name' in another — a Column Mismatch dialog appears. You can map columns manually using dropdown menus, or click Continue As Is to merge without remapping. The tool suggests the best matches automatically.

When you upload Excel files with multiple sheets, the Sheet Selection panel appears below the merge options. For each file, you can check or uncheck individual sheets to include or exclude them from the merge. Use the All and None buttons for quick selection. Unchecked sheets will be skipped entirely during the merge process.

Once everything is configured, click the Merge Files button. The tool processes all your files locally in your browser — nothing is uploaded to any server. When the merge completes, a green success banner appears and the Download button becomes active. Click Download to save your merged XLSX file. You can also share the tool with colleagues using the social sharing buttons below.

Start by dragging and dropping two or more CSV, TSV, or text files into the upload area. The tool parses headers, line delimiters, and row counts instantly without uploading data to external servers.

Reorder your files by dragging them up or down in the file queue. The order in the list directly determines which file's records appear first in the combined master dataset.

Our engine aligns columns by header name, not by column position. If file A has "Email" in column 1 and file B has "Email" in column 4, the data aligns perfectly. Any mismatched headers can be linked with the interactive column mapping dialog.

Choose your desired output format: a single clean CSV file ready for database or API import, or an XLSX workbook for Microsoft Excel and Google Sheets. Click "Merge Files" to download instantly.

Upload a single Excel or CSV file using the drag-and-drop zone. The tool inspects your sheets, row counts, and column structure locally.

Select from 9 specialized modes: By Fixed Rows, By File Count, By Sheet Tab, By Column Value (e.g., Region, Department), By Blank Rows, By File Size, By Formula Type, By Expression, or By Date Range.

Use the Preview and Statistics tabs to inspect how the data will divide. Exclude blank lines, filter out unnecessary records, or save your settings as a reusable template.

Click "Split Now" to process. When complete, download individual split files or click "Download All as ZIP" for a single packaged archive.