
Closed
Posted
I have three distinct text-file datasets—customer information, financial records, and survey responses—that all need to be brought into a clean, analysis-ready format. The job is twofold: first, accurately key or import every record into a structured spreadsheet or database layout; second, perform a full hygiene pass to remove duplicates, correct any formatting inconsistencies, and fill in the missing fields I will flag for you. You will receive a folder of raw .txt files plus a short field dictionary that shows the expected column names, data types, and any reference lists you can use for validation. Once the data is in shape, return it as Excel workbooks (or CSV if you prefer) that match the field order in the template I’ll provide so I can import straight into our CRM and accounting software. Deliverables • Clean, de-duplicated datasets for all three categories • A brief change log noting major corrections or assumptions made • Verification that row counts in the cleaned files reconcile with the original sources (minus legitimate duplicates) If you work faster by scripting in Python, Power Query, or similar tools, great—just keep the final output user-friendly. Accuracy is more important than speed, but I would like the first milestone (customer information file) ready within three days so we can confirm the approach before you continue with the rest.
Project ID: 40749956
28 proposals
Remote project
Active
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
28 freelancers are bidding on average ₹943 INR/hour for this job

★★★ 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★★★
₹750 INR in 40 days
3.6
3.6

Hi, I can clean and standardize all three datasets—customer information, financial records, and survey responses—into analysis-ready Excel/CSV files that match your required field order and are ready for CRM/accounting import. The best approach is to first map the raw .txt files against your field dictionary, then validate data types, normalize formatting, remove legitimate duplicates, and complete the missing fields you identify using the supplied reference lists. I’ll keep each transformation traceable so the cleaned outputs reconcile clearly with the source record counts. I’m comfortable with: - TXT-to-Excel/CSV data import - Data type and field validation - Duplicate detection and removal - Formatting standardization - Missing-field completion - Reference-list validation - Row-count reconciliation - Change-log documentation - CRM/accounting-ready output Deliverables will include three clean datasets, a concise change log, and a reconciliation summary showing original rows, valid removals, and final counts. I can complete the customer information dataset within 3 days so you can verify the structure and cleaning rules before I proceed with the financial and survey files. Best regards Ankit
₹1,000 INR in 40 days
3.5
3.5

Hi, I can accurately convert and clean all three TXT datasets into CRM/accounting-ready Excel or CSV files. I’ll handle structured data entry/import, de-duplication, formatting corrections, validation against your field dictionary/reference lists, and flagged missing fields. I can also use Python, Power Query, or Excel automation where appropriate while keeping the final files easy to review and use. You’ll receive: • Clean datasets in the exact template field order • A clear change log of corrections and assumptions • Reconciled row counts against the original files, accounting for legitimate duplicates I can prioritize the customer dataset and deliver the first milestone within three days. Accuracy and data integrity will be my top priority. I’m ready to start immediately. Best regards, Sreekanth
₹750 INR in 4 days
1.8
1.8

I have experience processing multi-format data using Python scripts with validation and deduplication. In a project involving data aggregation from external platforms, I implemented pipelines for cleaning and transforming raw data into a structured format with integrity control. To speed up the work, I am ready to use tools like Pandas, but I will prepare the final exports in a convenient Excel format with a log of changes. How do you check the quality of the data after cleaning?
₹1,250 INR in 14 days
1.3
1.3

I can start with your customer-information milestone: import the .txt records, apply your field dictionary, and return a clean Excel workbook or CSV in the exact template order, plus a change log and row-count reconciliation. I propose INR 750/hour for an initial batch capped at 3 actual hours (INR 2,250 maximum, not a minimum charge). This covers one customer dataset of up to 5,000 rows and 20 columns, using one agreed schema, plus one correction round within the cap. I would send a 20-row sample within 24 hours and the agreed first milestone within 3 days of receiving usable files and confirmed rules. Financial and survey datasets can follow after sample approval and a separate scope/time estimate. I use AI-assisted Python scripting and validation. I will preserve source files, IDs and leading zeros; standardise formats only to your rules; and remove duplicates only using the key and retention rule you approve. Missing values will be filled only from your supplied reference lists or explicit instructions. Conflicts and unresolved values will be flagged, not invented. Before delivery I will reconcile input rows to output, removed duplicates and any exception rows, check column order/types, and reopen the exported files. Please share the template, field dictionary, a small redacted .txt sample, row counts, encoding/delimiter, duplicate key/retention rule, and which missing fields can be filled from which references. I will confirm any scope change before extra work.
₹750 INR in 3 days
0.0
0.0

Your key risk is not importing the .txt files; it is making every correction auditable while keeping the CRM/accounting outputs reconciled to the source. I’d structure the workflow around your field dictionary, validate data types and reference lists, normalize formats, deduplicate by agreed keys, and log every material correction or assumption. My background includes Excel/CSV import-export, batch data processing, reporting, database consistency investigation, and Python automation. I can use a repeatable script-driven process for validation and reconciliation, then return user-friendly Excel/CSV files in the exact template order you provide. I’d also verify source vs. cleaned row counts with duplicates reported separately, so the final numbers are explainable rather than just “cleaned.” One point to confirm: where a record has no stable unique ID, should duplicates be identified by a defined composite key, or do you want fuzzy matching rules as well? I can use the customer dataset as the validation baseline, then apply the approved rules consistently to the financial and survey datasets.
₹1,250 INR in 20 days
0.0
0.0

I can deliver all three datasets in your template order, with a change log and a row-count reconciliation showing which records were retained, corrected or removed as agreed duplicates. I will keep an untouched source copy, use the field dictionary for types and validation, and fill missing fields only from your supplied reference data; unresolved values will be flagged, never invented. My rate is INR 1,250 per active work hour. I propose a 16-hour total ceiling (INR 20,000) for the complete three-dataset batch, up to 30,000 rows, 30 fields and 6 consistent text layouts combined. This includes parsing, cleanup, QA, communication and one correction round. We will confirm that the entire folder fits these limits before acceptance. The customer dataset is the first paid milestone within 3 days; all three outputs and the reconciliation within 7 days after complete inputs and agreed payment setup. In an internal fictional importer test, I checked structured CSV/JSON/XLSX handling, invalid dates and numbers, duplicate controls and leading-zero IDs. That is local method validation, not previous client work. I would use repeatable Python checks and return ordinary CSV/XLSX files you can inspect. Please provide the approximate record counts and duplicate-matching rules; billing/tracking and funding must be agreed before starting, and unattended processing will not be billed as human time.
₹1,250 INR in 16 days
0.0
0.0

Hi, this is the kind of job I script and then check by hand. For each dataset (customers, financial records, survey responses) you get: 1. An Excel workbook in your template's exact field order, plus a CSV copy for your CRM and accounting import. 2. Duplicates removed (exact and near matches such as different spacing or case), with the removed rows kept on their own tab so nothing is lost. 3. A change log of every correction and assumption, and the flagged missing fields filled from your reference lists. 4. A row count check: source rows = clean rows + duplicates, shown with live formulas. My portfolio item "Messy Text Files to Clean Excel" shows exactly this on a made-up customer file: change log, duplicates tab, issues tab and the row check. The customer file comes back first, inside your 3 days. Once I see the files I can also quote each dataset as a fixed milestone instead of hourly. Roughly how many records are in each file?
₹750 INR in 10 days
0.0
0.0

As a seasoned data professional for over 8 years, my focus has been on transforming raw data into meaningful, polished information aligned with distinct business objectives. With your task at hand, my diverse proficiency in data entry and management combined with my advanced Excel skills make me a natural fit for your project. I understand the importance of maintaining data accuracy and eliminating inconsistencies, especially when dealing with multiple datasets. My attention to detail ensures accurate keying and effective importation of records into structured spreadsheets or databases, while my astute approach to data cleansing eliminates duplicates, corrects formatting errors and fills in any missing fields you flag for me. In addition, I'm familiar with coding languages like Python and powerful ETL tools such as Power Query that can streamline the process without compromising quality. My work is always aimed at delivering user-friendly results promptly without sacrificing accuracy. I will ensure the first milestone - clean customer information file - ready within three days and looking forward to continuing the same vigor through ??? ???? of the project!
₹1,000 INR in 40 days
0.0
0.0

My self-built, unpaid, AI-assisted CSV sample reconciles all 300 synthetic source records, with separate duplicate and exception logs. See "CSV Cleanup & Traceable Validation": https://www.freelancer.com/u/numanli I can turn your customer-information TXT data into an Excel workbook and CSV in your template order, with a duplicate log and source-to-output row-count reconciliation. I propose a first pilot at INR 750 per active hour, capped at 2 TOTAL hours and INR 1,500 maximum. This is a one-off pilot, not a recurring weekly commitment or a quote for all three datasets. Subject to checking a representative sample first, the pilot covers one delimited customer TXT file of up to 500 rows and 20 columns. I will preserve an untouched source copy, apply your field dictionary, remove only agreed duplicates, and fill flagged blanks only from your supplied reference data. Ambiguous values will be listed for your review rather than guessed. Source review, cleaning, checks and one minor correction are all included within the two-hour cap. My workflow uses AI-assisted tools with checks against the source and final output. Please share a small anonymized sample, the template/field dictionary, total file sizes and row counts, and your duplicate rule. I can deliver the agreed pilot within 3 days after the files, scope and funded Freelancer payment arrangement are ready. Any remaining data needs a separate agreed scope and cost before further work.
₹750 INR in 2 days
0.0
0.0

I can take the customer-information file as the first paid milestone and prove the workflow before scaling to the financial and survey datasets. I will import the raw text into the exact field order, normalize formats, remove true duplicates without losing valid records, validate against your dictionary/reference lists, reconcile source-to-clean row counts, and return a concise change log for exceptions. I have a verified internal Excel/CSV cleanup and validation proof that matches this workflow closely. I can start immediately and deliver the first customer-data milestone within your three-day target.
₹900 INR in 10 days
0.0
0.0

Customer file first: a small Python script imports the .txt records using your field dictionary, then validates each column against your types and reference lists. For each dataset: - an .xlsx in your template's field order, ready to import - duplicates removed, kept on a separate sheet - a change log and a row-count reconciliation against the source At work I built Excel/VBA and Python automation. This would be my first contract on Freelancer. Rate: INR 750/hour, up to 6 hours for the customer file. This price is for my first review on this platform. If it looks like more than 6 hours, I'll tell you before going over. I'll estimate the other two files once you've confirmed the approach. Turnaround: customer file within 3 days after the contract starts and the files arrive. Question: for flagged missing fields, fill from a reference list, or leave blank and mark? suminawa
₹750 INR in 7 days
0.0
0.0

Hello, I’m a Data & Operations professional with 3+ years of experience in data entry, cleaning, validation, reconciliation, and Excel reporting. I can accurately transform your three TXT datasets into structured, CRM-ready files while maintaining the required field order and data types. My approach: * Import/key all records without unnecessary manual re-entry. * Map fields against your dictionary and template. * Standardize dates, text, numbers, IDs, and other formatting. * Identify and remove legitimate duplicates while preserving valid records. * Flag missing or suspicious values rather than making unsupported assumptions. * Validate records against your reference lists. * Reconcile original and cleaned row counts, documenting duplicates removed. * Provide a concise change log covering corrections, assumptions, and validation results. I can use Python/Pandas, Power Query, or Excel depending on what best suits the datasets, while ensuring the final files remain user-friendly and ready for CRM/accounting import. I can have the first customer-information milestone ready within 3 days for your review before proceeding with the financial and survey datasets. Accuracy and traceability will be my priority throughout the process. Thank you, Gadvin Gitamo
₹900 INR in 40 days
0.0
0.0

I can clean the three text datasets into import-ready Excel or CSV files while keeping an auditable trail of every decision. For the first paid milestone, I will process the customer-information file within three days: map the supplied field dictionary, normalize data types and formatting, remove only defensible duplicates, reconcile original versus final row counts, and return a short change log with uncertain cases separated instead of guessed. After you approve that sample, I can apply the same validated rules to the financial and survey files. The final files will preserve your required column order for CRM/accounting import and remain user-friendly even if scripting is used internally. Before award, please confirm the approximate row count of the first file and whether flagged missing fields should stay blank, use a supplied reference list, or be placed in a separate review sheet. I will start only after the project is awarded and the first milestone is funded.
₹1,000 INR in 10 days
0.0
0.0

I can return all three datasets in your Excel/CSV template, with a change log and source-to-output row-count reconciliation. I would import the .txt files using your field dictionary, then standardise types and validate duplicates and flagged missing fields against your supplied reference lists. Unresolved values would be flagged rather than guessed. My background is finance leadership, reporting, audit and ERP data migration. I use AI-assisted development and drafting with review/testing; customer and financial records would stay out of external AI services without your permission. My introductory rate is INR 900/hour, with a 10-hour weekly ceiling and actual work time billed. Before starting, we would agree the customer-file milestone, data handling and funded payment setup. Its three-day target needs confirmation after inspecting the sample and record count. How many records and files are in each of the three datasets?
₹900 INR in 10 days
0.0
0.0

I can help turn the three text-file datasets into clean Excel or CSV files, using Python for repeatable importing, validation and reconciliation. I suggest starting with a paid pilot on a small, representative subset of the customer data, capped at 2 hours at INR 1,000/hour. We would agree the exact subset, fields, duplicate-matching rules and acceptance checks before work starts. The provisional weekly cap is 5 hours; further work would need an agreed scope and hour budget. For the pilot I would deliver: - A cleaned file in your required column order and data types - A change log covering corrections, duplicate removals and unresolved issues - A row-count reconciliation from source records to retained records and documented duplicates Please share an anonymized sample, file and record counts for each dataset, the field dictionary/template, and the rules or reference sources for filling missing values. I would flag unresolved values rather than guess them. Please also confirm the acceptance criteria and Freelancer payment protection, with an agreed funded pilot milestone or suitable protected hourly arrangement before any paid processing begins. After reviewing the sample and volume, I can confirm the customer-file scope and whether the requested three-day turnaround is realistic. The complete customer dataset and remaining two datasets would follow only after the pilot is approved and their scope, timing and payment terms are agreed.
₹1,000 INR in 5 days
0.0
0.0

Your three text-file datasets need a consistent, clean structure for CRM and accounting imports. I can help with clean Excel or CSV outputs for all three datasets, with duplicates removed and a short change log. I would use Python to import the field dictionary, preserve IDs and reconcile row counts. Missing values would be filled from your approved references, with unresolved items flagged. We can start with the customer dataset and aim for your three-day first milestone. Estimated delivery: 7 days. Price and delivery are preliminary estimates; let's confirm the scope and terms before I accept the project. Please share a sample so we can confirm the details together. Initial weekly limit: 10 hours; only actual work is billed.
₹750 INR in 10 days
0.0
0.0

Hi, This is exactly the kind of job I script in Python (pandas). Here's how I'd handle it: 1. Import: parse each raw .txt file into columns following your field dictionary (names, data types, field order). Records that don't parse cleanly are logged rather than silently dropped. 2. Hygiene pass: trim and normalise text, unify date/number/phone formats, and validate values against your reference lists. Duplicates are found with exact matching plus fuzzy matching on names/emails, and every merge is recorded. 3. Missing fields: I fill the ones you flag from your reference data. Anything I can't fill reliably is marked for you rather than guessed. 4. Reconciliation: a table per dataset showing source rows, duplicates removed and final rows, so the counts add up. 5. Output: Excel files in your template's column order, ready for CRM/accounting import, plus a short change log. Milestone 1 (customer information file) can be ready within 3 days, as you asked, so you can confirm the approach first. Financial records and survey responses follow with the same script, which keeps all three datasets consistent. I can also hand over the script if you'll need to clean similar exports again. About me: Python developer focused on data extraction and processing (scraping, PDF/Excel/CSV). I recently delivered a paid data project to a client in Poland. Roughly how many records are there in each file? Best regards, Oleh
₹1,000 INR in 10 days
0.0
0.0

Hi! I can help you clean, standardize, and format your raw text datasets into production-ready Excel workbooks or CSV files for your CRM and accounting software. Approach & Workflow: Processing & Ingestion: I will write automated Python/Pandas scripts to accurately parse and key all raw .txt files into structured schemas matching your provided template and field dictionary. Hygiene & Validation Pass: I will apply strict validation rules to remove true duplicates, standardize string/numerical formats, and handle flagged missing values as instructed. Quality Control & Reconciliation: Every dataset will undergo a full row count reconciliation against original source files to guarantee complete data integrity before hand-off. Key Deliverables: Clean Datasets: Fully validated Excel/CSV files structured strictly to your field order and software schema requirements. Reconciliation & Audit Trail: Verified row count matching (original vs. cleaned) ensuring zero unaccounted data loss. Change Log: A brief document detailing all major corrections, duplicate removals, and key assumptions made during processing. Timeline: I will deliver the complete Customer Information Dataset within 3 days (Milestone 1) so you can review and approve the approach before I complete the Financial Records and Survey Responses datasets. Ready to start as soon as you share the raw files and template!
₹1,000 INR in 40 days
0.0
0.0

Hi, I can clean your three datasets into the supplied Excel/CSV structure using your field dictionary and reference lists. My portfolio includes a cleanup tool with validation and an audit log. I’ll reconcile row counts and flag missing values without reliable sources. I propose ₹750/hour with a six-hour weekly limit, targeting the customer file within three days after scope confirmation. How many records are in each file, and which fields identify duplicates?
₹750 INR in 6 days
0.0
0.0

Loni, India
Member since Oct 4, 2026
$15-25 USD / hour
₹750-1250 INR / hour
₹1500-12500 INR
$15-25 USD / hour
₹750-1250 INR / hour
£10-20 GBP
$250-750 USD
$8-15 USD / hour
₹750-1250 INR / hour
$25-50 USD / hour
$10 AUD
$25-50 USD / hour
₹750-1250 INR / hour
min ₹2500 INR / hour
$250-750 USD
$10-15 USD
$10-30 USD
$15-25 USD / hour
₹1250-2500 INR / hour
₹100-400 INR / hour