# Parse JSON Fields

If your dataset has a field that contains data in a JSON format, you can parse that field to display the specific pieces of data you want in new columns. You can do this by creating a new custom field and then passing it a value that references the JSON field.&#x20;

Let's explain this more in-depth by using the following example.

Suppose you have a field that has JSON data like the following:

```javascript
{
  "fields": {
    "pricing": {
      "integerValue": "109"
    },
    "quantity": {
      "integerValue": "98"
    }
  }
}
```

Without changing anything, it will be displayed like this:

<figure><img src="https://3448227606-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LQ08RFAKZvFADEiXKFy%2Fuploads%2F6xaF8dWaKPRWfwH2e5FH%2F%D0%A1%D0%BD%D0%B8%D0%BC%D0%BE%D0%BA%20%D1%8D%D0%BA%D1%80%D0%B0%D0%BD%D0%B0%202023-03-16%20%D0%B2%2010.23.31.png?alt=media&#x26;token=ae3316b7-b116-46de-98c4-2923fb32130d" alt=""><figcaption></figcaption></figure>

#### To parse this data and make it more readable, follow these steps:

1. Edit the data type for the field with your JSON data. It will be *Text* by default; change it to JSON.\
   Here you can also change how the data in this column is displayed within this field – as either text or as fields.

<figure><img src="https://3448227606-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LQ08RFAKZvFADEiXKFy%2Fuploads%2FKKZtdKeCSiI2MnPn18hn%2FUntitled%20(1).gif?alt=media&#x26;token=be52afd2-3d50-44fe-94a9-8f7508b7d1c3" alt=""><figcaption></figcaption></figure>

2. Create a new Computed Field with the data you want
   1. Click *Add computed column* in the table menu on the right
   2. Pass the correct value to your field:\
      \- Click the *ƒx Formula* button\
      \- Choose the field from your table that has your JSON data\
      \- Choose the JSON field and value that you need
   3. Give your column an appropriate name
   4. Adjust the data type for your field as necessary

<figure><img src="https://3448227606-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LQ08RFAKZvFADEiXKFy%2Fuploads%2FTKptIs8gQpZCSt23a5vR%2FUntitled%20(2).gif?alt=media&#x26;token=b6bc075c-9cff-48c5-94c5-f2022f318608" alt=""><figcaption></figcaption></figure>

3. (Optional) Hide the field with the JSON data by clicking on the slider next to the field name in the Table menu

<figure><img src="https://3448227606-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LQ08RFAKZvFADEiXKFy%2Fuploads%2FHCxy7vswgG6buHsKrsKe%2FUntitled%20(3).gif?alt=media&#x26;token=ad6f5548-ab56-46cc-92bc-c1a758d31b11" alt=""><figcaption></figcaption></figure>
