REPORT MERGER
by Five Minute Office

Merge several CSV and Excel files into one clean report, with a summary and an email draft.
Your files never leave your computer. The tool is a single web page that works offline.

WHAT YOU NEED
- A computer with Chrome or Edge (recommended). Firefox also works in our tests; see BROWSERS TESTED below.
- Excel or another spreadsheet program to open the result.
- No installation, no account, no internet connection, no extra cost.

TIME (an estimate)
About 10 minutes the first time, about 2 minutes afterwards. These are estimates, not measured times.

STEPS

1. Extract the zip first. Right-click report-merger-v1.zip and choose "Extract All" (Windows) or double-click it (Mac).
   Do not open the page from inside the zip: it will not work properly.

2. Open the extracted folder and double-click report-merger.html. It opens in your browser.
   If it opens in a different browser than Chrome or Edge, right-click the file, choose "Open with", then pick Chrome or Edge.

3. To try it first, click "Try it with sample files", or use the 8 files in the sample-files folder:
   drag them all onto the dashed box, or click "Choose files" and select them all (Ctrl+A in the file window).

4. Look at the line under "Merged report", for example "109 imported, 96 in report, 13 removed".
   Click it to see, file by file, how many rows were duplicates, empty rows or repeated header rows.
   Rows imported, minus the removed rows, equals the rows in the report.
   "Source files" in the top right hides or shows the list of files.
   The Columns tab lists every column, how many rows are filled, and which files do not have it
   (for example "Missing in 2 of 8 files": click it to see the file names).

5. Options: "Remove duplicate rows" and "Add Source file column" are on by default. Untick them if you do not want them.

6. Optional summary: in the Summary tab pick "Group rows by" (for example Store Name) and "Add up" (for example Sales).
   A table appears, largest sum first, with a total at the bottom. The top 3 also go into the email draft.

7. Click "Download Excel" to get merged-report-YYYY-MM-DD.xlsx (sheets: Merged, Summary if you chose a grouping, Files).
   Click "Download CSV" for the merged data only.
   The file is saved in your browser's download folder, usually "Downloads". Your browser may ask where to save it.
   If it asks, or if you cannot find the file, open the downloads list in the browser (Ctrl+J) and click the file.

8. When you open the xlsx in Excel, a yellow bar "Protected View" may appear. Click "Enable Editing".
   This is normal for files that were downloaded.

9. In the Email tab, edit the draft if you like. Click "Copy text" and paste it into your email program,
   or click "Open in email app": it opens a new email with the subject and text filled in.
   Attach the Excel file yourself (the "Download" button next to it saves it). The tool never sends anything.
   If Copy does not work, click inside the text box, press Ctrl+A to select the text, then Ctrl+C to copy it.
   Your own changes to the draft are kept when files change; click "Refresh draft" to get the new numbers.

Now do the same with your own files. "Add files" adds to the files already loaded, "Replace all" starts over,
and the x next to a file removes it. Sample files are replaced as soon as you add your own.

GOOD TO KNOW
- Supported files: .csv, .xlsx, .xls. Up to 50 files and 200,000 rows in total.
- In an Excel file with several sheets, the first sheet that has data is used. The tool shows which one.
- The first non-empty row of each file is read as the column names. Columns with the same name are matched
  even if written differently ("Store Name", "store_name", "STORE-NAME").
- Numbers written as text in US format ("1,234.50", "$1,234.50") become real numbers.
  European format ("1.234,50") is not supported.
- Dates written as 2026-11-09 (year-month-day) become real dates. Other date formats, such as 09/11/2026, stay as text.
- A file that cannot be read appears in red with the reason; the other files continue.

WHAT IT DOES NOT DO
- It does not read PDFs.
- It does not send emails. It only writes a draft you can copy.
- European number formats like "1.234,50" stay as text.
- Only the first sheet with data in each file is merged.
- Columns are joined only when their names match after ignoring upper/lower case, spaces and the characters _ - .
  For example, it will not join "Contact Name" with "Name".
- Browsers that were not tested are not supported yet (see the next section).

BROWSERS TESTED
Automated tests ran on Windows with Chrome, Edge, Firefox and WebKit (the engine behind Safari, tested through Playwright).
Safari itself was not tested, and neither were other browsers or phones and tablets. They are not supported yet.

OPEN-SOURCE NOTICE
This page contains SheetJS Community Edition 0.20.3, copyright SheetJS LLC, licensed under the Apache License 2.0
(https://www.apache.org/licenses/LICENSE-2.0). The license text is in LICENSE-SheetJS.txt.
