Continue to WhatsApp?

The chat opens in WhatsApp, in the app or in a new tab. You leave our website, and data such as your IP address is sent to WhatsApp (Meta).

FILES · WORKSHEETS · NO UPLOAD

Merge several Excel files into one table.

Drop in all files at once and download one table. Columns are matched by heading, even when every file is sorted differently. No Power Query, no macro, no upload.

MERGE EXCEL FILESFiles stay on your device

You addSeveral Excel files or worksheets, even with columns in a different order

You getOne table with every row and a Source column, as an Excel file

Choose your files

Your files

Drag several Excel, CSV or PDF files here at once, or choose them. A workbook with several sheets works too.

Which files work?

Excel (XLSX, XLS, ODS), CSV or a PDF with a table. Up to 50 files at once, each up to 5 MB, 10 MB for PDF, and up to 20,000 rows.

Your result is ready.

An AI helper can do this work for you

If this is a regular task, we set up an AI helper that does it automatically. A free assessment tells you whether it pays off for you.

SOUND FAMILIAR?

Twenty files, one report and a long afternoon of copy and paste.

“Every branch sends its own list.”

The same job every month: open the file, select, copy, paste at the bottom, next file. And somewhere a row goes missing.

With the tool: Drop in all files at once. For each file you see how many rows were read and merged.

“The Vienna file has the columns the other way round.”

One file has quantity before revenue, the next the other way round. When pasting, numbers land in the wrong column and nobody notices.

With the tool: Columns are matched by their heading, not by position. Item no. and Item No count as the same column.

“Power Query is too complicated for me.”

The professional tool exists, but if you need it once a month you have to figure it out again every time.

With the tool: Choose the files, check the result, download. Total rows are recognised so nothing is counted twice.

Do the files arrive every month?

Then an office helper collects the files from the inbox or a folder, merges them and saves the finished report. You only look at the result.

Learn moreAutomate Excel work

Matched by heading.

The tool reads every file and every worksheet and stacks all rows. The heading decides which column a value belongs to. Columns that only some files have are kept and stay empty where they are missing. The Source column shows which file each row comes from.

Do all files need the same layout?

No. The order and number of columns may differ. Identical headings are merged, and upper or lower case, spaces and punctuation make no difference. Anything that only one file has gets its own column.

Can I merge the worksheets of one file?

Yes. If a workbook has several sheets, every sheet with content is merged. The Source column then names the file and the sheet. Empty sheets are skipped.

What happens to total rows?

Rows that start with Total, Sum, Summe or Gesamt are recognised and left out, so Excel does not count anything twice in the merged table. If you need them, tick Keep total rows.

Are leading zeros kept?

Yes. Numbers like 00412 stay text and keep their zeros. Amounts and quantities are saved as real numbers in the Excel file, so sums and filters work right away.

Which formats and limits apply?

XLSX, XLS, ODS, CSV and PDFs with a table. Up to 50 files at once, each up to 5 MB, 10 MB for PDF, and up to 20,000 rows.

Are my files uploaded?

No. The file is processed right in your browser. Contents and results are not sent to our server. Visiting the website itself creates the usual technical connection data.

LET'S TALK ABOUT YOUR WORKFLOW

Write to us. We reply personally.

A question, an idea or a task that costs time every week? A few sentences are enough. You get an honest answer from the people who also build your office helper.

Ivan, Lukas & JanReply within 1–2 working days

  • Personal reply
  • No obligation
  • Based in Vienna, GDPR aware
Photo of Ivan
Rather talk directly?Ivan, your contact person+43 676 59 40 027office@pebblebyte.comMon to Fri 08:00–18:00
Have a specific task? Get your free workflow check

Your message

Please do not enter passwords or confidential customer data. We only use your details to handle your request. No newsletter, no sharing for advertising. Details in our privacy notice.