Clean and validate a product spreadsheetHON SIONG LAM
Delivery: 3 calendar days after source-file inspection, rule confirmation and project funding.
Included: One CSV or XLSX file with one worksheet, up to 500 data rows and 10 columns, processed as values. One revision covers corrections against the original file and agreed rules. New files or new rules need a separate quote.
Receive a consistent product data file plus a readable record of changes. I normalize agreed text and numeric formats, identify duplicate keys, and flag missing or ambiguous values. Leading-zero identifiers remain identifiers. Different currencies remain distinct. Dates that could be read in more than one way are kept for confirmation.
Deliverables:
Cleaned CSV and XLSX, where appropriate for the source.
Original source kept separately.
Row-level change and exception log.
Short reconciliation showing input rows, retained rows and any explicitly approved exclusions.
Before starting, please provide:
The source file and the meaning of each column.
Your duplicate-matching rule and whether confirmed duplicates should be retained or removed.
The expected date convention, number convention and currency labels.
A target template, if the output must follow one.
AI-assisted preparation may send source content to external AI services. This offer accepts only non-sensitive product/catalogue data that you have the right to share and authorize for that workflow. Confirm your data-processing requirements before the project is accepted. No promise of fully local processing or a particular AI-provider retention policy is included.
The fixed scope processes cell values. Formula reconstruction, external links, merged-layout repair, password-protected files, macros, account access, scraping and changes inside a live store need separate assessment and are not included.
Acceptance:
The agreed rules are applied, every source row is accounted for, identifiers and amounts remain traceable, and unresolved values are listed rather than invented. Any removal or merge must follow the agreed duplicate policy.
Synthetic workflow example (self-initiated demonstration, not client work):
https://contra.com/p/ANssN6U7-product-catalogue-cleanup-with-complete-row-traceability
HON SIONG's other services
Clean and validate a product spreadsheetHON SIONG LAM
Starting at$60
Duration3 days
Tags
Microsoft Excel
Delivery: 3 calendar days after source-file inspection, rule confirmation and project funding.
Included: One CSV or XLSX file with one worksheet, up to 500 data rows and 10 columns, processed as values. One revision covers corrections against the original file and agreed rules. New files or new rules need a separate quote.
Receive a consistent product data file plus a readable record of changes. I normalize agreed text and numeric formats, identify duplicate keys, and flag missing or ambiguous values. Leading-zero identifiers remain identifiers. Different currencies remain distinct. Dates that could be read in more than one way are kept for confirmation.
Deliverables:
Cleaned CSV and XLSX, where appropriate for the source.
Original source kept separately.
Row-level change and exception log.
Short reconciliation showing input rows, retained rows and any explicitly approved exclusions.
Before starting, please provide:
The source file and the meaning of each column.
Your duplicate-matching rule and whether confirmed duplicates should be retained or removed.
The expected date convention, number convention and currency labels.
A target template, if the output must follow one.
AI-assisted preparation may send source content to external AI services. This offer accepts only non-sensitive product/catalogue data that you have the right to share and authorize for that workflow. Confirm your data-processing requirements before the project is accepted. No promise of fully local processing or a particular AI-provider retention policy is included.
The fixed scope processes cell values. Formula reconstruction, external links, merged-layout repair, password-protected files, macros, account access, scraping and changes inside a live store need separate assessment and are not included.
Acceptance:
The agreed rules are applied, every source row is accounted for, identifiers and amounts remain traceable, and unresolved values are listed rather than invented. Any removal or merge must follow the agreed duplicate policy.
Synthetic workflow example (self-initiated demonstration, not client work):
https://contra.com/p/ANssN6U7-product-catalogue-cleanup-with-complete-row-traceability
HON SIONG's other services
$60