First Deposit
First Deposit Tools
Process first deposit data — merge CSV files, convert to aggregated JSON, and generate styled Excel reports.
Tools — 3 steps
Step 1
Merge CSV
Combine multiple CSV files into one. Header from the first file, all data rows merged.
↗Step 2
CSV to Query JSON
Convert merged CSV into aggregated JSON — GROUP BY Agent with SUM, COUNT, and COUNTIF.
↗Step 3
Create Excel Report
Generate a styled Excel report from JSON query result and reference data CSV.
↗