I've got a huge json file that I'd like to convert to excel. What's the cleanest way to do this? Do I need to run some Python?

like
Posting as :
works at
You are currently posting as works at

Lol, within the data tab, you can just insert data from a JSON file and then manipulate it how you wish using power query.

like

Some options, and the one caveat is if the file contains nested arrays:

- Use a web JSON to Excel converter (easiest, security risk)

- Write simple Python script to import JSON, export CSV (simple, if you know how)

- Use Excel Power Query (more work, but better if data is complicated)

like

Hopefully the number of rows isn’t above the the limit excel can handle otherwise your data will be incomplete so be on the lookout for that

Related Posts

Hi Fishes... I have cleared interview with Wipro and while uploading the documents i uploade document but they mentioned LOA & education certificate are incorrect so i re-uploaded them but again they mentioned LOA is incorrect.. so i connected with the person who sent me the link to upload the doc but no help from her.. i tried to open the link today (17th March) evening but the link was not opening... what will be the next step.. how can i upload it again.. Need your valuable advice.. TIA

Does anyone know if this is normal? I joined a vault 100 firm in September last year. The firm put me on tier 7. In January I had the associate review and everything was normal. After a couple of weeks, I got the call from the hiring partner telling my bonus and new salary (because of the firm-wide salary increase). I realized I still get paid as a 7 year associate. The partner said because I joined the firm later in the year, it’s normal not to advance in the next year. Is it? Thanks!

like
like

Any Recruiter here?
Need help

like

Are there any AGENCY folks at small/mid-size shops that are using CDP's? If so, how are you staffing the team and how are you integrating the CDP with your DSP's etc?

like

Best places for takeout in inner loop? I love Local Foods, Aladdin, etc.

like

Obligatory Rosh Hashannah post:
Shannah Tovah to my fellow Jewish consultants!

like

Hi All,
Currently working in S&P Gloabl (Associate Software developer {Tableau})
I am looking for a job change.
I have +6 Month's of experience.
Skills :- Tableau, Python, SQL.

What’s everyone doing today babes 🧐

like

Do senior managers have an employment contract? what is the weeks of pay for separations (severance pay)?

likeuplifting

Would anyone from Centerview be willing to connect briefly? TYIA!

like

LOS- Tax, retain shows no hours booked for the next few weeks. Asked my coach and he responded not enough work to give all associates 50-55 hours...I haven't received warnings- should I be concerned?

How muxh time do the HR take to release the round 2 interview results?
Is it possible to not get the mail if i havnt cleared the round?

like
like

I am having offer from JPMC for UAT POSITION and my current organisation is not ready for early release. Will Jpmc HR agree to extend date of joining

like

Hey fishes need 11 likes help me out

like

What is the next process once accepted offer in pwcindia. I have accepted offer and have my joining in 2 weeks. Have not received any further communication from HR.

like

I am going to speak with a recruiter at Houlihan Lokey TMT in LA. I would like to know more about the group and its culture. Would love to connect and network🙏

like

How is IBM gurgaon for java developer(i have 4 year exp). is IBM gurgaon having good java development project?

like

Additional Posts in Excel Genius

What’s the best way to summarize multiple amortization schedule. I have each schedule on a separate tab. On a master sheet can I do something where I can input a specific month and show my ST/LT ...

like

I am trying to recreate this without the numbers at the end. Any advice?

Post Photo
likehelpful

Anybody have the SQL server data mining add in on excel? Desperately need to run a really quick analysis through it but can’t configure it.

like

Hey guys, I'm trying to find a formula to use instead of the Goal Seek function. Anyone know it? I thought I had seen one years ago, but can't find it now.

like

HELP!
I have raw sales data on one tab, which includes a sales rep ID number. My second tab has that sales rep ID number in column 1 and the rep name in column 2. How can I get the rep name added to the correct line items in the raw data?

Is there an easy way to switch XLOOKUPS to INDEX MATCH? Have a large file with bunch of formulas that don't work on all client machines (different excel versions).

like

Is there a way for me to automate creating columns to do this so I can drag across and create my columns? For example--
1Q2021 2Q2021 3Q2021 4Q2021 2021 1Q2022?

likesmart

Need help building an electric schedule for a production schedule with a Gantt chart style view (sort of)

Currently have an excel list with resource (production line), start date and time, and then also the name of the item being produced.

Any ideas how to tackle this??

I’m thinking a stacked bar chart with the vertical categories to be my resources and horizontal the date/time and then each individual bar to be the name of the item being produced.

Thank you for the help Excel Gods 🙏

like

Would anyone be willing to teach me vlookup?

like

Hey, I have been tasked with teaching some of my coworkers excel from the very basics to more advanced. Does anyone have recommendations on the skills to teach them about? Thank you all in advance!

helpful

Does anyone know any shortcuts for the “Refresh All” button without having to always click Data->Refresh All every time I want to refresh the live data? For a Mac btw pls thanks!

Post Photo
like

EY trying to move away from Excel . Think it’s possible? Want to see it happen?

like

Anybody know if there is a way to automate a Gantt chart in excel when building out a roadmap? Essentially want to recreate the functionality of ms project because my client does not have project and wants a nice visual for the roadmap

like

Will need to migrate to office 365 soon. What’s the difference for excel from the 2013 version?

likehelpful

How can I add multiple characteristics within one cell and make sure that a pivot table can read both values independently if needed? E.g., I have a column titled “color” and in one cell I write “red” and the other “red, blue”. I’d like a pivot table / formula to be able to count that there are technically two “reds” in this data set. Any tips?

like

Hi Group, seems like it should be basic format, but I just can not get it to work. a list of data and want to alternate shade (blue,white,blue,etc) each line but if I have multiple lines I want to group together and they all shade the same. I want to group by the same data in column A, and the number of rows that are the same could vary. So let’s say row 1& 2 same entry in column A(blue) row 3 different (white) row 4,5,6 same as each other different to other rows (blue) etc… help 🙏

like

Current IE here. What are some Time Motion Study Softwares that are out there and you use in your jobs?

like

Is there a way to identify duplicate URLs within labeled hyperlinks on multiple columns/rows/cells?

I was thinking conditional format, but it’s identifying duplicate labels. I have over 80,000 cells, so extracting URLs manually isn’t going to work for me.

Thanks in Advance!

Excel Rookie looking for a super simple formula to bring all information linked to a certain date in tab 1 to be organized under said date in tab 2.

like

I created a macro to help me save time on this onetime task and now whenever I open my excel, a blank excel opens with the name of the macro. How do I get rid of it?

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal