Convert JSON to Excel (.xls/.xlsx)

right-arrow
Start a Free Trial

From Websites and APIs to Spreadsheets

A lot of valuable information is on websites and in web applications that would be useful to analyze in spreadsheet software like Microsoft Excel. Web applications often have APIs that output JSON data. This JSON data can be easily read by FME and transformed for use in Excel.

  • Before: JSON feed containing air quality values for cities around the world.
  • After: Excel file containing all of the values neatly broken out into a table.

JSON to Excel conversion


How to Convert JSON to Excel (Step-by-Step Guide)

Wondering how to pull data from a website into Excel? Check out the following FME tutorial: How to Convert JSON to Microsoft Excel. Learn how to read data from a website with a JSON feed reporting air quality values and then turn that data into an Excel file with the values neatly broken out into a table.

Advanced Options for JSON Data Transformation

JSON data can be unwieldy, especially if you only want to use that data in Excel. FME simplifies your JSON processing by giving you hundreds of transformers to parse, edit, update, and validate JSON data. Use FME transformers like the JSONExtractor, JSONFragmenter, JSONFormatter, and JSONFlattener to do things like map the contents of JSON datasets into their proper columns and rows in Excel. You can also extract only the portions of the JSON that you need converted to Excel. Read the two Getting Started guides below to start your journey!

Getting Started with JSON

JSON to Excel attribute mapping
FME Server 2017

Automate JSON to Excel Conversions

FME is designed to improve your productivity so you can spend more time using your data and less time fighting with it. Once configured in its intuitive graphical user interface, JSON to Excel transformation workflows can run automatically in the background using FME Server. Set up schedules to run your workflow and deliver results to those who need it.

Automate with FME Server

Simple Drag-and-Drop Interface

The FME GUI is intuitive and easy to use. No coding is required! With a variety of transformers to choose from, you can ensure that your new, customized Excel files turn out exactly the way you want them.

KML to CSV TestFilter workspace example

About

JSON

JavaScript Object Notation, or JSON, is an open standard data interchange format that is most commonly used to transmit data between servers and web applications as an alternative to XML.

Learn More

Microsoft Excel

Microsoft Excel is considered to be the industry standard for spreadsheet applications featuring calculation and graphing tools for data analysis and reporting.

Learn More

FME

FME is the data integration platform with the best support for spatial data. Save time by using its drag-and-drop interface to connect data from hundreds of formats and applications, transform data in limitless ways, and automate virtually any data workflow.

Learn More

Try FME Desktop

No credit card necessary. Start integrating data today!