Preserve a comma inside an item name
Illustrative inputs, not verified product specifications or care recommendations.The household question
A descriptive name includes punctuation that would otherwise create an extra column.
Measurements and assumptions
name,quantity,unit,location
"Bolts, nuts and washers",12,items,WorkshopCarry out this task
- Open Bulk QR Label Generator and paste the exact CSV shown.
- Choose Preview CSV, inspect validation, then Import validated CSV.
- Enclose the comma-containing name in double quotes.
Calculation and observed tool result
One record is imported with the complete name Bolts, nuts and washers and quantity 12.
What the result means
The quoted comma belongs to the name instead of splitting the CSV row.
A mistake to avoid
An unquoted comma would create the wrong column count.
Limits of this example
Counted items still require a clear physical counting boundary.
Open Bulk QR Label Generator · How to Create and Use Household QR Labels