Make an inventory workbook from a quoted CSV
Give a warehouse reviewer a spreadsheet with each identifier and item in its own cell.
Set up the example
Convert the CSV to XLSX, then inspect the cell containing Pens, blue in the new workbook.
Check the result
There should be four columns and three product rows. Confirm that B04 has quantity 8 rather than a shifted column.
Run this task
Use your own file or download the practice input below. The checks on this page describe the practice result.
Continue with a related task
- Clean a CSV and create an Excel workbook
Trim cells and remove blank rows → Write the cleaned table to XLSX
- Print stock and zone worksheets from Excel
- Flatten repeating XML stock records into CSV
- Trim padding and blank rows in a stock list
- Extract SKU and unit counts from a larger CSV