How to extract data from JSON

With Lemonado, you can extract variables from source data containing JSON strings. Use Lemonado's JSON extracter to select the data you want and create a new column.No matter how many arrays your JSON contains.

Step-by-step guide to extracting data

Getting data out of a JSON object can be a nightmare. Here is a step by step guide how to do it with Lemonado.

Start by going to your data source, click edit data and then create computed column. Then select the values you want to extract. Once you are done, click beside the window.


How to extract and save arrays


Extract a value, and then make a calculation


Work with your extracted data