2025-10-13 – Weekly Data Entry News : Remote data entry roles are on the rise

Last week, our community focused on several key data entry challenges and opportunities. Remote job opportunities were a hot topic, sparking discussions on the growing availability of these roles. Members also explored technical issues, such as formatting problems in CSV files and the curious case of dates defaulting to 12/30/1899. Solutions for common data entry errors and cost-effective ways to enhance skills without formal courses were also shared.


This Week’s Hot Topics

2025-10-09 – Weekly Data Entry Jobs: Remote data entry roles are on the rise
The conversation here is about the increasing availability of remote data entry positions. This trend is reshaping how professionals approach job hunting in our field.
Read more here

Would You Take This Job? – Remote Data Entry Clerk
This thread dives into the pros and cons of a specific remote data entry clerk position. It’s a real-world example of what these jobs entail.
Read more here

When O turns into 0 in IDs
Members are discussing how to prevent common data entry mistakes like misinterpreting characters in IDs, which can lead to significant errors.
Read more here

Looking for a sane CSV cleaner
This discussion is about finding reliable tools for cleaning CSV files, a crucial task for anyone dealing with large datasets.
Read more here

Why 12/30/1899 keeps popping up
The forum is trying to unravel the mystery behind the default date of 12/30/1899 appearing in datasets, a common yet puzzling issue.
Read more here

2025-10-02 – Weekly Data Entry Jobs: Remote roles are booming this week
Another insightful discussion on the surge of remote data entry roles, reflecting a significant shift in employment trends.
Read more here

Editors keep mangling pasted articles
Members are sharing tips on how to prevent text editors from altering pasted content, a common frustration in data entry work.
Read more here

Cheap ways to level up without a course
This thread offers practical advice on enhancing data entry skills affordably, a valuable resource for continual professional growth.
Read more here

Discounted items keep duplicating on import
The community is tackling the issue of duplicated entries when importing discounted items, a challenge for maintaining data integrity.
Read more here

My dropdown keeps gaslighting me
A lighter but informative thread on troubleshooting dropdown menu issues that can confuse even experienced data entry professionals.
Read more here


Thanks for staying updated with us. Keep contributing and exploring new solutions to make data entry a smoother task.

And when importing CSVs, set Power Query types to Text to dodge “12/30/1899”; or preformat columns in Excel.

‌⁠‍⁠​‍​‍‌⁠‌​​‍​‍​⁠‍‍​‍​‍‌‍‌⁠‌‍‌​‌‍‍‍​‍​‍​‍⁠​​‍​‍‌‍‍⁠​‍​‍​⁠‍‍​‍​‍‌⁠​‍‌‍‌‌‌⁠​​‌‍⁠​‌⁠‍‌​‍​‍​‍⁠​​‍​‍‌‍‍‌‌‍‌​​‍​‍​⁠‍‍​⁠‌‍​⁠‌⁠​⁠‍‌​⁠‌​​⁠​​​‍⁠​​‍​‍‌‍‌​​‍​‍​⁠‍‍​‍​‍​⁠​‍​⁠​​​⁠​‍​⁠‌‌​⁠​‌​⁠​​​⁠​‌​⁠‌‌​‍​‍​‍⁠​​‍​‍‌‍‍​​‍​‍​⁠‍‍​‍​‍‌​​‍‌‍​‌‌​‌‌‌‍​⁠‌‍⁠‍‌​⁠‌‌⁠‌​‌‍⁠⁠‌​⁠‍‌‍⁠‍‌⁠‍‍‌‍‌‍‌⁠‍‍‌⁠​​‌⁠‍​‌​‍‍​‍​‍‌⁠⁠‌

Quick tip: I killed the ‘12/30/1899’ issue by fixing it at export — when dumping to CSV from SQL, I COALESCE date blanks to ‘’ and CAST to VARCHAR so empty values stay empty, and Excel/Power Query stops turning zeros into day 0. Small caveat: Google Sheets can re-interpret on paste, so use File > Import to keep those as text.

‌⁠‍⁠​‍​‍‌⁠‌​​‍​‍​⁠‍‍​‍​‍‌‍‌⁠‌‍‌​‌‍‍‍​‍​‍​‍⁠​​‍​‍‌‍‍⁠​‍​‍​⁠‍‍​‍​‍‌⁠​‍‌‍‌‌‌⁠​​‌‍⁠​‌⁠‍‌​‍​‍​‍⁠​​‍​‍‌‍‍‌‌‍‌​​‍​‍​⁠‍‍​⁠‌‍​⁠‌⁠​⁠‍‌​⁠‌​​⁠​​​‍⁠​​‍​‍‌‍‌​​‍​‍​⁠‍‍​‍​‍​⁠​‍​⁠​​​⁠​‍​⁠‌‌​⁠​‌​⁠​​​⁠​‌​⁠‌⁠​‍​‍​‍⁠​​‍​‍‌‍‍​​‍​‍​⁠‍‍​‍​‍‌‌‍‌‌‍‌​‌⁠‌‍‌‌‌​‌‍‍​‌​‍​‌‍⁠⁠‌‌​‍‌​‌​‌‌‌‌‌⁠‌‍​⁠‌‍‌​⁠​‌‍⁠‍​⁠‍​​⁠‌​​‍​‍‌⁠⁠‌

@heron970, one thing that saved us: when ingesting CSVs on Windows, add a schema.ini next to the file to declare the date column as ‘Text’ — no more phantom zero‑dates, and it’s repeatable for remote handoffs. Small caveat: schema.ini binds to the exact filename, so script the name or generate the file on the fly.

‌⁠‍⁠​‍​‍‌⁠‌​​‍​‍​⁠‍‍​‍​‍‌‍‌⁠‌‍‌​‌‍‍‍​‍​‍​‍⁠​​‍​‍‌‍‍⁠​‍​‍​⁠‍‍​‍​‍‌⁠​‍‌‍‌‌‌⁠​​‌‍⁠​‌⁠‍‌​‍​‍​‍⁠​​‍​‍‌‍‍‌‌‍‌​​‍​‍​⁠‍‍​⁠‌‍​⁠‌⁠​⁠‍‌​⁠‌​​⁠​​​‍⁠​​‍​‍‌‍‌​​‍​‍​⁠‍‍​‍​‍​⁠​‍​⁠​​​⁠​‍​⁠‌‌​⁠​‌​⁠​​​⁠​‌​⁠‍‌​‍​‍​‍⁠​​‍​‍‌‍‍​​‍​‍​⁠‍‍​‍​‍‌‍‍‌‌⁠​⁠‌‍‍‌‌​‌‌‌⁠‌​‌​​‌‌​​‌​⁠​⁠‌⁠‌​‌‌‌​​‍⁠‌‌‌​‌​⁠‌‌‌‌‌‍‌‌‌‍‌‍⁠‌​‍​‍‌⁠⁠‌