Orihako Data

Merge monthly CSV exports into one file

January to December, one export each. To total the year, combining them into one file first is faster and safer than pasting twelve sheets into Excel.

Open Merge CSV

Steps

  1. Drop the monthly files on "Merge CSV" together. They are taken in file-name order.
  2. Check that the headers match. If one month has its columns in a different order, they are matched by name.
  3. Even with mixed encodings, the result is one file that opens cleanly in Excel (UTF-8 with BOM).
  4. Hand it to "Pick columns" to keep only what you need; the summary sheet gets lighter.

Questions

What if the headers differ between months?
Columns are matched by header name. A column present in only some files stays, with blanks in the others; nothing is dropped. The first rows of the result are shown to check.
Is the data uploaded?
No. The merge happens in your browser; press "Network" in the bar to see for yourself.

The CSV is never sent anywhere; everything runs in this browser.