Gridscript

Import & Export

Gridscript allows you to easily bring in data from external sources and export your project in formats that can be shared or reloaded later. You can work with Excel (.xlsx) or the native Gridscript format (.gspj).

Importing Data

You can import data into Gridscript using the Import button in the toolbar. Supported formats include:

  • Excel (.xlsx) – Full Excel workbook import, including multiple sheets.
  • Gridscript (.gspj) – Previously exported projects including grid data, scripts, and history.

Once imported, the data will populate your grid, ready to be transformed, scripted, or visualized.

Exporting Data

You can export your project from Gridscript in the toolbar using the Export button. Options include:

  • Excel (.xlsx) – Export your grid to a standard spreadsheet.
  • Gridscript (.gspj) – Export your grid, including scripts, charts, and optionally the history of changes.

Save / Export History

Gridscript tracks all changes you make to the grid data during your session. When exporting as .gspj or saving locally, you can choose whether to include this history:

  • Include History: Saves every action, transformation, and script execution. Useful for collaboration or auditing changes.
  • Exclude History: Saves only the current state of the grid. Smaller file size, simpler reloading.

This option is available directly in the Save / Export History checkbox in the toolbar. Choosing the appropriate option ensures you keep the level of detail you need for your project.

Best Practices

  • Use .gspj when you want to preserve scripts, charts, and transformation history.
  • Use Excel when sharing with colleagues who do not use Gridscript.
  • Regularly save your project to prevent data loss.

Data Tools

Learn how to manipulate and clean your datasets before export.

Scripting

Learn how to automate transformations and add custom logic to your grid.