Find Jobs
Hire Freelancers

Need Developer to Automate Process of Inserting Data into Excel Sheets and Exporting into JSON

$8-15 USD / hour

Closed
Posted almost 5 years ago

$8-15 USD / hour

I have an Excel file that contains a dynamic amount of sheets with a dynamic amount of data and I also have a folder that contains a dynamic amount of sub-folders, with each one having a 1:1 relationship of sub-folders in the folder to sheets in the Excel file. The data within the Excel sheets represent individual items with several attribute fields classifying the item, refer to "DataExample" in the attached project files to see an example. The sub-folders have an equal amount of images as items in each sheet, refer to "ImagesExample" in the attached project files to see an example. I need some slight data conditioning to be performed on the image name prior to inserting it into the corresponding "Image" column of the Excel sheet. This includes ensuring all file extensions are ".png" and do not contain certain characters / symbols. This needs to be performed for every sheet and every folder that is supplied. I am typically processing around 1,000 data entries at a time - I don't need this to be lightning fast, I just want to be able to specify the file paths and have the program handle the work for me. After the data has been inserted, I need to then extract the completed entries into a JSON formatted file, refer to "JSONExample" in the attached project files to see an example. Once all of this has been completed I am interested in pulling some simple analytics to summarize all the data that was processed such as sorting all of the individual Types or Styles into respective sheets and having a count of each one. I would prefer for whatever solution is created be written in Python. I am capable of doing this myself, however, I do not have the luxury of time to spend tinkering around with it as there is an urgency to the delivery of the work. Therefore, I know roughly how long this should take and how much it should cost - please do not waste my time or yours by giving me some outrageous estimate. I might have additional small projects similar to this in the future so there is definitely the possibility for additional work.
Project ID: 19619827

About the project

18 proposals
Remote project
Active 5 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
18 freelancers are bidding on average $15 USD/hour for this job
User Avatar
Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/schoudhary1553 I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sandeep
$15 USD in 40 days
4.9 (368 reviews)
8.1
8.1
User Avatar
hi. I have done similar projects before for automation of filling data into Excel sheets and export to JSON or APIs. here are a couple of my past projects: ---( https://www.freelancer.com/jobs/project-14212094/ )--- and ---( https://www.freelancer.com/jobs/project-13033141/ )--- I'm a C# developer so I can do it in C#, not in Python. other than that, all is good and I can do it according to your requirements. I'm a full time freelancer so I'm available for long term support and future projects. let me know if you're interested. waiting for your response...
$15 USD in 30 days
5.0 (111 reviews)
7.0
7.0
User Avatar
Hello, I am an independent, experienced excel expert. I can help with this task with a quick turn-around. Looking to hearing from you. Kind regards Rina B.
$12 USD in 40 days
4.9 (144 reviews)
6.5
6.5
User Avatar
Hello, how are you? I've read your job description and I'm very interested in this job. I'm a senior Python developer and I have rich experience in data processing using Python. I have developed reporting module of insurance company, POS system etc, so I'm very confident of this job. My rough estimation is 1 month. If you are OK, please ping me. I'm always ready to start work. Best regards, Peng.
$16 USD in 40 days
5.0 (9 reviews)
5.8
5.8
User Avatar
I am postgraduate (MBA) with more than 5 years of experience in financial modeling, advanced excel based tool, VBA automation and data processing. I have successfully completed similar projects, please have a look at my portfolio for details. I have developed couple of automation tools for Ernst and Young also. You can get your work done here with highest quality at lowest price. Looking forward to work with you
$20 USD in 40 days
4.9 (40 reviews)
5.6
5.6
User Avatar
Hi, I've got quite some experience dealing with Excel using .NET and I'm sure I can help you out here. I estimate the project to take less than a day. May I get some more details over the chat?
$10 USD in 40 days
5.0 (12 reviews)
4.3
4.3
User Avatar
Hello sir, To be very specific I checked your requirements , here I understand that we first need to complete the excel file based on the logic, where we need to enter paths of images in corresponding columns. once that is done now you should be able to export this into json. apart from that you need to apply some analytics logic to summarize the data. I can complete this job in 25 hours. its approximately 3 days of my work. I am a professional python programmer, so can write this script in python very efficiently and make it accurate. thanks, Rajdeep
$15 USD in 25 days
4.4 (8 reviews)
4.2
4.2
User Avatar
hey i am experienced developer here with over 4 years of work experience and during this span of time i have worked on large number of projects for python and also C#. i can write this script for you as i have solid expertise in this field. i will use multi threading to make it faster. and will add extra checks that you need to to add or asked me to add. i always ensure quality work to my clients. if you have any query please let me know. Regards Tuheed
$20 USD in 40 days
5.0 (6 reviews)
3.4
3.4
User Avatar
Hello Sir, Good day! I read you project details. You requirement is data replace work . I am highly encouraged about your project because i have experienced data processing work more than 10 years. Moreover, my photo editing quality is batten than others and maintain time schedule work. I was doing only data entry work 10 years. Now I have a experience editing team. After that, I hope you are doing experience my work. And I will provide top quality work. We can discuss more. Thank You Roy
$8 USD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi there, I’d like to be considered for your position. I’m a strategic writer with a strong background developing online content, including blog posts, social media posts, articles, press releases and other branded copy. I can turn a phrase in a way that represents your brand and appeals to your target audience. Whether you need a formal, serious tone or a more playful one, I can make the transition with ease. Strong background using excel sheet .
$11 USD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I know python and shell scripting. I have 7 years of experience in data analysis and coding in python and shell scripting.
$11 USD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I can do this job. I would, however, need clarifications because there are not attached files anywhere. I do not see the file "DataExample", "ImagesExample" and "JSONExample".
$11 USD in 15 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have wriiten a similar script in my company to handle the multiple sheets from excel using python and this makes me proper candidate for this task. Also i have done my post graduate diploma in Data Analytics and done many academics project on python and R.
$11 USD in 6 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Los Angeles, United States
0.0
0
Member since May 16, 2019

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.