Migrating handwritten patient intake forms
A small dental practice has 180 paper intake forms from the last quarter that need to be typed into the new practice management software.
Data Entry & Cleanup
Tier 1 · Business Operations · $25 · 1–3 hrs · 3 day turnaround
Listed price is the project base price. A 3% payment processing fee is added at checkout. The full total is charged upfront when you place your order.
Enter, clean, and organize data in a spreadsheet (up to 200 rows).
You provide raw, messy data—whether it's a CSV export, Google Sheet, or pasted text—and receive a cleaned, formatted spreadsheet with deduplicated rows and standardized columns. This project handles the grunt work of organizing up to 200 rows so your data is ready for analysis, reporting, or import into another system.
Deliverables
- Cleaned spreadsheet file
- Data validation notes
What's included
- Up to 200 rows
- Deduplication and formatting
- Column standardization
Not included
- Data analysis or reporting
- Database migration
- More than 200 rows
What you'll get
Your source data file (CSV, XLS, XLSX, or Google Sheets link) containing up to 200 rows. Include notes on which columns need standardization, any naming conventions you prefer, and whether you suspect duplicate entries.
The student will import your data, identify and remove duplicate rows, standardize column headers and formatting (consistent capitalization, spacing, date formats), fix obvious typos or inconsistent values within columns, and organize the final output in your preferred file format.
A cleaned spreadsheet file in your requested format (CSV, XLS, or XLSX) plus a separate Data Validation Notes document detailing which rows were removed as duplicates, what formatting changes were applied, and any cells flagged as unclear or requiring your review.
Your $25 payment is held until you approve the cleaned spreadsheet and validation notes—you can request revisions if any data doesn't meet your standards before funds are released.
Common use cases
Deduping a leaky email list
A newsletter operator has a 200-row export full of duplicate subscribers, inconsistent capitalization, and broken email formats — needs it cleaned before importing to Mailchimp.
Tagging product data before Shopify migration
An e-commerce owner moving from WooCommerce has 150 products with inconsistent category tags, missing SKUs, and mixed pricing formats.
Cleaning vendor contact list before outreach campaign
You've collected 150 vendor names and phone numbers from multiple sources and need a single, deduplicated sheet with standardized phone formatting before sending bulk outreach. The student will merge duplicate entries, format all phone numbers consistently, and flag any missing information so your outreach team has clean contact data.
Organizing survey responses from multiple forms
You ran two online surveys with slightly different question wording and collected 180 total responses across both. You need one unified spreadsheet with matching column names and consistent response formats (e.g., all dates in MM/DD/YYYY, yes/no values standardized). The student consolidates both sheets and normalizes the data.
Preparing inventory list for warehouse system upload
You have a handwritten inventory count from a recent audit—100+ items with SKUs, quantities, and locations—transcribed into a messy spreadsheet with formatting issues and duplicate SKU entries. The student deduplicates by SKU, standardizes the location naming scheme, and formats quantities as numbers so the data imports cleanly into your warehouse software.
Frequently asked questions
What file formats do you accept as input and output?
We accept CSV, XLS, XLSX, and Google Sheets as input. The student will deliver in whichever format you request—if you don't specify, we'll return the same format you provided. If your source is a Google Sheet, we'll ask for export access or a shareable link.
What counts as a 'duplicate' row, and how will the student decide which to keep?
A duplicate is two or more rows with identical or near-identical values in key columns (e.g., same email address, same order ID, same customer name and phone). The student will flag suspected duplicates in the validation notes and typically keep the first occurrence unless you specify otherwise in your project brief.
Can the student handle special characters, non-English text, or mixed-case data?
Yes. The student will preserve non-English characters and Unicode safely. For mixed-case standardization, tell us your preference in the brief (e.g., 'capitalize first name only' or 'convert all to lowercase') and we'll apply it consistently.
What happens if a row has missing values or data I'm unsure about?
The student will flag any obviously incomplete or questionable cells in the Data Validation Notes document with a description of the issue, so you can review and decide whether to edit, delete, or keep it. This doesn't count as a revision—it's part of the standard deliverable.
Is there a limit on the number of columns, or will the student touch every column?
There's no hard column limit—the 200-row cap is the constraint. The student will clean and standardize all columns you include. If you only want certain columns cleaned, specify that in your brief and the student will focus on those.
Ready to get your project started?
Select a scope and let your Shamrck PM handle the rest. Pay the full total upfront at checkout, then review and approve the completed deliverable. Approval does not trigger a new charge.
Already have an account? Log in