ConvertCSV
For small cell edits: the tested CSV Viewer and Editor route preserved all expected fields in our sample.
Keep in mind: Use a source copy and verify the saved file; the test does not cover every CSV or large files.
Explore ConvertCSV ↗Edit a CSV without losing leading zeros, then compare the saved IDs with a second list.
Use a CSV editor to change individual fields. Open the original and edited ID columns in Compare Two Lists to see which IDs were added or removed.
For small cell edits: the tested CSV Viewer and Editor route preserved all expected fields in our sample.
Keep in mind: Use a source copy and verify the saved file; the test does not cover every CSV or large files.
Explore ConvertCSV ↗A useful failure case: the tested CSV-to-CSV route split quoted content and produced invalid exports.
Keep in mind: Do not use this historical route for the tested quoted-field task without a new passing check. Other conversions were not tested.
Explore TableConvert ↗For the next step: compare one ID column to find missing, shared and duplicate values.
Keep in mind: Select the ID column in each file and exclude the header. Expand a repeated ID to see its source rows.
Explore Compare Two Lists ↗Collection edited . Individual test dates and limits are shown above. Explore another collection ↗