# Import and Export JSON
## Content
You can import data from or export data to a JSON object using the [fromJSON method](/spreadjs/api/v19/classes/GC.Spread.Sheets.Workbook#fromJSON) and [toJSON method](/spreadjs/api/v19/classes/GC.Spread.Sheets.Workbook#toJSON).
While importing data from a JSON object, you can set several deserialization options for custom data import. These options include `ignoreStyle`**,** `ignoreFormula`**,** `frozenColumnsAsRowHeaders`**,** `frozenRowsAsColumnHeaders` and `doNotRecalculateAfterLoad`.
While exporting data to a JSON object, you can set several serialization options for exporting custom data. These options include `includeBindingSource`, `ignoreStyle`, `ignoreFormula`, `saveAsView`, `rowHeadersAsFrozenColumns`, `columnHeadersAsFrozenRows`, `includeAutoMergedCells`, `saveR1C1Formula`, and `saveExternalSourcePivotCache`.
>type=note
> **Note:** Earlier versions of SpreadJS cannot load JSON files created with SpreadJS 3.20142.11 or later.
## Exporting to and Importing from a JSON Object
The following code sample shows how to export to and import from a JSON object.
```javascript
workbook.fromJSON(jsonData, {
ignoreFormula: true,
ignoreStyle: true,
frozenColumnsAsRowHeaders: false,
frozenRowsAsColumnHeaders: false,
doNotRecalculateAfterLoad: true
});
workbook.toJSON({
includeBindingSource: true,
ignoreFormula: true,
ignoreStyle: true,
saveAsView: true,
rowHeadersAsFrozenColumns: true,
columnHeadersAsFrozenRows: true,
includeAutoMergedCells: true,
saveR1C1Formula: true,
saveExternalSourcePivotCache: true
});
```
## Save PivotCache Data for External Pivot Sources
When a PivotTable is created from an external Pivot source, such as a DataManager Table or View, JSON and SJS save operations preserve the Pivot source relationship so the PivotTable can reconnect to the source for future refresh.
Use the `saveExternalSourcePivotCache` option to control whether materialized PivotCache data for external Pivot sources is saved.
* When `saveExternalSourcePivotCache` is set to `true`, the saved JSON or SJS file includes the materialized PivotCache records for external-source PivotTables. After reopening the file, the PivotTable can be restored from the saved cache data and can continue to use the saved Pivot source relationship for future refresh.
* When `saveExternalSourcePivotCache` is set to `false`, the saved JSON or SJS file preserves the Pivot source relationship but omits the materialized external-source PivotCache records. This can reduce file size, but the PivotCache must be rebuilt from the DataManager Table or View after the DataManager data becomes available.
```javascript
workbook.toJSON({
includeBindingSource: true,
saveExternalSourcePivotCache: true
});
```
The `saveExternalSourcePivotCache` option is a workbook save or export option. It is not a PivotTable source property and does not change the PivotTable source.
>type=note
> The default value of `saveExternalSourcePivotCache` needs confirmation.
## Loading an ssjson File
The following sample loads an ssjson file.
```HTML
TestLoad ssjson