Google Docs (Spreadsheet) Convert JSON to visual friendly output.

Kapalı İlan edilme: 7 yıl önce Teslim sırasında ödenir
Kapalı Teslim sırasında ödenir

I have a google docs spreadsheet that has data like this in a cell.

a:2:{i:1;a:4:{i:1;a:1:{i:0;s:2:"PERSON1";}i:41;a:1:{i:0;s:4:"Male";}i:113;a:1:{i:0;s:6:"happy";}i:117;a:1:{i:0;s:6:"44plus";}}

i:2;a:4:{i:1;a:1:{i:0;s:2:"{PERSON2";}i:41;a:1:{i:0;s:6:"Female";}i:113;a:1:{i:0;s:6:"Excited";}i:117;a:1:{i:0;s:5:"18_25";}}}

Basically need some kind of parsing code that presents this in a more visually friendly way. E.g.

Name: PERSON1

Gender: Male

Age: 44plus

State: Happy

Name: PERSON2

Gender: Female

Age: 18_25

State: Excited

It would still need to be contained in the cell, so am open to ideas....

e.g. hyperlink PERSON1 and then when clicked (or mouseover) a little box pops out with

the details.

Excel JSON

Proje NO: #13819258

Proje hakkında

33 teklif Uzak proje Aktif 6 yıl önce

Bu iş için 33 freelancer ortalamada $149 teklif veriyor

cgullapalli

Bid Summary Hi I am good at google scripting.I would like to discuss the project in detail in the chat. It is possible to get the data as required. I have similar experience in the past. Please share the sheet. Proj Daha Fazla

$100 USD in 2 gün içinde
(946 Değerlendirme)
8.1
asin1987

Bid Summary I am an Excel expert and I will convert the required formats in Excel, Please Give me a chance Project Requirements Dear Employer, I will work any formula, function, calculation, modification, automation Daha Fazla

$250 USD in 3 gün içinde
(214 Değerlendirme)
7.9
sy3d

Bid Summary please check my profile, i've no incomplete project and no bad words for my work Project Requirements data is in excel, and i am good in excel and convert data as per your desire on mouseover on person1, w Daha Fazla

$166 USD in 3 gün içinde
(291 Değerlendirme)
7.3
purveshpariya

Bid Summary Hi, I am Professional Android developer. I do have a skill to convert JSON to Any format. Project Requirements I think I will use C# language or may be other if needed to parse JSON format data. Relevant Daha Fazla

$80 USD in 3 gün içinde
(12 Değerlendirme)
4.5
asifkhan268

Hello Greetings Yes I can create a script to convert your Google spreadsheet data into readable format . Thank You

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(15 Değerlendirme)
4.5
sunsoftpro

Bid Summary Hi Employer, I have read your description and been interested in your project. Please share me more detail of the project. Project Requirements Parse the JSON to the easy-to-read format. Relevant Skills a Daha Fazla

$147 USD in 3 gün içinde
(3 Değerlendirme)
4.9
Denisakov

Bid Summary Hello there! Project Requirements If I understand correctly, you don't actually need to see all that data on the spreadsheet and wish to place them in the notes connected to the cell. Unfortunately, it isn Daha Fazla

$225 USD in 3 gün içinde
(1 Yorum)
1.5
VigneshPremseth

Bid Summary I can help to write a function that helps to parse the content for you Project Requirements Json to meaningful content Relevant Skills and Experience I deal with JSON format pretty much on every project t Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
olansile

Bid Summary I have worked on something similar to this before and I would be glad to work on this project for you. Project Requirements I need to convert JSON data in a spreadsheet into a human readable format such as Daha Fazla

$244 USD in 3 gün içinde
(0 Değerlendirme)
0.0
cheskasawal

i am very good in excel and can work full time and start at your proj asap. thanks

$111 USD in 10 gün içinde
(0 Değerlendirme)
0.0
mobeenzeeshan

no problem with popup thing.. ☺

$166 USD in 4 gün içinde
(0 Değerlendirme)
0.0
rakde055

Bid Summary Good Day to you, I am very much interested to work as a typing and data entry work for your operation. Project Requirements Adequate Computer knowledge in MS word, Excel Won Computer or Laptop with Intern Daha Fazla

$222 USD in 3 gün içinde
(0 Değerlendirme)
0.0
daniels39

A proposal has not yet been provided

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
smazaky

Hi, I would like to help. I've done a lot of jobs like that. Do you need to this just once (for one specific spreadsheet) or do you need a code or a method to run multiple times?

$100 USD in 3 gün içinde
(0 Değerlendirme)
0.0
Gunnahar

A proposal has not yet been provided

$155 USD in 3 gün içinde
(0 Değerlendirme)
0.0
Pdsekar

A proposal has not yet been provided

$100 USD in 2 gün içinde
(0 Değerlendirme)
0.0
udhayaviyaas

A proposal has not yet been provided

$200 USD in 2 gün içinde
(0 Değerlendirme)
0.0
shreewansht

I have knowledge about Excel VBs and also develop my own excel data entry and printing software.

$150 USD in 2 gün içinde
(0 Değerlendirme)
0.0
bantwad

A proposal has not yet been provided

$166 USD in 5 gün içinde
(0 Değerlendirme)
0.0