Send feedback

Coming from the page: Merge Excel Files

One moment…

One sheet or one workbookMatches columns by headingNothing uploaded

Merge Excel Files

Choose Excel or CSV files, put them in order and get one file.

    Your files never leave your device: they are read and saved inside the browser.

    How to merge Excel files

    1

    Choose the files

    Choose two or more files (xlsx, xls, ods or csv) and order them with the arrows.

    2

    Pick how to merge

    All rows into one sheet, or every sheet as it is in one workbook.

    3

    Download

    Type a file name and press “Merge and download”.

    The two ways to merge

    WayWhat it doesGood for
    All rows into one sheetStacks the rows of every file and matches columns by heading: “City” meets “City” wherever it is, and a new heading adds a column.Files with the same columns, like each branch’s sales or each month’s report.
    Every sheet as it isCopies every sheet into one workbook under its own name, or its file’s name when the file has one sheet.Gathering separate reports into one file.
    What is kept and what isn’t? Values, numbers, dates and number formats are kept, and “Every sheet as it is” also keeps merged cells and column widths. Formulas come over as their calculated results, not as formulas. Colors, fonts, borders, images and charts are not kept, because the open-source spreadsheet engine we use (SheetJS) doesn’t write formatting.
    Your files stay on your device. Everything runs inside your browser: your files are not uploaded to any server and nothing is kept, and the tool keeps working offline once the page has loaded.

    FAQ

    How do I merge Excel files into one sheet?

    Choose the files, keep “All rows into one sheet” and press “Merge and download”. Each file’s first row is treated as headings, so it isn’t repeated in the middle.

    What if the columns are in a different order?

    No problem: columns are matched by heading, not position, ignoring extra spaces and letter case. If your files have no heading row, turn the option off to merge by column order.

    How do I know which file each row came from?

    Keep “Add a column with the source file name”: the file name (and sheet name when merging every sheet) appears in the first column.

    Are formulas and formatting kept?

    Formula results and number and date formats are kept, but not the formulas themselves, colors or fonts.

    Are my files uploaded to a server?

    No. The files are read and merged inside your browser and never leave your device.