Browse categories
Explore
Fiverr Pro
English
$
USD
I will clean your excel or CSV data and deliver an auditable report
我是一位技术熟练的专业人士，擅长Java编程和SQL数据库管理。我对办公软件有深入的理解和使用经验，能够高效地处理各种文档和数据。此外，我还具备玄幻小说英语翻译的能力，可以将复杂的故事情节和人物性格准确地传达给读者。在图像处理方面，我熟练使用Photoshop进行图片编辑和设计。我相信这些技能将使我在未来的工作中发挥重要作用。我期待有机会将这些技能应用到实际中。
About this Gig
Turn a messy order table into clean data you can check.
I normalize agreed date formats, amounts and labels, remove exact duplicates under your confirmed unique key, and separate invalid or conflicting records. Missing amounts are never replaced with zero. Conflicting IDs stay out of totals until confirmed.
Basic: 1 file, up to 100 rows / 10 columns; cleaned CSV, exclusions, change log and offline HTML report.
Standard: up to 1,000 rows / 20 columns; Basic outputs plus an Excel report and 2 group summaries.
Premium: up to 10,000 rows / 30 columns; Standard outputs plus a reusable Python script, rules and instructions for one fixed schema.
Send a redacted 20-50 row sample before ordering. We must agree the unique key, dates, currency, refund handling and expected output. One correction to agreed rules is included.
AI-assisted coding and automated tests are used. Portfolio data is synthetic. Structured values only; no OCR, macros, legacy XLS or multi-currency conversion. Do not send passwords or authentication codes.
FAQ
What do you need before I order?
Send a redacted 20-50 row sample. Confirm the unique key, required fields, date formats, currency, refund handling, expected report and deadline. Confirm whether a row means an order or an order line before deduplication.
What happens to invalid or conflicting rows?
They are kept in a separate file with original values, source record numbers and reasons. Conflicting records under the same key are excluded as a group. Missing amounts are not zero-filled, and ambiguous dates are not guessed. Confirm corrections before rerunning.
Do you use AI, and which file types are supported?
Yes. This service uses AI-assisted coding and automated tests. The portfolio uses synthetic data. CSV and one XLSX worksheet of structured values are supported. Formula sheets must be exported as values. OCR, macros, legacy XLS and multi-currency conversion are not included.
