DEV Community

Andrea D'Attero
Andrea D'Attero

Posted on

I Built GridScript: A New Way to Transform Excel Data with JavaScript and Python

TL;DR

GridScript.io lets you open Excel/CSV files, run JavaScript or Python scripts to transform the data, and export the result — all in your browser.

No backend. No install. Instant feedback.

A simple Gridscript pipeline

Why I Built It

Developers constantly bounce between spreadsheets and code when working with data — cleaning CSVs, merging reports, converting formats.

I wanted a way to stay inside the browser and use the languages I already know (JavaScript and Python) to transform and visualize data.

That idea became Gridscript.io.

But it's also more than that, Gridscript offers access to Tensorflow.js and Scikt-learn allowing engineers to directly build AI/ML models.

Tech Stack

  • Next.js – fast frontend framework
  • AG Grid – Excel-like grid for editing and filtering
  • Monaco Editor – same editor used in VS Code
  • Client-side architecture – no data leaves your browser
  • Undo/Redo system – safe experimentation

Example Workflow

  • Create a New Pipeline
  • Upload an Excel, JSON or CSV file
  • Write a few lines of code in JS or Python
  • Instantly see the grid update
  • Export the result
context.data = context.data.filter(row => row.quantity > 10);
context.data.forEach(row => row.price = `\$${row.price.toFixed(2)}`);
Enter fullscreen mode Exit fullscreen mode

Why Both Languages?

I didn’t want to force users into one ecosystem.
Web devs love JS; analysts live in Python.
Both deserve the same smooth experience.

GridScript makes that possible with a unified scripting interface.

Privacy by Design

Everything happens client-side — no data upload, no server storage.
Perfect for sensitive business files.

Try It Yourself 👉 gridscript.io

If you work with data, this tool might save you hours every week.

And by the way, we care about our users you can find documentation here: Docs check it out!

Top comments (0)