0

I have a doubt how to JSON structure maintain in excel sheet. I tried to JSON data convert to excel sheet using an online tool. I got the excel sheet. but JSON object structure not in the excel sheet. can give some suggestion node js code used to convert json data to excel data.

JSON DATA

{
product_name:bourbon,
product_image:
{
image1:image 
image2:image
}
}

I tried to convert JSON to Excel using an online tool
There are two columns product_name showing bourbon but product_image showing the only value key is not showing how to fix it. product_name ------ product_image
bourbon image
image

Improve this question
1
  • I have another doubt this excel sheet I will use to convert JSON format. that JSON format same as my input JSON format. Commented Aug 26, 2019 at 2:42

2 Answers 2

Reset to default
1

If you want output like this

product_name    product_image__image1   product_image__image2
bourbon .       image                   image

Then you can use this.

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

0

Step 1 – Login to the GST Portal

Step 2 – Go to ‘Services’ > ‘Returns’ > ‘Returns Dashboard’

2]

Step 3 – Select the ‘Financial Year’ and ‘Return Filing Period’ from the drop-down

3]

Step 4 – Click on ‘DOWNLOAD’ button under GSTR 2A.

4]

Step 5 – Click on ‘GENERATE FILE’ and download the JSON file.

5]

Step 6 – Upload the JSON file and convert it to Excel format using a JSON to Excel converter available online.

Improve this answer

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.