In this video we are going to see how to convert JSON data into Excel columns. Once you have verified your data, you will see that the results column has a JSON format.

We offer the validation data in JSON format to give greater freedom in its exploitation either by using tools such as Excel or via programming.

We are going to see a concrete case where we convert JSON data into Excel columns using the postal address verification, where we will only use 2 fields of the JSON to convert them into columns. This same method can be applied to other data verified with APIs such as phone numbers, first and last names or telephones.

There are other methods to perform this transformation using Pyton, Google Sheets… Work with the one you feel most comfortable with, the result will be the same.