Lukket

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

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.

Evner: C# Programmering, Dataindførsel, Databehandling, Excel, Visual Basic

Se mere: import live data into google sheets, sql server bulk export to text file, import data from excel to sql server using ssis package, sql server bulk copy from one table to another, inserting data from excel to sql table, import data from excel to sql server using query, importing data from excel to sql server 2012 using ssis, how to import data from excel to sql server, company data excel sheets, need web scraper takes search data excel, automate data excel webpage, macro place data multiple sheets entry excel, data grab excel sheets, php importing data excel multiple sheets, reading data excel sheets, excel combine data different sheets, excel data entry sheets, excel grab data multiple sheets, print sheets data excel, excel vba exporting data multiple sheets

Om arbejdsgiveren:
( 0 bedømmelser ) Los Angeles, United States

Projekt ID: #19619827

20 freelancere byder i gennemsnit $15/time for dette job

schoudhary1553

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. Pl Flere

$15 USD / time
(335 bedømmelser)
7.9
polarjin2017

Hello? I have gone through the job details carefully and I am excited to start working on this project. I am ready to start work immediately. Here are my working result in c# [login to view URL] read xml file Flere

$15 USD / time
(95 bedømmelser)
6.7
XeeChaun

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/ )--- an Flere

$15 USD / time
(92 bedømmelser)
6.8
rinabuoy13

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 / time
(130 bedømmelser)
6.4
peng72083

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 Flere

$16 USD / time
(8 bedømmelser)
5.6
bhupendrayadav

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 m Flere

$20 USD / time
(24 bedømmelser)
4.4
harshdaga

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 / time
(12 bedømmelser)
4.3
rajdeepa555

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 t Flere

$15 USD / time
(8 bedømmelser)
4.2
arash18k

Hi, for reading dynamic folder and files in Excel, I previously developed and Excel file that does this, please have look at below link. So we can easily pull all data from sub folders (including folders names and imag Flere

$15 USD / time
(7 bedømmelser)
3.5
Iamtuheedakram

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 e Flere

$20 USD / time
(6 bedømmelser)
3.4
WangJinStar

✫✫✫ Dear Hiring Manager ✫✫✫ Wish you a very good day!!! After reviewing your post, I am very interested in that due to my experience. I’d like to be considered for your project position. I am an expert Web develop Flere

$10 USD / time
(1 bedømmelse)
2.4
barkha1806

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 Flere

$11 USD / time
(0 bedømmelser)
0.0
jchristertg

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 / time
(0 bedømmelser)
0.0
SUCHITA4887

I know python and shell scripting. I have 7 years of experience in data analysis and coding in python and shell scripting.

$11 USD / time
(0 bedømmelser)
0.0
atin162

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 Flere

$8 USD / time
(0 bedømmelser)
0.0
khadijaqureshi93

we are the expert in application and web development and we provide the best solutions with confidence and efficiency. we have high-performance rate and low prices. our motto is to provide best and in detail work withi Flere

$11 USD / time
(0 bedømmelser)
0.0
christinestraub

Hello Nice to meet you. I'm a full-stack developer with 5 years of experience in web development. [login to view URL] [login to view URL] [login to view URL] [login to view URL] and also http://ww Flere

$20 USD / time
(0 bedømmelser)
0.0
shalini60328

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 co Flere

$11 USD / time
(0 bedømmelser)
0.0
$12 USD / time
(0 bedømmelser)
0.0
$33 USD / time
(0 bedømmelser)
0.0