Can you convert a JSON file to Excel?

How do I convert a file to CSV on a Mac?

I have a bunch of very large files, ranging from ~100k to a few 100MB.

I can open them using TextEdit on the Mac (10.7.5). But I'd like to convert these files to csv, but I don't know how to do this on the Mac.

The simplest way to convert a file to CSV is to use the standard 'save as' function in Mac OS X. This will give you an option to save as 'CSV', which will automatically create a .csv file for you, with one row per line.

If you prefer a bit more control over the output you can find help with this question: How to save a file in .

How do I convert JSON to CSV in Excel?

I have a JSON string I would like to import into Excel as a CSV or something similar so that I can add it to a data table.

It's quite a big string, so it'd be nice if the file could be small when opened in Excel.

Thanks! Just open a JSON file from your hard drive and it should show up in Data. EDIT: You could also use a Google Drive as a server with the Google Sheets API. For me, this worked like a charm (for Mac): Open cmd and navigate to where you downloaded JSONofwhatever.json curl -s -H "Accept: application/json" -H "Content-type: application/json". Python json2csv.py yourfile.json # <-- use whatever python library you want
Then open Excel and choose File -> From Web.

Can you convert a JSON file to Excel?

In this answer, I'll show you how to use the Google Data Tools and a spreadsheet formula (in Excel, of course) to convert JSON to CSV (using a JSON file as the input) and back again. For this I used Excel version 365.

As input, I used the JSON file of your choice. You can download it for free, here. But you don't need to do that. If you create a new Google Sheet, you get a copy of the JSON file by default.

If you open up that copy of your chosen JSON file and scroll down to the bottom of the list (as in the screenshot below), you will see a link that says View as Text. Click that link, then select CSV and the output will automatically come from the sheet. For ease of explaining how to do this, I'll call the input that is used the input file. First thing is to get Excel going. It's possible to do this quickly, but I'm lazy. And you should be too.

Get Excel going. I'm using Excel 365 but you can do this in any version up to Excel 2024. Make sure that you have Data Tools installed as a separate program (rather than part of Excel, which is also free).

Create a new Excel workbook and select Data > From Other Sources > Import Data from File. Select Csv or from a URL from the Location drop-down box at the top right of the screen. Paste in the URL for the JSON file you wish to use. Select OK. This may take a while, depending on the size of your JSON file.

Open up the CSV file in the resulting workbook (or whatever spreadsheet you use). You will see that all the data is in separate rows.

For now, it doesn't matter what you name your columns or what you name them. I'll use the first column as my variable (what we'll be extracting from the JSON in the next step).

Convert the JSON to CSV. Next, you're going to convert your JSON file into a CSV file. The data will be in a format that can be easily imported into Excel.