About amountSplit
Drop a CSV or Excel file, choose the column that supplies each row's weight, and allocate shipping, a discount, a payment or any other total. The result works in integer minor units and gives leftover units to the largest remainders, with input order breaking exact ties, so the rounded row amounts always add back to the total. Zero weights and negative totals are supported. Download CSV or Excel, or copy the equivalent PostgreSQL, MySQL 8 or SQLite query. Runs in your browser.
Runs entirely in your browser: your SQL and files are not uploaded. Signed-in members can keep a history of runs and results.
Built on open-source libraries: Papa Parse, fflate.
From the makers
Pilotbase: one admin app for PostgreSQL, MySQL, MongoDB, Redis and more, with an AI agent built in.
Get Pilotbase freeMore free data tools
sqlBeautify
Format, highlight and fix SQL as you type
sqlCompare
Diff two SQL files like git, after formatting both
downtimeAlert
We check your URL, API or stats page every 30 seconds and email you when it's down
sqlTranslate
Convert SQL between 14 dialects
explainViewer
See where a Postgres query spends its time
keysetBuilder
Keyset pagination queries from your ORDER BY