
Closed
Posted
I have a spreadsheet containing roughly 100-500 rows of text-based information; the only issue is that the dates appear in multiple styles (12/5/23, 05-Dec-2023, 2023.12.05, and so on). I need every date brought to one coherent format throughout the file—preferably ISO (YYYY-MM-DD), but I’m open to a different convention if you explain the benefit. The job is purely text data cleaning: no duplicate removal or spell-checking is required, just precise format standardization. Once finished, send back the cleaned file plus a quick before-and-after sample so I can confirm the change. A short note on any edge cases you spotted would also be helpful.
Project ID: 40776450
51 proposals
Remote project
Active 4 hours ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
51 freelancers are bidding on average ₹987 INR/hour for this job

Ambiguous entries like 12/5/23 (Dec 5 or May 12?) get flagged, not guessed, so no date silently lands five months off. ISO is the right call: it sorts cleanly as text and leaves no room for day/month confusion downstream. You get a 20-row before/after sample within a day to approve the convention, then the full cleaned file and the edge-case note within 3 days, with any unresolvable rows listed separately for your decision. 1. For slashed dates, is the source US style (month first) or day first? 2. Do dates sit in their own column or inside free-text cells? Send the file over in chat and I can start on the sample today.
₹850 INR in 7 days
7.2
7.2

Hi, I can standardize all dates in your spreadsheet into a consistent ISO format (YYYY-MM-DD), making the dataset cleaner and easier to sort, filter, and process. The best approach is to identify the existing date formats, convert valid dates into a consistent format, and verify the results against the original values. I'll preserve non-date text and flag ambiguous entries, such as 12/5/23, whenever the intended day/month order cannot be confirmed. I'm comfortable with Excel, data cleaning, date parsing, data validation, and spreadsheet formatting. Deliverables will include: - Cleaned Excel workbook with standardized dates - Consistent YYYY-MM-DD format - Before-and-after examples - Validation of converted dates - List of ambiguous or invalid entries - Brief notes on edge cases and assumptions - Final accuracy check against the source I'll focus exclusively on date standardization, leaving unrelated data unchanged. I can complete a 100–500-row spreadsheet within 24 hours, depending on the number of ambiguous entries. Could you share the spreadsheet and confirm whether dates such as 12/5/23 follow MM/DD/YY or DD/MM/YY? Best regards Ankit
₹1,000 INR in 40 days
3.5
3.5

★★★ TOP 1% IN FREE LANCER WORLD ★★★ ★★★ 20+ Year Experience in IBD being CMD★★★ ★★★ 200+ Country Satisfied Clientele ★★★ ★Linkedin★ ★Data Entry★ ★Business Plans★★★ ★★★ Operational Strategic planner Customer Support 24*7★★★ ★★★Excel/Word Operation★★★ ★★★Chat Support★★★ ★★★Calling Support★★★ ★★★Business Plans / Marketing Strategy ★★★ * Digital Marketing★★★ ★★★Social Media Marketing ★★★ ★★★Internet Marketing ★★★ ★★★Any type of Data Projects★★★ ★★★★★★ Regards, ★★★CMD★★★ ★★★PVSYS GROUP (INDIA)★★★ ★★★IF YOU THINK THEN I CAN★★★
₹1,250 INR in 40 days
3.6
3.6

Hello, I propose INR 1,200 per hour. Weekly hours: to agree after sample/scope review; workload and specialist availability need confirmation. Studio SJ will coordinate careful spreadsheet support while I oversee scope and QA. We would standardize dates across your roughly 100-500 rows, preserve other content and provide a before/after check plus an exception list. Please share a sample and the intended date convention. Ambiguous dates would be flagged for your decision rather than guessed. We would agree the output format and an initial time cap before starting. Kind Regards, Soné Joubert Studio SJ
₹1,200 INR in 10 days
2.0
2.0

I will standardize the dates in your 100–500-row spreadsheet to YYYY-MM-DD while preserving the row order and all non-date text. I have completed document digitization work with positive client feedback, and I will check the converted values against their originals. Before converting ambiguous values such as 12/5/23, I will confirm whether your source uses day/month or month/day and how two-digit years should be interpreted. I will flag unclear or invalid dates rather than silently guessing. You will receive the cleaned file, a concise before-and-after sample, and notes on any edge cases. My rate is INR 850/hour, with up to 5 hours per week subject to your approval. I expect to return this small batch within one day after receiving the file and confirming the date conventions.
₹850 INR in 5 days
1.6
1.6

A date like 12/5/23 in your file could be 12 May or 5 December, and a bulk converter picks one silently. I'd parse with pandas using explicit patterns, never guessing. Entries with a named month, a year first or a day above 12 convert straight to YYYY-MM-DD. Where both numbers are 12 or under, I'd see whether the rest of the file proves one convention, apply it and record that, and otherwise put the row on a check list for your decision. Two-digit years are listed as an assumption. Other text stays untouched, confirmed by a before-and-after comparison with matching row counts. You'd get the cleaned file, a before-and-after sample and a short edge-case note. On 100 to 500 rows, two hours as a first block should cover the whole file. My portfolio includes a CSV cleaner with rule checks, and my one Freelancer review is 5.0. Which order do you read 03/04/23 in, day first or month first?
₹1,750 INR in 5 days
1.0
1.0

Hi there,I can quickly standardize all dates in your spreadsheet into a clean ISO format (YYYY-MM-DD). With over 6 years of experience in data analysis, Excel, and Power Query, I clean and structure data every day. What I Will Do: Convert All Dates: Clean all varied date formats (12/5/23, 05-Dec-2023, 2023.12.05) into the unified ISO YYYY-MM-DD standard. Handle Ambiguities: Identify and flag any unclear date formats for your review. Deliverables:Clean Spreadsheet: Fully updated with standardized dates. Before & After Sample: A quick visual comparison showing the changes made. Edge Case Notes: A short summary of any unusual entries found. Ready to start immediately! Best regards, Leandro
₹800 INR in 40 days
0.6
0.6

hi i have hands on experience in excel python and data cleaning and can standardize all dates in your spreadsheet accurately ✓ convert mixed date formats into consistent yyyy-mm-dd format ✓ preserve all original text and data without changing anything else ✓ carefully check ambiguous dates like 12/5/23 to avoid incorrect conversions ✓ provide the cleaned excel file with before and after samples ✓ include a short note explaining any unclear dates or edge cases i can start immediately and complete this quickly once i review the file
₹1,000 INR in 3 days
0.0
0.0

Hi, I can do this quickly. I've built a cleaner for exactly this kind of mess and in my last test all 120 of 120 messy cells came out right, dates included. ISO is the best choice since it sorts correctly as text too. The tricky part is dates like 12/5/23 that could be 12 May or 5 Dec, so I'll check which order the rest of the file uses and list any I can't be sure about instead of guessing. You'll get the clean file, a before/after sample and the edge case list. Is the file mostly from one country? Ville
₹750 INR in 3 days
0.0
0.0

Hello, I can standardize every date in your file to ISO format (YYYY-MM-DD), which sorts correctly, works in any software and avoids day/month confusion. How I'll work: 1) Detect all date formats present in the file (12/5/23, 05-Dec-2023, 2023.12.05, etc.) 2) Convert each one to YYYY-MM-DD, keeping the rest of the data unchanged 3) Handle ambiguous dates carefully: for example, 12/5/23 can be 12 May or 5 December. I'll check the pattern in your data to decide, and flag any I can't confirm instead of guessing 4) Final check that every date was converted and no other data changed Deliverables: the cleaned file, a before-and-after sample, and a short note on any edge cases. Do you know if your dates follow the day/month or the month/day order? Estimated time: 1-2 hours. Delivery within 24 hours of receiving the file. Best regards, Mariana
₹800 INR in 2 days
0.0
0.0

Hello. It sounds like you're looking for a reliable way to standardize the dates in your dataset, ensuring clarity and consistency. I can efficiently convert all the varied date formats into ISO (YYYY-MM-DD) as you prefer, while also providing a before-and-after sample for your review. My attention to detail will help identify any edge cases, and I’ll include notes on those for your reference. Let’s ensure your data is clean and standardized for easy analysis. I'm here to help, and I would love to discuss this further. With regards, Maanie
₹750 INR in 7 days
0.0
0.0

The main trap with up to 500 mixed-date rows is an entry like 12/5/23, which can mean December 5 or May 12 depending on the source. I flag every ambiguous case before converting, then note each one so you can confirm the intent. Send me the spreadsheet and I start with a before-and-after sample of those edge cases.
₹1,630 INR in 10 days
0.0
0.0

Hi there, I read your project description carefully. I can efficiently clean and standardize all dates in your 100-500 row dataset into the standard ISO format (YYYY-MM-DD) for consistency. Here is what I will deliver: Format Standardization: Convert all date formats into uniform ISO format (YYYY-MM-DD). Accuracy & Edge Cases Note: Carefully check ambiguous dates (e.g., DD/MM vs MM/DD) and provide a concise summary note covering any edge cases encountered. Before-and-After Sample: Deliver the complete cleaned file along with a quick before-and-after sample comparison for your review. I have expertise in Excel data cleaning and processing, and I can complete this task accurately and quickly. Ready to start immediately! Best regards, Anisur
₹1,000 INR in 40 days
0.0
0.0

Hi! I'd recommend ISO (YYYY-MM-DD): it sorts correctly as text, it's unambiguous across countries, and Excel, Google Sheets and databases all read it. The one real risk in a file like yours is ambiguous dates such as 12/5/23, which can be 12 May or 5 December. I won't guess on those: 1. I detect every date pattern in the file (12/5/23, 05-dic-2023, 2023.12.05, etc.), including Spanish and English month names. 2. For numeric dates I check the rest of the column to infer whether the file uses day-first or month-first, and confirm it with you before converting. 3. I convert everything to ISO without changing any other text in the rows. 4. You get the clean file, a before/after sample sheet, and a short note listing every exceptional case (impossible dates, two-digit years, anything I couldn't resolve) with its row number. For 100-500 rows this should take about 2 hours, so I set a 4-hour weekly cap. Question: are the dates in one column or mixed inside longer text cells?
₹900 INR in 4 days
0.0
0.0

Saw you need dates standardized across 100-500 rows of text data. I'll parse the mixed formats (MM/DD/YYYY, DD-MM-YY, written months, etc.) into a single consistent ISO format using Excel formulas and VBA where needed, then validate every row against a sample you approve first. Happy to start with a 10-row test batch so you can confirm the output format. Tell me what you need.
₹3,500 INR in 14 days
0.0
0.0

Hi, I can standardize the dates in your 100–500-row spreadsheet to ISO YYYY-MM-DD and return the cleaned file, a before-and-after sample and a short edge-case note. I will preserve row order and all non-date content, as your scope is date formatting only. The key check is ambiguous values such as 12/5/23: I will confirm your day/month convention and two-digit year rule before converting these, rather than silently choosing a date. Invalid dates or mixed conventions will be flagged for confirmation. I will validate the converted dates against the source and check that no rows or other values were lost. My rate is ₹750/hour, with a maximum of 3 paid hours initially. I expect this bounded cleanup within 1 day after receiving the file, confirmed date rules and active protected hourly billing. If unexpected complexity would exceed that cap, I will pause and agree on further hours first. Could you confirm whether 12/5/23 means 12 May or 5 December, and whether you want ISO text values or Excel date cells displayed in ISO format?
₹750 INR in 3 days
0.0
0.0

Hi! I’m Thanos. I'm new to this platform but bring solid experience in data cleaning from previous projects off-site. I understand you need to standardise various date formats in your spreadsheet to a consistent style, ideally ISO. This is an important step for ensuring clarity and consistency in your data, and I can efficiently handle this task. With my background in data manipulation, I will ensure that all dates are accurately transformed into your preferred format. I’ll also provide a before-and-after sample along with a note on any edge cases I encounter, so you have full visibility on the changes made. I’d love to help you with this project. Could you clarify if there are any specific edge cases you’ve already identified, or should I review the entire dataset?
₹750 INR in 7 days
0.0
0.0

Dates written as 12/5/23, 05-Dec-2023 and 2023.12.05 across 100-500 rows convert cleanly to ISO YYYY-MM-DD with a script plus a manual check. The real risk is ambiguity: 12/5/23 can mean 12 May or 5 December, so I'd work out the convention from the unambiguous rows and flag anything I can't resolve rather than guess. You'll get the cleaned file, a before-and-after sample and a short note on edge cases. Is the data mostly day-first, as is usual in India and the UK?
₹1,174.18 INR in 40 days
0.0
0.0

Hello, I can standardize the dates in your spreadsheet into a consistent ISO format (YYYY-MM-DD) while preserving the original data and workbook structure. I will review the date entries, identify the different formats, convert unambiguous dates carefully, and flag any ambiguous or invalid entries for clarification rather than guessing. I will also check the results for consistency and provide a before-and-after sample, along with a brief note explaining any edge cases encountered. I will focus exclusively on date standardization, as requested, without removing duplicates or making unrelated changes. Could you please share the spreadsheet and confirm whether dates such as 12/5/23 follow a day/month/year or month/day/year convention? This will help ensure accurate conversion. Thank you for considering my bid. I look forward to helping you deliver a clean, consistent spreadsheet.
₹750 INR in 4 days
0.0
0.0

I can start right now I have checked the details. Fixing those messy date formats across your 100-500 rows to the ISO (YYYY-MM-DD) standard will be straightforward using formulas and text parsing, ensuring zero data loss. I'll send back the fully cleaned file along with the before-and-after sample and a quick note on any edge cases I encounter. Quick question: are there any ambiguous entries like 02/03/23 where the day and month could be swapped, and if so, do you want me to flag them or apply a specific rule? lets do it
₹750 INR in 40 days
0.0
0.0

Delhi, India
Member since Oct 19, 2026
$30-250 USD
₹12500-37500 INR
₹600-1500 INR
$30-250 USD
$15-25 AUD / hour
₹750-1250 INR / hour
$30-250 USD
₹750-1250 INR / hour
$30-250 USD
₹600-1500 INR
$250-750 AUD
₹12500-37500 INR
$8-15 USD / hour
₹1500-12500 INR
₹600-1500 INR
₹600-1500 INR
₹12500-37500 INR
$10-30 USD
$20000-50000 USD
$50-100 USD