Find Jobs
Hire Freelancers

Convert JSON file to Excel

£20-200 GBP

Completed
Posted over 1 year ago

£20-200 GBP

Paid on delivery
See attached JSON file. The structure is quite complex as it's the output from an app that lets you change the the way the data is presented, thus you get a series of data objects containing arrays of more data objects in a hierarchy, with properties of those objects defining what data you are looking at. It's further complicated by the fact some of the data is stored in a different object, (you'll see three objects at the top of the hierarchy). So this won't go through any existing parser, it will probably need to be decoded programatically. In simple terms read through a series of nested arrays, in the first data object, look up supplementary data from a set of arrays in the third data object, (matched by a unique ID) and output as a rows in Excel. First worksheet - I've tried to walk through the logic required in the attached Excel, you'll see a reference to the JSON with examples and psuedo code to the right referencing how to create the Excel output from that example. Second worksheet gives you an idea what the finished file will look. Presenting sporting event data. I'd love this to be done in some sort of scripting language or if possible via a macro in the Excel spreadsheet, so I could step through the code and learn how the process works but the main goal is that I can run this repeatedly on a Mac to create these files from live data.
Project ID: 35530141

About the project

35 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
Hello, My name is Sorin and I'm from Romania. I should be able to do this in Excel using Power Query so it will run on Mac as well. I have given a try and it works fine. Please get back to me if you are interested and if you want a sample from the attached JSON file. Kind regards, Sorin
£50 GBP in 1 day
5.0 (75 reviews)
5.6
5.6
35 freelancers are bidding on average £140 GBP for this job
User Avatar
First, thank you for the excellent project description! I can provide you a simple-to-use Python script (what you be able to run on your Mac) that will convert your JSON into Excel file. I can complete it in less than a day for just £100 GBP. Roman
£100 GBP in 1 day
5.0 (193 reviews)
7.0
7.0
User Avatar
بسم الله الرحمن الرحیم I can do it in less than 24 hrs, Insha Allah
£135 GBP in 1 day
4.9 (169 reviews)
6.5
6.5
User Avatar
Hello there Iam excel EXPERT level with top rating done projects before I can done this within short time also i can provide previous samples for make you understanding better about me and my skills. When do you need this finished? I understand how annoying it is and can get this fixed for you quickly! Please see the sample I fixed. I look forward to working on this project with you. Regards
£186 GBP in 2 days
4.9 (200 reviews)
6.2
6.2
User Avatar
⭐⭐⭐⭐⭐ python expert ⭐⭐⭐⭐⭐ Hi, Dear. I can do your project with python script easily. I would like to discuss more regarding project via chat. Please invite me to chat. Thanks for reading my proposal.
£100 GBP in 1 day
5.0 (4 reviews)
5.5
5.5
User Avatar
--------------I CAN DO IT RIGHT AWAY--------------- ⭐⭐EXPERT IN EXCEL⭐⭐ I can convert JSON file into excel... Dear client, I can help you with your project of data entry in excel, VBA, EXCEL MACROS, VBA Scripting, building an excel file, excel dashboard, pivot tables, charts, v lookup, word, excel database, and Microsoft office at large since that is my area of expertise within your minimal budget and provide quality work within the time required, I can also provide samples of my work. Let's discuss more in the chatbox. Regards Rahul
£130 GBP in 2 days
5.0 (29 reviews)
4.7
4.7
User Avatar
Hello, I'm a software engineer. Ok, just to let you know I'm not a bot, it is about football matches. I have checked the whole JSON file and the desired excel file. I can do this using Python, so, what I can offer you is an application which will convert the JSON file to the desired excel file. Text me if interested. Thanks Martin ------ I invite you to check my profile by clicking on my name, here are some of my clients reviews: - "Great professional. Very fuss free and understands my requirements very well. Will definitely look to work with again!" - "Great communication, delivered super fast solution. Would hire him again, definitely!" Note: Given price on this bid might be a placeholder, final price will be discussed after final details.
£200 GBP in 7 days
5.0 (3 reviews)
4.5
4.5
User Avatar
Yo! I am skilled Data Entry coder with skills including Excel VBA, Mac OS, JSON, Programming and Excel. I have read your all given information in description and i am ready to do various type of work for you and available 24*7*365 for you. 1 I can do Data RESEARCH from any platform for certain subjects. 2 I can create the accurate DATABASE (EMAIL/CONTACTS/PERSONAL INFO etc*. 3 I can properly fill a Google Sheet/EXCEL/WORD. Have good working skills of Excel/PDF. 4 I am Expert in DATA ENTRY and do any kind of that work. 5 I can Find data from INTERNET RESEARCH/ WEB SCRAPING. 6 I can Work as a VIRTUAL ASSISTANT for daily any kind of task. 7 I can work as per client TIME ZONE if they want and provideS 15hrs services in a day. 8 I have 3YRS of good experience of as a VIRTUAL ASSISTANT and done various type of task. 9 I have the excellent skill of SEO/DIGITAL MARKETING/SOCIAL MEDIA MARKETING/MANAGEMENT. 10 I can create MEMES/posting,strategy for increasing likes,followers of social media. 11 I have expertise in WORDPRESS sites creating/product Uploading/WOOCOMMERCE. 12 I have Good skills in SHOPIFY, PRESTASHOP, MAGENTO etc for DROPSHIPPING. 13 I Can Write Optimized SEO friendly impressive articles for BLOG and get 1 rank. 14 I am fast Learner. Grab The instructions from client instantly and implement. 15 I can get 100% results and Give Guaranteed work satisfaction from client instructions. Please send a message to discuss more regarding this project. Thanks & regards
£20 GBP in 1 day
4.9 (6 reviews)
3.8
3.8
User Avatar
Hi I have read your description carefully. ⭐ I have rich experiences in JSON to CSV, html, JS, css, data entry. ⭐ I worked on many similar projects. I can guarantee the quality of the job. Please kindly message me. Thank you.
£100 GBP in 2 days
4.9 (6 reviews)
3.8
3.8
User Avatar
Hi there, I am a Professional Data Entry Person & have More Than 7 Years Experience. My skills: 1: Microsoft word 2:Microsoft excel 3: Power Point 4: Pdf to word file Here is just a small overview of My Services how I can help free up your time. Don't see what you need? Let's talk! You will receive: ☑ High-Quality Deliverable ☑ An On-time Delivery in a Proper Format ☑ 100% Confidentiality ☑ Revisions Provided Thanks and best regards Muhammad ayyaz bhatti
£250 GBP in 7 days
4.5 (11 reviews)
3.4
3.4
User Avatar
Hi there can help you to enhance and automate your business and work-related tasks based on 6+ Years of experience in Excel, Macro, and VBA development. Having worked as a controller, business consultant, and project manager I have quite a toolset full of Creating Excel Spreadsheets - Excel VBA - Excel Macros - Custom Functions - Complex Formulas - Dashboard & Charts - Custom Spreadsheets - Pivot tables & Summaries - Automate your repetitive Excel processes with VBA macros - Generating pdf reports from Excel Data - Convert PDFs to Excel Worksheets Formatting of Excel Spreadsheet: - Modify Font Case/Style - Sort & Filter - Find & Replace - Remove Duplicates - Remove Empty Rows - Borders & Colors - Content Alignment in Cells - Excel Page Layout/Print Setting Thanks
£135 GBP in 7 days
5.0 (2 reviews)
3.2
3.2
User Avatar
✅✅✅ Full Experiences in Converting JSON into Excel(CSV) ✅✅✅ Hi, Dear! I read your requirement carefully. I can make a convert from json into excel format with python, Excel VBA , java and etc which you prefer. I can start Your work right now... Hope to discuss with you soon. Thanks & Best regards! https://www.freelancer.com/u/torrikress2
£180 GBP in 3 days
5.0 (7 reviews)
3.3
3.3
User Avatar
Hi there, I very frequently deal with JSON to Excel conversion in building my web applications so that web data can be downloaded. I can deliver this work effectively.
£50 GBP in 1 day
5.0 (9 reviews)
3.1
3.1
User Avatar
Hello. How are you? I have many experience for Json and Excel/VBA development. I just now checked your description. We can discuss more detail in chat. I can complete your project. If you give me a project, I will try my best. Thank you.
£150 GBP in 2 days
5.0 (3 reviews)
2.1
2.1
User Avatar
Hi, I am MS Excel specialist with 10+ years of experience in VBA and dealing with complex datasets. I will develop logic for your json file to be converted into Excel rows like your sample file. I will do it through VBA script so you can use it in future. Further details can be discussed over chat. Looking forward to hear from you soon. Regards, Qaisar
£150 GBP in 7 days
5.0 (2 reviews)
1.7
1.7
User Avatar
"Hi, I can do this Job, I have the experience in using Excel creating dashboards with slicers, and getting insights from data, I have finished 3 Nanodegrees from UDACITY for Data Analysis using Excel, I can start this Job right away, I am available on daily basis, Also I can provide you with a Sample of Work for Free to check the Quality of Work, I'm Looking Forward to working on this Project, Waiting for your Response. Regards Rahima"
£30 GBP in 1 day
5.0 (2 reviews)
1.4
1.4
User Avatar
Hello, I read your job details and I can figure out the requirements. please contact me to share more information and start to work on it.
£100 GBP in 3 days
5.0 (1 review)
1.4
1.4
User Avatar
Hi there, I can parse the json data using Python language and export it to excel. Can we have a chat to discuss it further in detail?
£150 GBP in 1 day
5.0 (1 review)
1.4
1.4
User Avatar
Hi there.. I'm personal freelancer and very interesting with your project are offering and also already read your project description.. so hopefully could help you to script conversion from JSON format into XLS spreadsheet using PHP.. and currently I'm ready and can do this immediately.. I'm looking forward to discuss and collaborating with you! Thank you Vincent
£100 GBP in 2 days
5.0 (1 review)
1.0
1.0
User Avatar
Dear client! My name is Santiago from Spain and I am machine learning with Spss, Scraping with python, google sheet & Business Analyzer of Solar Energy-Car Market. I have 5 years of experience in excel, business and finance, but these are not my major skill. It is mathematics, I was took part in IMO which needs team-work sprit, amazing creation. Then I was major in Stochastic & Statistic Theory and got Bachelor's degree in Toronto. As you know, my major skill is the basic field of Excel Formula and Financial & Business Modeling. I read your description and I know what you need. Actually, your project needs my skill and experience in Coupons, Bond Convexity and Duration. I'll explain about my experience and writing skill on chatting. Please contact me and discuss more details. Thank you for your kind attention. Regards. Santiago Machado
£135 GBP in 7 days
5.0 (1 review)
0.6
0.6
User Avatar
Dear Sir/Ma’am, I am very much interested in your job posted. You have been looking for a Software Developer who is able to deliver you the best. I consider myself as the right choice for you because I have the right skills and potential to match your needs. I am an established Software Developer and additionally a graduate in Computer Science. Through hard work I have gained some excellent skills in Software Development. So, I want to explore the vast possibilities in Software Development. I expect that your fine judgment will be able to pick me up from the rest of the candidates.
£135 GBP in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED KINGDOM
Bangor, United Kingdom
5.0
2
Payment method verified
Member since Dec 9, 2022

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.