Item quantity aggregator: sum by item and unit

Item quantity aggregator: sum by item and unit: purpose and instructions

Paste simple TSV to sum exact item and unit matches locally, retaining source counts and line numbers.

How to use

Paste the fixed Traditional Chinese header and up to 500 rows with tab-separated fields.
Correct missing fields, whitespace and invalid quantities, then calculate and check source lines.
Review duplicate warnings and copy plain text; recalculate after editing.

Frequently asked questions

Are identical items with different units combined?: No. Both item and unit must match exactly. Duplicate rows are added and flagged, without unit conversion or synonyms.
Is data saved or uploaded?: Data stays in page memory and is not uploaded or persistently saved; reloading clears it.

Related tools

Document Date Inventory — Sort recorded dates to help check source documents; this does not determine validity.
Required fields checker — Paste simple TSV with headers, choose required columns, and copy a report of blank fields by original line.
Group availability intersection finder — Merge each person's same-day availability and find shared intervals plus possible start ranges that fit the meeting length.
Serial Number Gap Checker — Check one number per line against a fixed-width range to find gaps, duplicates, out-of-range entries and format errors.
Inventory reconciliation — Check the book and actual quantity according to the product number, and list the shortages, surpluses and items to be reviewed.
Booking conflict checker — Check overlapping time periods for appointments with the same resource and on the same day, and retain the original sequence numbers for manual coordination.
Time zone meeting planner — Use Taipei time to compare with Tokyo, London and Los Angeles to check the complete date and daylight saving time.
Working days and deadlines — Calculate the interval days or delivery date according to the selected work rules.
Amount and date conversion — The amount, Republic of China and AD dates in Chinese capital letters, copy them as you like.
URL QR code generator — Check the complete public URL, generate a black and white QR Code in the browser and download the PNG.
List sorting and deduplication — Organize multi-line lists, items or codes and remove blank lines and duplicate items.
Double list comparison — Check the scheduled and actual lists, listing items that are only in A, both parties, and only in B.
Text version differences — Compare the two versions of the notice or process text line by line, and list the identical, new and deleted content.
Batch file name planner — Paste the file name, arrange the prefix, serial number and file extension, and take away the complete comparison table.
Meeting agenda schedule — Fill in the start time and topic minutes, and list the start and end time of each item and the complete agenda.
Random grouper — Paste the list of participants, specify the number of groups, and arrange random groups with a balanced number of people.
Countdown to work and meetings — Set a period of time, start, pause and continue the countdown, and clearly grasp the time.
Duty roster — Arrange the rotation according to the date, week and personnel order, and check the complete arrangement and the number of times per person.
StarShare cross-device file transfer — Transfer files, text and links between mobile phones and computers without installation or login.