How to Convert JSON to Excel, CSV and Google Sheets - Google Colab

Learn how to open a JSON file in Excel , import in Google Sheets or convert to a CSV file using Google Colab.

#josn #excel #csv #googlesheets

[shaikan]

Best channel there is on Google Sheets. In depth and consise explanations on all sorts of challenges one faces with Google Sheets.

[desireema]

This is an amazing video that simplifies jason to spreadsheet conversion. All that you need is a little experience with Python. I spent 4 hours watching other videos on the built in conversion in Excel and it never worked. I downloaded my google location data for the last year, in order to report my mileage for tax purposes. The IRS would have laughed at me if I gave them a bunch of JSON. Thank you.

[pollystraub-cook]

My MANNNN!!! You saved me 9 ZILLION hours! You win ALL THE THINGS!!! Well at least you won a subscribe and a like from me. Holy smoke, you are my favorite person this year.

[piushdengani]

This the best explanation I found on YouTube. Thank you!

[willykitheka]

It would be a travesty of justice if I went away, having gleaned the information you have shared, WITHOUT SAYING, THANK YOU! Man, thanks for sharing....you just have no idea!😁😁😁😁😁😁😁😁😁😁😁😁😁😁😁😁😁😁😁😁😁😁😁😁

[tairmoalam]

Extremely helpful. Worked on the first try. I tried another video by someone else and it was confusing and did not end up working. Thank you for being so clear!!

[missASe]

Thanks a lot for this great great video.

[aayushmittal]

What all changes can i make (code) in my json file to convert it into csv rather than using this colab feature. Is there a video or something that can tell me which all objects and line of code do i have to add to get the desired result. It will be very helpful if you address my question. Thank you!!

[christiantinman]

Great video, Do you know if this will work with a live Json file? Im getting Json data from a scoring app that keeps updating and need to pull that info into an xcel sheet but need it to keep updating the live info

[ignallacay]

Great video, thanks!
Very clear even for a first-timer in python like me. Is there a way to import the csv to google sheets without the index column?
Tried using the df.drop method but it isn't working.

[h.j.]

Hi, my json data has so many levels. It shows up as having only one column when I import it. What do I do?

[davidfernandezbajo]

Great! Is there a way of accomplishing the same with apps script?

[luiscontreras]

Thanks! is posible merge four or more .JSON files ? and next convert to a one google sheet file?

[Puner]

Teacher...I got it! 🙌 I got the Formula for the C4:C15 Range to Work the way I wanted. So, here is what I have so far:
Formula Cell: B4 Range: B4:B15 =ARRAYFORMULA(IF((A2:A13)="", ""(A4:A15)-OFFSET(A4:A15, -2, 0)))
Note: I get 'N/A' if A2:A13 is 15

Formula Cell: C4 Range: C4:C15
=IF(ISEVEN(ROW(C4)), A4-A$2, A4-A$3)

Now all I have to do is figure out how to make it all Dynamic without any ERRORS or N/A's. 🤔
Nothing I do seems to play well with Column 'A' being 14 Rows and Columns 'B' & 'C' 6th 12 Rows!?!?

[mamunrashid]

Great video, thank you. I wrote same code, unfortunately didn't work for me!

[gracemusungu]

how do i save my json file from Mozilla fox in that format. mine keeps failing

[McKaySavage]

Great video for the conversion and Python learning. Is there any way though to automate the process so a JSON file stored in Google Drive (without it being made publicly accessible!) can be converted, re-stored in Google Drive and imported into Sheets. What I need is a system where I can over-write an existing file with a new version from time to time, and ideally have the new data automatically imported into a Sheet, or at the most, running a script like this once each time without needing to load files, export files, then import files each time just to get a refresh.

Possible?

[rabbitwang]

Excellent video !!! Any chance you could share the source files or raw data for us to study and practice in the future? many thanks

[carloscanofernandez]

It is not working this message appears after following exactly your tutorial NameError Traceback (most recent call last)

[ScreenPrintR]

I'm sorry, is Pandas your business? Thank you for the video.