eGigI will clean, deduplicate and format your Excel or CSV data
Sandeep Rathod
Python, JavaScript and n8n Automation Developer
I will clean ONE Excel (.xlsx) or CSV file of up to 2,000 rows and 25 columns within 24 hours of receiving your file plus clear requirements.
Included:
- Remove exact duplicate rows or duplicates using the identifier/column you select
- Trim extra spaces and normalize inconsistent blank cells
- Standardize dates/text casing only when rules are specified
- Preserve leading zeros in IDs and codes wherever possible
- Deliver a cleaned XLSX or CSV plus a brief changes log (rows before/after, actions and unresolved ambiguous values)
- One minor revision for the agreed cleaning rules
How it works: Send the file and tell me which columns define duplicates, any specific formatting rules and preferred output format. I will inspect sample rows, apply Python/pandas-based transformations, validate row/column counts and provide an exported result. I do not guess missing facts, fabricate data, contact any listed people or use customer data for marketing.
Price covers one file, max 2,000 rows, no API integration or manual internet research. Complex merged cells, scanned PDFs, multi-file merges and datasets with sensitive personal data need a separately agreed scope. Avoid sending passwords or unnecessary sensitive information.
Example of my published browser-based data utilities: toolforge-ai-tools.pages.dev/csv-to-json (not a sample of a customer's private file).
Included:
- Remove exact duplicate rows or duplicates using the identifier/column you select
- Trim extra spaces and normalize inconsistent blank cells
- Standardize dates/text casing only when rules are specified
- Preserve leading zeros in IDs and codes wherever possible
- Deliver a cleaned XLSX or CSV plus a brief changes log (rows before/after, actions and unresolved ambiguous values)
- One minor revision for the agreed cleaning rules
How it works: Send the file and tell me which columns define duplicates, any specific formatting rules and preferred output format. I will inspect sample rows, apply Python/pandas-based transformations, validate row/column counts and provide an exported result. I do not guess missing facts, fabricate data, contact any listed people or use customer data for marketing.
Price covers one file, max 2,000 rows, no API integration or manual internet research. Complex merged cells, scanned PDFs, multi-file merges and datasets with sensitive personal data need a separately agreed scope. Avoid sending passwords or unnecessary sensitive information.
Example of my published browser-based data utilities: toolforge-ai-tools.pages.dev/csv-to-json (not a sample of a customer's private file).
What I need from you
Please attach your XLSX or CSV file (up to 2,000 rows, 25 columns).
Which column(s) should define duplicates? (Or choose exact whole-row duplicates.)
What formatting should be standardized (date format, letter case, empty values)?
Do you prefer CSV or XLSX as the final output?
Is there any sensitive personal data that should be removed before sharing?
Which column(s) should define duplicates? (Or choose exact whole-row duplicates.)
What formatting should be standardized (date format, letter case, empty values)?
Do you prefer CSV or XLSX as the final output?
Is there any sensitive personal data that should be removed before sharing?
Questions and answers
Can you deliver in 24 hours?
Yes, once you provide one CSV/XLSX file (up to 2,000 rows) and the agreed cleaning rules. Complex files require a custom quote.
How will you handle duplicate records?
You choose the columns that define duplicates, or I can remove exact whole-row duplicates. I will report the removed row counts.
What files will I receive?
A cleaned XLSX or CSV file in your preferred format, plus a brief change log and one revision for the original requirements.
Reviews
No reviews yet.