A few days back, I noticed a problem with converting JSON into an Excel sheet. Basically, the data is in MongoDB but to analyze the data for a person who doesn’t know how to write queries like business analysts or any person who isn’t familiar with databases but is good with spreadsheets needs all the data in excel format. So, I built a simple tool that can take in the JSON data and convert it into table format. I am still working on the part of exporting it. With programming, you can solve real-world problems. That’s what many startups are doing. Understanding the customer first and then iterating the product is always a good idea.
Continued:February 28, 2022
I am writing this after several days of completion of this project. I have tweaked it a little bit by adding some more styles so that it looks a little bit professional. This tool is completely deployed and can be used by anyone who is in need. It may only convert JSON data to table format which can then be extracted to a excel sheet.
link to the tool -> Converting Tool