Find Jobs
Hire Freelancers

Create a dataset (excel or access) of a large set of Excel files

$250-750 USD

Completed
Posted over 7 years ago

$250-750 USD

Paid on delivery
I have a large number of Excel files which are used as day reports to keep track of hours and materials used on our projects. These worksheets have predefined cells to input data. I am in need of a tool to upload all these excel files in order to create a database of this data. In annex I have uploaded a sample excel of such a day report. All the cells with yellow colour should be extracted to this dataset (and only worksheet 'dagstaat'). At the moment I have more than 500 of these excel files, but in order for me to report in these data I need a tool.
Project ID: 11894122

About the project

25 proposals
Remote project
Active 7 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
Awarded to:
User Avatar
Hello, I am Excel and VBA expert. I can write macro (VBA) for extracting all yellow colour cells (from 'dagstaat' sheet) to Excel dataset. All automatically. Please note that I have 100% completion rate and 5-star feedback on 50 projects.
$250 USD in 3 days
5.0 (94 reviews)
6.1
6.1
25 freelancers are bidding on average $334 USD for this job
User Avatar
Dear Hiring Manager, I am writing in response to your advertisement for a “Data Entry Assistant ”. After carefully reviewing the experience requirements of the job description, I feel that I am perfect for this job. I have done lots of data entry work such as inputting customer requests, inquire, tracking codes of products and price of products, scrap data from different types of web site, collect emails & enter them into excel, etc and so on. I also perform administrative duties including copying and faxing documents, transferring data, web research and reports to immediate supervisor. I have extensive knowledge of using MS programs such as Spreadsheets, PowerPoint, Excel, data scraping and Word along with a number of other software and programs. I also possess extensive knowledge of database programs. If you feel there is a mutual interest, I would welcome the opportunity to meet with you to learn more about your company, the requirements of the position, and how my qualifications would be a good fit. Sincerely, Motiur .
$250 USD in 5 days
4.8 (375 reviews)
7.9
7.9
User Avatar
Hi, i m serious freelancer with 100% completion rate and i believe i can help you. I've done hundreds of excel projects (with both formulas and macros) and i've never had a single problem. I believe i can automate this process for you (create a tool to import any number of files), basically you will get a simple form where you can select a folder with the files and in code i will loop through all of the files and process each one of them (extract data). If you are interested i would need couple more sample files and desired output file. As i said i m serious freelancer and i've never took a single dollar unless my solution was perfect. Thanks, Milan
$250 USD in 3 days
5.0 (552 reviews)
7.1
7.1
User Avatar
A proposal has not yet been provided
$250 USD in 3 days
4.9 (433 reviews)
7.1
7.1
User Avatar
Hi, I have more than 14 years of Excel/VBA exp and I am expert in this kind of work. Please send me more details so that I can estimate cost and time better. I have completed more than 290 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. Thanks.
$500 USD in 5 days
4.9 (175 reviews)
6.5
6.5
User Avatar
Hello, dear sir! I have registered on the forum not long ago and I have yet completed projects to www.freelancer.com. I am ready to carry out your project in the minimum price and in the shortest possible time and with the highest quality! From the Access, of course, familiar. Give me a chance to show what I can do!
$250 USD in 2 days
5.0 (85 reviews)
6.2
6.2
User Avatar
I am a statistician with advanced knowledge of microsoft excel. I have experience with data entry and statistical calculations.I work fast and deliver my projects on time. Looking forward to working with you. Thank you.
$333 USD in 6 days
4.7 (9 reviews)
4.0
4.0
User Avatar
Hi I have read out all the description given in your project and I am fully capable to deliver this Project with 100% accuracy and according to your instructions. I have worked on many projects similar to this in the past. You can ask me for a sample if you want. Please share with me the remaining details if you have any and pay me after checking the work. Regards
$250 USD in 10 days
4.9 (12 reviews)
3.4
3.4
User Avatar
Hello Sir, I went through your requirement, we can develop a tool in python , which will read all your excel file in specific way and dump into mysql. we will write a wrapper for that. Thanks, Rajdeep
$666 USD in 10 days
5.0 (2 reviews)
3.2
3.2
User Avatar
Hello sir/mam, I would like to work on your project , and I insure you that I will finish this project on time with perfect accuracy . thanks in advance Piyu Jain
$333 USD in 7 days
3.6 (3 reviews)
0.2
0.2
User Avatar
A proposal has not yet been provided
$277 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello Dears My name is Baran. I am from Istanbul. I will prepare excel master file to help you organize 500 and new worksheets. You will be able to enter new datasets easily. Let me give you a brief description about my freelance background.. My professions are * Project Management * Excel Formulas, Functions * Excel Macros, VBA scripting * Web crawler, scraper. * Data entry specialist I would like to work on work and free to start today, now Waiting your reply ASAP Have a wonderful day.
$299 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, as far as i understand, you need an import filter/script for your xls/xlsx files. You want that the first 500 files, that you have on stock are done in bulk, or you want to process each one? What kind of database are you looking for? Is this information privileged, meaning you need the database locally or you need an online database, where eventually people put the data in directly? Please let's discuss the details on chat. Thank you, Mathias.
$388 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$250 USD in 2 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of BELGIUM
Kapellen (Antwerpen), Belgium
5.0
2
Payment method verified
Member since Jul 28, 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.