Search rowmedic

Remove DuplicatesFix Date FormatRepair CSVClean TextCSV ValidatorCSV to ExcelRemove Empty RowsClean Excel DataToolsUse CasesPricingBlogHelpWhich columns make a record unique?Read a broken CSV one record at a timeStandardize dates without swapping the month and day
rowmedic
← Home

Field notes

Practical guides to the small spreadsheet decisions that change your results.

Which columns make a record unique?

Use an order export to decide when exact duplicates are safe to remove and when a combination of key columns is a better match.

Read guide →

Read a broken CSV one record at a time

Recognize delimiter problems, quoted commas, and missing quotes by comparing a short CSV excerpt with the fields you expect.

Read guide →

Standardize dates without swapping the month and day

Identify the source date order, distinguish ambiguous values from impossible dates, and verify a spreadsheet date conversion.

Read guide →