Find Jobs
Hire Freelancers

Create a program to filter, search and sort data

$10-30 AUD

Closed
Posted about 8 years ago

$10-30 AUD

Paid on delivery
I require a programmer to create a simple program which will search an Excel spreadsheet for the parameters of the data required and then search in a CSV file to find the data then insert the data into the relevant area of the Excel spreadsheet. I will need to be able to choose the CSV file to search as there are multiple files that I would like to use this application with. All CSV files are in the same format. There is only one spreadsheet with multiple sheets for the data to be entered in to. i.e. Select CSV file to Search ---> Select Excel spreadsheet to get parameters from ---> Search CSV file ---> Insert data into Excel Spreadsheet ******************** NOTE: - The CSV files are over 1,200,000 lines long and WILL NOT fit on to a Excel sheet. - The Excel file has over 2,000 separate lines (3 to 4 columns) to check for each CSV sheet. - The data searched will need to be entered in to the corresponding (correct) date. - Total cost to be NO MORE THAN $50
Project ID: 10341580

About the project

14 proposals
Remote project
Active 8 yrs 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
14 freelancers are bidding on average $47 AUD for this job
User Avatar
I have the expertise in Excel & scripting in VBA and can do this task, quickly and accurately, as per specification. Ready to start work immediately.
$35 AUD in 1 day
4.6 (67 reviews)
5.4
5.4
User Avatar
I have 7 years of experience in .NET, VBA Macros, VB script,PS Script and VB creation with application like SAP, Internet explorer, Microsoft Outlook,PDF& Text files, MS Access and SQL Server databases. And also I have worked on extraction with websites like Amazon, Cellpex,Costco,Yellowpages,Yelp,etc., hope if awarded with this project I can make it best and better with maximum 100% accuracy and satisfaction, and the price is negotiable if required. please award me this project and contact me for further details
$50 AUD in 3 days
5.0 (59 reviews)
5.1
5.1
User Avatar
Hello there - I am an Excel genius and this looks like an interesting piece of code to write. This is bargain basement pricing but the appeal of writing this wins out. I am a native English speaker so nothing will be lost in translation. You are not quite clear about the rules and where the data goes - does it go back into the source file alongside the key that selected that data? Is there a 1:1 match of data to key or can a single excel row return multiple CSV rows? I can handle the file size for the CSV so that is not an issue. I am happy to discuss this to ensure you get what you need. Hope to hear from you soon. /R.
$50 AUD in 2 days
5.0 (9 reviews)
5.0
5.0
User Avatar
Hello, I do have several ideas regarding the project. Please share some sample CSV files. Best Regards,
$49 AUD in 1 day
5.0 (25 reviews)
4.6
4.6
User Avatar
Hi - As I understand you need an application that reads multiple CSV files for value and then fill that value against the parameter/key in an excel file. I can write an .Net application that can do it. It will be a windows application and once you run it will ask you to upload file and then start the job. PM me if we can discuss more in detail. Thanks.
$50 AUD in 1 day
5.0 (16 reviews)
4.4
4.4
User Avatar
I am an expert in Excel and Macros having more than 10 years of experience. Please consider me for the job. Pay me if you are satisfied with the work. Looking forward to hear from you soon
$55 AUD in 1 day
4.6 (9 reviews)
3.5
3.5
User Avatar
Hello, This is Kevin Kathro here from TheWebTechies Web Services. We are a reputed IT firm specialising in creating and maintaining websites and other individual project related services in various platforms including PHP, mySQL,Sopify ,Magento,Opencart,Joomla etc We have an excellent team of developers who can deliver your project within the specified time frame and as per your exact requirements. We also provide service and support even after the project is completed and submitted to the client. We have developed several websites. If you are interested we can show you our portfolio. UNDERSTOOD YOUR PROJECT. WILL BE DELIVERED IN 1 BUSINESS DAY P.S: The price and time is subjected to change depending on our final discussion of project. Thanks and Regards Kevin Kathro
$50 AUD in 1 day
4.7 (7 reviews)
3.5
3.5
User Avatar
As an expert of excel macros and VBA, this can be done easily and with 100% quality. I have 6 years experience as a VBA Developer.
$25 AUD in 0 day
4.7 (5 reviews)
2.5
2.5
User Avatar
I am very good with VBA and i can write a code for you to get this work done. It would be useful if you could share the spreadsheet.
$50 AUD in 1 day
4.4 (6 reviews)
2.3
2.3
User Avatar
Hi, I am electrical engineer and I have good experience with excel vba which will support me to finish your project. I wish I win this project
$50 AUD in 3 days
0.0 (1 review)
0.0
0.0

About the client

Flag of AUSTRALIA
Travancore, Australia
5.0
2
Payment method verified
Member since Feb 3, 2014

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.