
Closed
Posted
Paid on delivery
I receive a recurring Excel/CSV file of 8,000 records as an email attachment that holds customer data. 1. Create a separate record locator for each distinct address. Some record locators will have only one customer attached, others will have more. 2. Create 5 files with data drawn from each record locator.
Project ID: 40587092
90 proposals
Remote project
Active 1 day ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
90 freelancers are bidding on average $117 USD for this job

HI there already i have checked project details job is clear so please contact me then i will do it now, thank you
$30 USD in 1 day
8.7
8.7

Hello, I understand your project requirements and can complete this task efficiently with high accuracy and attention to detail. I am committed to on-time delivery, quality work, and long-term client relationships. Let's discuss your project and get started.
$180 USD in 3 days
8.5
8.5

I can automate this workflow to process each 8,000-record Excel/CSV attachment, generate a unique record locator for every distinct address, group customers correctly, and create the 5 required output files. The solution can run automatically whenever a new email arrives, ensuring fast, accurate, and repeatable processing. Ready to provide a quick sample. Which email platform do you use (Outlook or Gmail)?
$50 USD in 1 day
8.0
8.0

With my extensive experience in data management, especially in Excel and CSV files, I can guarantee you a comprehensive solution for your recurring 8,000 records task. My mastery of macros/VBA, Power BI, pivot tables, and data analysis will make creating record locators for distinct addresses seamless, and I'll ensure that each record locator contains the accurate attached customers. Having understood that you require five different files drawn from each record locator, I'll utilize my skills in data extraction to guarantee absolute accuracy and precision. Additionally, my expertise in Excel automations will save you valuable time by streamlining the entire process effectively. Choosing Work-Nix Solutions guarantees you not only proficiency but also innovation, precision, and impactful tailored solutions. I understand that every business is unique with specialized needs; thus, I take pride in delivering high-impact services that remove roadblocks to your growth. Let me put my data wizardry at your service to transform your customer data into a powerful influence that accelerates your growth. Let's get started!
$30 USD in 1 day
8.2
8.2

Hi, I can do this project right now with 100% accuracy. If you need any sample please let me know. Thanks
$100 USD in 3 days
7.9
7.9

With over [X years] of experience as a data analyst, I am more than well-equipped to handle your project with precision. My skills in data extraction and expertise in Excel come to the fore when dealing with tasks exactly similar to yours. My previous work entails handling large volumes of customer data, anticipating all scenarios that may arise from inconsistent formatting or duplicates. Regarding your specific requirements, my strong suit in data analysis can efficiently provide a unique record locator for each distinct address, ensuring accurate identification and association between customers. Moreover, my proficiency in Excel can effectively segment the extracted data into five comprehensible files, ready for immediate utilization. Hiring me for this task avails you not only an expert on data extraction in Excel but an efficient professional who values timely delivery and quality. Can't wait to get started!
$140 USD in 1 day
7.7
7.7

As an experienced freelancer with a diverse skill set, including Data Extraction and Excel proficiency, I am confident in my ability to handle your project efficiently and effectively. My focus is on delivering top-quality work on time and exceeding client expectations, exactly what you need for your recurring customer data project. Drawing from my substantial experience in data processing, I have adopted specialized tools to deal with large data-sets like yours. So, breaking your 8,000 record excel file into five separate files using distinct record locators really wouldn’t be taxing for me. You can also trust that each record locator will be meticulously generated to ensure accurate customer-to-address association. Lastly, I understand the significance of proactive and transparent communication while handling such projects. Hence, expect regular progress updates from me throughout the project's life-cycle. Your timeframe is paramount; I assure you it'll be met without compromising quality. Let's discuss the finer details of your project so we can get those customer CSV data accurately extracted and sorted as soon as possible. Look forward to developing a long-term business relationship with you.
$150 USD in 1 day
7.6
7.6

Hey, As a seasoned Excel expert with strong skills in data extraction and manipulation, I’m confident in my ability to take your recurring CSV files and precisely create separate record locators for each distinct address. My experience with Excel VBA and Macros, Google Sheets Automation, and Data Cleaning & Processing make me uniquely well-suited for this task. I can quickly generate the 5 needed files from the record locators too. Thanks
$50 USD in 1 day
7.1
7.1

I can automate this workflow so that each time you receive the Excel/CSV attachment, the data is processed with minimal manual effort. The solution will: • Group all records by distinct address and generate a unique record locator for each address, whether it contains one customer or multiple related customers. • Build five separate output files using the data associated with each record locator, following your required structure and business rules. • Handle recurring files consistently, including validation, duplicate checks, and logging of any problematic records.
$200 USD in 5 days
7.3
7.3

Hi, I am a skilled Excel professional from Vietnam with 25+ years of experience. I can help you create 5 files according to your requirements. I am currently available and ready to commence work immediately. How can I help you with your Excel task? Best regards, Duong
$100 USD in 5 days
7.0
7.0

Hi there, I have carefully reviewed the project requirements for extracting customer CSV data and creating record locators. I understand that you receive a recurring Excel/CSV file with 8,000 customer records and need to create separate record locators for each distinct address, as well as generate 5 files with data from each record locator. Let's chat and discuss it further. To handle your project, I will start by developing a script in Python to parse the CSV file, identify distinct addresses, and create unique record locators. I will then extract data for each record locator and generate the required 5 files using pandas library for data manipulation. The clear deliverables of the project are creating unique record locators for each address and generating 5 files with data from each record locator. Before signing-off my bid, I would like to ask a question, i.e., how do you prefer the output files to be formatted? Warm Regards, Aneesa.
$100 USD in 1 day
6.4
6.4

Hello, I am a data processing specialist who will take your recurring Excel/CSV file of 8,000 records, create a unique record locator for each distinct address (with one or more customers per locator), and split the data into 5 separate files based on those locators. I will deliver the 5 output files in your preferred format (Excel or CSV) and provide a brief summary of the allocation. Please share a sample file and specify any naming conventions for the locator. I can start immediately. Thank you. Regards, Zafar
$100 USD in 1 day
6.2
6.2

Hi, I can automate this workflow so each new Excel/CSV file can be processed with minimal effort. The solution will: * Group customers by their unique address and generate a record locator for each address. * Ensure all customers sharing the same address receive the same record locator. * Create the 5 output files based on those record locators, following your required structure. * Be designed to handle the recurring 8,000-record file consistently each time. One question: How should the records be distributed across the 5 output files (for example, by record locator, number of records, or another rule)?
$140 USD in 2 days
5.5
5.5

Hi, I can process your recurring Excel/CSV files, generate unique record locators for each distinct address, group related customer records, and create the 5 required output files accurately. I’ll ensure clean data handling, proper formatting, and a repeatable process for future files.
$30 USD in 1 day
6.1
6.1

Hi There! We have a team of 62 professionals with over 9 years of experience automating Excel and CSV data processing for fast, accurate results. Here’s how we can help: 1. Group 8,000 records by distinct address and generate unique record locators. 2. Create the required 5 output files from each record locator with validated data. 3. Build a repeatable workflow for recurring Excel/CSV files with accuracy checks. Can you share the required structure and fields for the 5 output files?
$140 USD in 7 days
5.4
5.4

Hello, I understand you need to automate the processing of recurring Excel/CSV files by grouping customers with the same address into unique record locators and generating five separate output files based on those groupings. With 10+ years of experience in Excel automation, data processing, and CSV workflows, I'll build a reliable solution that accurately handles all 8,000 records, minimizes manual work, and delivers the required files in the exact format you need. Let's discuss your file structure and the rules for splitting the five output files. thank you Regards Gaurav Garg
$200 USD in 7 days
5.2
5.2

Hi, I can automate this workflow and deliver a reliable solution for your recurring Excel/CSV files. The solution will: Process each emailed Excel/CSV file (approximately 8,000 records) Create a unique Record Locator for every distinct address, grouping customers correctly Generate 5 separate output files based on each record locator according to your required format Preserve data accuracy and consistency for every run I can build the solution using Excel VBA, Python, or Power Query, depending on your preference, and provide clear instructions so you can reuse it with future files. I'm ready to start immediately.
$30 USD in 1 day
5.2
5.2

Hello there, I can automate the processing of your recurring 8,000-record Excel/CSV attachment, assigning a unique record locator to each distinct address and correctly grouping all related customers. I will generate the five required output files from each locator using consistent rules, clean field mappings, and validation checks to prevent duplicates, missing records, or incorrect groupings. The solution will be accurate, repeatable, and documented so each new emailed file can be processed quickly with minimal manual work.
$120 USD in 1 day
5.0
5.0

Hi! I can help automate and organize your Excel/CSV data accurately. I’ll process the 8,000-record file, create a unique record locator for each distinct address, group all customers under the correct locator, and generate the 5 required output files exactly to your specifications. I have strong experience with Excel, CSV processing, data cleaning, deduplication, and Python automation, ensuring fast turnaround and error-free results. I’m available to start immediately.
$30 USD in 1 day
4.9
4.9

Hi, As an experienced Data Engineer, I am well-equipped to handle the challenges of your project. I have a proven track record in managing and extracting valuable insights from large scale data. So I can help to processing 8,000 records using an automated script. Please message me so that we can discuss further. Also please share sample CSV file and detailed requirements. Kind Regards Masood Ahmed
$150 USD in 7 days
5.1
5.1

Catskill, United States
Member since Jul 16, 2026
min $50 USD / hour
$1000-3000 USD
$15-25 USD / hour
₹750-1250 INR / hour
₹750-1250 INR / hour
₹12500-37500 INR
₹750-1250 INR / hour
£10-20 GBP
₹12500-37500 INR
₹1500-12500 INR
₹750-1250 INR / hour
$30-250 AUD
₹750-1250 INR / hour
$10-30 USD
$8-15 AUD / hour
₹1500-12500 INR
₹600-1500 INR
₹1250-2500 INR / hour
€30-250 EUR
$2-8 AUD / hour