In Progress

Import JSON File Into Google Sheets

I have a JSON file online and I'm needing to import this JSON file into Google sheets.

The script should automatically format the details so that each Google Sheet column & row has the correct data. Here is an example of the JSON file:

{"calendar_json":{"20170701":[{"ct":24968716,"al":"G9","dt":"23:15","pr":"805.0","aln":"Air Arabia","ad":"02/07/2017","at":"04:00","afd":["G9463"],"via":[]},{"ct":24968716,"al":"6E","dt":"22:20","pr":"836.0","aln":"IndiGo","ad":"02/07/2017","at":"03:15","afd":["6E22"],"via":[]},{"ct":24968716,"al":"SG","dt":"22:45","pr":"870.3","aln":"SpiceJet","ad":"02/07/2017","at":"03:35","afd":["SG12"],"via":[]},"sell_currency_json":{ "code":"AE","symbol":"AED" }}

Skills: JSON

See more: i have app 400 links that have to be typed into a csv file for import in our database, software write mq4, software write chip epson, useful software write book, software write web specs, free software write user guide, software write edid, free software write company profile, software write websites idea, software write book images, google tab delimited file, software write books, resx file excel import, software write protection, free software write book, google maps kml file, software write book, google suggest text file, google translation word file, actinic sample file hierarchical import, add google map html file, example iif file quickbooks import, joomla xml file news import, iif invoice example file quickbooks import, google maps xml file info window

About the Employer:
( 2 reviews ) Melbourne, United Arab Emirates

Project ID: #14427196

Awarded to:

nesarajanskillra

Will you provide google drive credentials Relevant Skills and Experience PHP,GOOGLE API Proposed Milestones $25 USD - Implementing API

$25 USD in 1 day
(7 Reviews)
4.5

10 freelancers are bidding on average $31 for this job

mohamedkaram93

Hi there! I will be happy to help you with that one. The JSON data will be formatted into their respective columns. The script can be invoked using a custom menu or a button to connect to the API or the file, read t More

$25 USD in 0 days
(1 Review)
2.1
sidhique1

I have 2 years of experience in Java and Javascript based application development. JSON processing is one the areas I am good at.

$20 USD in 1 day
(1 Review)
0.6
$25 USD in 1 day
(0 Reviews)
0.0
axiomswb

we have expertise in this domain(web scraping , Jason, google sheet- Excel VBA , data processing , data entry). Client satisfaction is our main motto for long term relationship. Relevant Skills and Experience Jason, g More

$50 USD in 1 day
(0 Reviews)
0.0
sanakashif906

A proposal has not yet been provided

$66 USD in 2 days
(0 Reviews)
0.0
vw8092236vw

A proposal has not yet been provided

$25 USD in 1 day
(0 Reviews)
0.0
leexxg

Hi,ready to build that script on python3, wrapp it into exe if you need it Relevant Skills and Experience python3, with json, and google sheets modules Proposed Milestones $20 USD - milestone hope for cooperation al More

$20 USD in 1 day
(0 Reviews)
0.0
ibrahimerdem

Hi, I am 10+ years experienced software developer but I am new here.I have a lot of data scraping and parsing experience in professional life. Relevant Skills and Experience I have worked as data analyst in financial More

$20 USD in 1 day
(0 Reviews)
0.0
srinichal

I am an expert in delivering custom scripts and softwares willing to discuss further details about the project Relevant Skills and Experience I am an expert in delivering custom scripts and softwares willing to discus More

$35 USD in 1 day
(0 Reviews)
0.0