Data & CSV
CSV percentage of total
Append each numeric value’s share of its column total.
A clear answer. Here’s how.
Adds 100×value/column total as a numeric percentage, without a percent sign. Blank source cells produce blank shares; other non-numeric values are rejected. Negative values are allowed, so shares can be negative or exceed 100. Requires a non-zero total and a unique new heading.
See a worked example
Worked example
A fixed demonstration, separate from the values you enter above.
- Your CSV data
ID,Name,Department,Amount,Date 001,Ada,Design,120,2026-01-05 002,Sam,Writing,80,2026-01-06 003,Jo,Design,150,2026-01-07 004,Lee,Writing,,2026-01-08 005,Alex,Design,60,2026-01-09
- Column separator
- Comma
- Numeric column
- Amount
- New percentage heading
- Percent of total
Example result
| ID | Name | Department | Amount | Date | Percent of total |
|---|---|---|---|---|---|
| 001 | Ada | Design | 120 | 2026-01-05 | 29.2682926829 |
| 002 | Sam | Writing | 80 | 2026-01-06 | 19.512195122 |
| 003 | Jo | Design | 150 | 2026-01-07 | 36.5853658537 |
| 004 | Lee | Writing | 2026-01-08 | ||
| 005 | Alex | Design | 60 | 2026-01-09 | 14.6341463415 |