Find Jobs
Hire Freelancers

CSV File Data extraction

$20-30 USD

Completed
Posted about 1 year ago

$20-30 USD

Paid on delivery
I'm looking for an experienced freelancer to create a script for data extraction from multiple CSV files and deliver it in 1 xls/csv file. The data will be numerical and it needs to be validated before it can be delivered. The data extraction needs to be done as accurately as possible, so someone with prior experience in this field is ideal. If you have the knowledge and experience necessary to do the job accurately and efficiently, please apply for this project. Bellow you can find the algorithm to be used for data extraction: - on D column we check and extract each 4 digit numbers present and add in the the new xls file in the first column. - for each 4 digit numbers we extract the corresponding number from column D,E,F and G - remove dot from Column D, cell data :ex: 32.000 - to be translated to 32000 We would do the same with the other CSV files, placing data in the same xls/csv on the same sheet. Attached you can find an example, we need to extract all data with the same pattern as above from all csv in the archive and added it to a new csv/xls file. ex: Column C/ Cell 4 data: 4622: Commerce 4776: Comert cu amanuntul al florilor, plantelor si semintelor; comert cu amanuntul al animalelon de companie si a hranei pentru acestea, in magazine specializate 4789: Comert cu amanuntul prin standuri, chioscuri si piete al altor produse Column D/Cell 4 data: '32.000 Column E/Cell 4 data from column E Column F/Cell 4 data from column F Column G/Cell 4 data from column G Extract: Column 1, cell 1: 4622 Column 2 cell 1 32000, Column 3; cell 1 content from E, Column 4; cell 1 content from F, Column 3; cell 1 content from G Thank you!
Project ID: 36447932

About the project

66 proposals
Remote project
Active 1 yr ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
$0 USD in 1 day
4.9 (275 reviews)
6.8
6.8
66 freelancers are bidding on average $25 USD for this job
User Avatar
Hi. I have written many automation Excel projects. Ready to write your project. Will complete within 1 day
$30 USD in 1 day
4.9 (378 reviews)
7.4
7.4
User Avatar
Hello Honor Good day, I've worked on similar projects like this with excellent results. 10 Years of Professionalism and experience specified. So That I have a straightforward way to complete the project and can deliver quality notes to tight deadlines. You can see an example of one of those projects in my portfolio here: www.freelancer.com/u/oadsmedia I'll Provide You with Quality work according to your instructions. Please Award me the project so that we can discuss it more. With Best Regards! Joni Debnath
$30 USD in 1 day
5.0 (94 reviews)
6.9
6.9
User Avatar
Hello, I'll be glad to assist you with this project. I can work with you during the next hours to have this done. I will complete this project with 100% accuracy. Please contact me to discuss further details! Thank! Sandeep Singh
$20 USD in 1 day
4.9 (185 reviews)
6.8
6.8
User Avatar
Hello! I'm a Excel and VBA expert more than ten years. I have completed many complex projects in my practice and I am ready to carry out your project in the reasonable price and in the shortest possible time and with the highest quality! You can read reviews about my work at: https://www.freelancer.com/u/VladimirLilenko?w=f Regards, Vladimir
$25 USD in 1 day
4.9 (121 reviews)
6.6
6.6
User Avatar
I can start now. As a specialist in Excel and VBA, I have experience working with clients across a range of industries, including finance, healthcare, and technology. I have completed numerous projects involving data analysis, modeling, and automation, and have a deep understanding of the tools and techniques needed to create effective dashboards that provide valuable insights and visualizations. I have all these skills Data Processing, Excel VBA, Excel Macrosand Excel. Please feel free to reach out to me to discuss your project in more detail. I am always happy to provide examples of my work and answer any questions you may have. Thank You ?
$25 USD in 2 days
5.0 (112 reviews)
6.0
6.0
User Avatar
Hello there! I am available to start immediately. I will build a script in python to extract data from multiple CSV files into one Excel spreadsheet. Can we talk? Thank you!
$35 USD in 1 day
5.0 (23 reviews)
5.5
5.5
User Avatar
Greetings, I am an Advanced Excel Macro & VBA expert and an accountant. I understand the requirements and am able to start this right now. Please initiate a chat so we can discuss more
$30 USD in 1 day
5.0 (57 reviews)
5.2
5.2
User Avatar
Sir, I am well versed in these kind of jobs and can do your project as per requirement. I have over 12 years of experience. I am very much able to work on this. ***I am ready to start Waiting to hear from you. with thanks and regards
$25 USD in 3 days
4.6 (52 reviews)
5.8
5.8
User Avatar
Hi - I looked at your file and I think because of extra ' character in your file the extraction might have created some issues. I have recently did a heavy consolidation of csv files into one master file so I can do this quickly and effectively for you. I can write a sample if that might help you decide. You can reach me out on my chat to discuss on this further. Regards Vishy
$25 USD in 7 days
5.0 (26 reviews)
4.2
4.2
User Avatar
Get the data from csv files to on file with the rules validation, checks, format you described.....
$30 USD in 1 day
5.0 (10 reviews)
4.3
4.3
User Avatar
Have gone through the file and seek some clarification. Want to know whether you are open to alternative provided the end result is as per your requirement and data integrity ensured. Open the DM so that things can be clarified. Happy to support on your engagement. Regards,
$20 USD in 1 day
5.0 (4 reviews)
4.3
4.3
User Avatar
I have reviewed the complete description of your job post and I'm confident I will meet your expectations and give you 100% satisfaction and quality work. I'm all set and available to start working on it right away. Waiting for your message. Thanks
$20 USD in 1 day
5.0 (10 reviews)
3.6
3.6
User Avatar
Hello I'm an expert in data manipulation using Python, I'm a Python developer with intensive experience in data automation data manipulation I have done many similar projects recently, I will create a script to extract the data from multiple CSV files and deliver it in one csv or excel file I can handle this task very efficiently and you can expect 100% accuracy from me,I will show you similar projects I have done before I will support my script, understand the importance of keeping clients satisfied, and be available for any inquiries or concerns after completing the job. Let's discuss more details in the chat looking forward to working with you Best regards, Mohamed
$25 USD in 3 days
5.0 (18 reviews)
3.7
3.7
User Avatar
Hello there, Thank you for posting this job on Freelancer.com. We have read your project description; you need to create a script for data extraction from multiple CSV files and deliver it in 1 xls/csv file. We have vast experience in Excel, Data Entry, Excel VBA, Data Processing, Business Analysis, Web Research, Web Scraping, Data Mining, and Data scraping, and We are confident that we can produce quality content for you that will be of interest to your readers. We are available for a full-time writing position, and We are happy to work on a freelance basis if that is what you prefer. If you have any questions or special requirements, please don’t hesitate to concern with us. We would be thrilled to be able to assist you further with your project. Thanks & regards Krishna.
$25 USD in 1 day
4.9 (12 reviews)
3.4
3.4
User Avatar
I understand you are looking for an experienced freelancer to create a script for data extraction from multiple CSV files and deliver it in 1 xls/csv file. If you have the knowledge and experience necessary to do the job accurately and efficiently, please apply for this project. My name is Mohammad and I am an experienced freelancer with extensive data processing skills. I have worked on numerous projects similar to this before and can guarantee quality work with 100% accuracy, on time delivery, respecting your deadlines as well as guaranteeing quality work. I am confident that I can provide the best solution for your needs - let me know if you would like more information or would like me to start discussions about the project?
$30 USD in 1 day
5.0 (6 reviews)
2.9
2.9
User Avatar
Hello, I have good experience in CSV along with powershell, SQL and VBA I can you to complete this project, please ping me for further discussion thanks
$30 USD in 2 days
5.0 (3 reviews)
3.0
3.0
User Avatar
Dear Sir/Madam - I am the best freelancer for your job. Choose me and I will deliver immediately. I am a hard-working and driven individual who isn't afraid to face a challenge. I'm passionate about my work and I know how to get the job done. I would describe myself as an open and honest person who doesn't believe in misleading other people and tries to be fair in everything I do.
$25 USD in 7 days
5.0 (4 reviews)
2.7
2.7
User Avatar
hey there, I have read you project and I can do it for you as I worked on similar projects(data extraction) from multiple files, so I can write your code in Python as I did it in many projects before and will give you a script as *.exe as a full program file that you can run then it will extract them in the path you give to extract to, and if you contact with me to agree I will extract the data you provided as an example of my work then continue on agreement , anyway I'm waiting for you to contact me and agree on how the script would like and it's functionality, etc. so don't hesitate to contact with me regards Abdelrhman
$25 USD in 4 days
5.0 (1 review)
2.5
2.5
User Avatar
Hello there! My name is Baber and I'm a software engineer with extensive experience in data processing, Excel specifically. I understand you are looking for an experienced freelancer to create a script for data extraction from multiple CSV files and deliver it in one xls/csv file. If you have the knowledge and experience necessary to do the job accurately and efficiently, please apply for this project. I believe I am the perfect fit for this project due to my qualifications as a professional mobile developer (I have experience working with Android SDKs, iOS SDKs, Java, C# ASP.NET REST APIs and more), my dedication to deadlines and customer satisfaction as well as my ability to provide quality work with customer satisfaction. I would be delighted if you could consider me for this project. Please feel free to contact me if you have any questions or would like more information about me or any of my services. Thank you for your consideration!
$25 USD in 7 days
5.0 (5 reviews)
2.5
2.5
User Avatar
Hello Dear Client, I have reviewed the details you provided for the project and I understand your requirements. Advanced knowledge of Excel formulas and functions. I can do this work easily. Please message me so we can discuss any important questions and proceed with the work as per your needs. Kindly message me about the project so we can start the discussion. Thanks. Best regards, Muhammad Fahad
$25 USD in 1 day
4.9 (3 reviews)
2.2
2.2

About the client

Flag of ROMANIA
Tecuci, Romania
4.9
78
Payment method verified
Member since Dec 12, 2016

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.