Export the stock worksheet as a CSV feed
Prepare a flat stock file for a catalog import while preserving the original workbook.
Set up the example
Use the Stock sheet as the source. Check that the zone lookup sheet has not been appended as product records.
Check the result
Open the CSV and count three product rows. Pens, blue should remain one field when parsed.
Run this task
Use your own file or download the practice input below. The checks on this page describe the practice result.