Clean a Shelf Inventory CSV and Check the Export
Admin ·
Keep an original CSV available while you test cleaning decisions on a working copy. A short shelf inventory includes duplicate owners, padded identifiers, a quoted note, and an extra field beyond its header.
Trim the inventory before looking for duplicate rows
Load the example and confirm five original data rows. Apply Trim whitespace, then Remove duplicate rows with Ignore case selected. The cleanup log records one duplicate removal. The first 007 row keeps the owner Ana and the identifier keeps its leading zeros.
Choose Normalize dates on the Received column with month/day/year. The leap-day value 02/29/24 becomes 2024-02-29. The log reports one invalid date kept because February 30 cannot be assigned a calendar date.
RFC 4180 CSV field and record conventionsRFC 3339 full-date and valid calendar days
Fill and filter the rows the inventory needs
Apply Fill empty cells to Owner with Unassigned. To keep available items only, apply Filter rows, choose Condition and Equals, and enter available. The preview now includes records 2 and 5 from the source table.
Try preview search for a value in one of those rows. Download cleaned.csv and check that both rows still appear. Remove a column only if you want it excluded from the saved table.
Reopen the exported table and check quoting
Reset changes and compare the original preview with a fresh export. Record 6 has an extra source field under Column 6. That field stays in the CSV, while shorter rows are represented with empty cells.
Open the download with a CSV reader. The note Label reads "north, A" stays in one field, and the note on record 4 retains its internal line break. The header is an actual first record when First record is a header is selected.
Common questions
Does deduplication compare one column alone?
It compares all current columns. Remove columns you want excluded from the comparison first, after checking the original view.
Can I undo the last action without reloading the source?
Yes. Undo last action replays the prior steps from the loaded source. Reset changes clears the cleaning log.