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 files”

Steps

  1. Drop the monthly files on "Merge CSV files" 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 and reorder 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. The "Network" chip in the bar lists the connections this page can see (connections from background workers, WebSocket and WebRTC are not on that list; this site works in a background worker). What goes out is set out at https://orihako.com/trust/.

The CSV is never uploaded; everything runs in this browser.