Completed

Merge two JSON files into Excel insert modify and then write back to JSON files

Hello all,

I am currently trying to merge two JSON files with VBA and then write them into a data set in Excel. This data set should then be able to be changed and then these changes should be applied. Afterwards everything should be written back into the two original files (Json) with all changes.

Difficulties:

One of the JSON files ("user") is tabular and would have to be correctly aggregated (restructured) before being read in order to combine the matching primary key in the other JSON file.

Can anyone help me here? Do I first have to loop into the JSON file ("user") to restructure it before the import?

Thanks a lot

Marco

Skills: Excel, Visual Basic, Visual Basic for Apps, JSON, API

About the Employer:
( 0 reviews ) Munich, Germany

Project ID: #32662281

Awarded to:

rohitagarberg

hi there, i am expert in vba and in json processing, will process the two files in json, will restructure the first file before merging with second, ready to start now and will be online until done, thanks

€100 EUR in 1 day
(415 Reviews)
6.7

26 freelancers are bidding on average €90 for this job

(849 Reviews)
9.0
(463 Reviews)
8.3
(259 Reviews)
8.0
(64 Reviews)
6.9
VladimirLilenko

Hello! I'm a Excel and VBA expert more than eight years. I have completed many complex projects in my practice and I am ready to carry out your project in the reasonable price and in the shortest possible time and with More

€65 EUR in 2 days
(187 Reviews)
6.8
(461 Reviews)
6.7
(176 Reviews)
6.4
(128 Reviews)
6.1
(20 Reviews)
6.1
hussainmuzammal4

I am currently trying to merge two JSON files with VBA and then write them into a data set in Excel. This data set should then be able to be changed and then these changes should be applied. Afterwards everything shoul More

€120 EUR in 4 days
(18 Reviews)
5.3
hayteekeys

Hello. From your job description I have learned that the requirements you have asked for are possessed by me very well. I am a graduate of computer science. Also, I have several good records in this field as I have be More

€100 EUR in 2 days
(16 Reviews)
4.6
(11 Reviews)
4.0
(3 Reviews)
3.0
andylawsonstatz

Hello, sir! I have read your requirement and I noticed that I am appropriate to this project. I have rich experience with json data processing using Excel VBA. All clients call me "Prince of Excel". I promise I will fi More

€50 EUR in 1 day
(3 Reviews)
1.7
sharikmp

Hi Dear I've good expertise in handling json and excel. I can quickly help with this. Let me know if you wish to see demo. Thanks Sharik

€50 EUR in 1 day
(2 Reviews)
1.8
yinshu2020

----------------Professional JSON & Excel Expert! Best Result in Time!----------- Dear sir. I've read your project description very carefully. I've extensive experience in , so I believe that I can provide excellent re More

€200 EUR in 7 days
(0 Reviews)
0.0
swpnljn1996

First have a query, this data extraction - is it supposed to be done using VBA or I can use other programming languages? Second, I am a veteran in software industry but as a freelancer, this will be my first project. More

€70 EUR in 1 day
(0 Reviews)
0.0
AndreiBird

Dear Employer, I'm ready to work on json files merging project. I have strong experience in Visual Basic, Excel, Visual Basic for Apps, JSON, API. Please message me to have the whole idea about your project. Will wait More

€120 EUR in 2 days
(0 Reviews)
0.0
EngAmr93

Hello Sir/Madam, I wish you a good day/night. I can import the JSON files into MS excel, joining them and converting to JSON format again. I need more details like: - Whether it is a merge (horizontal merge) or an appe More

€65 EUR in 1 day
(0 Reviews)
0.0
arslanmajeed0786

Hello Sir i am expert of VBA Macro sheet .. I read your all instruction and I will cooperate with you and accept your work. Don't worry i will take very short time and will give 100 % perfect work.. Now you can believe More

€30 EUR in 1 day
(1 Review)
0.0