Tiếng Việt

Merge Excel files

Combine Excel files from several branches or months: keep every sheet separate, or append all rows into one sheet for filtering and pivot tables.

.xlsx, .xlsm or .csv; up to 50 MB in total. Reorder with the arrow buttons.

    Mode

    Files are processed on your device and never uploaded. Images and charts are not copied.

    How to use it

    1. Choose the files (.xlsx, .xlsm, .csv) and set their order.
    2. Choose a mode: keep each sheet, or append into one sheet.
    3. For appending, set the number of header rows and whether to add a source column.
    4. Click "Merge files" and download the result.

    Keep each sheet

    Every sheet is copied into the new file, named after its file. Cell formatting, column widths, merged cells and same-sheet formulas are kept; formulas pointing at other sheets become values.

    Append into one sheet

    Rows are stacked under the first sheet’s header; later headers are skipped and formulas become values. An optional "Source" column records each row’s file and sheet. Sheets with different headers are listed so you can check the columns.

    Frequently asked questions

    What is not copied?

    Images, charts, pivot tables, macros, conditional formatting and data validation. Old .xls files must be saved as .xlsx first.