# Convert formulas into values using jupyterlab-spreadsheet-editor

**URL:** <https://discourse.jupyter.org/t/convert-formulas-into-values-using-jupyterlab-spreadsheet-editor/30704>\
**Category:** extensions\
**Created:** [December 5, 2024, 4:12pm UTC](https://discourse.jupyter.org/t/convert-formulas-into-values-using-jupyterlab-spreadsheet-editor/30704 "2024-12-05T16:12:53Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![dimassuarez](https://yyz1.discourse-cdn.com/flex031/user_avatar/discourse.jupyter.org/dimassuarez/32/16230_2.png) [@dimassuarez](https://discourse.jupyter.org/u/dimassuarez)\
**Post date:** [December 5, 2024, 4:12pm UTC](https://discourse.jupyter.org/t/convert-formulas-into-values-using-jupyterlab-spreadsheet-editor/30704/1 "2024-12-05T16:12:53Z")

</div>

Hello,

I find that the jupyterlab-spreadsheet-editor extension can be very useful, but I do not know how to convert formulas into values.

For example, I can enter a formula and get the results as shown below, but when I save and reopen the .csv file or paste cells into a MD cell, I get the formulas, not the values:

 ![imagen](https://canada1.discourse-cdn.com/flex031/uploads/jupyter/original/3X/1/f/1fb48407305b3d2bee0e25ae17d688b0a47d79bc.png)

How can I convert the formulas into numerical values so that I can copy or export the results ?

Thanks so much !

Dimas

---

<div class="post-metadata">

**Author:** ![fomightez](https://yyz1.discourse-cdn.com/flex031/user_avatar/discourse.jupyter.org/fomightez/32/495_2.png) [@fomightez](https://discourse.jupyter.org/u/fomightez)\
**Post date:** [December 5, 2024, 7:19pm UTC](https://discourse.jupyter.org/t/convert-formulas-into-values-using-jupyterlab-spreadsheet-editor/30704/2 "2024-12-05T19:19:37Z")

</div>

If there isn’t an easier way to select the values, you can use the HTML representation of the table to convert it to values, or even a CSV, with some Python.

In a Jupyter notebook [here](https://nbviewer.org/gist/fomightez/bd1b7aa6130c6a527684c5557b99b53e), I spell out the steps using the example for rendering formulas from the documentation.

---

<div class="post-metadata">

**Author:** ![krassowski](https://yyz1.discourse-cdn.com/flex031/user_avatar/discourse.jupyter.org/krassowski/32/1685_2.png) [@krassowski](https://discourse.jupyter.org/u/krassowski)\
**Post date:** [December 5, 2024, 9:12pm UTC](https://discourse.jupyter.org/t/convert-formulas-into-values-using-jupyterlab-spreadsheet-editor/30704/3 "2024-12-05T21:12:01Z")

</div>

> [@dimassuarez](#):
>
> I find that the jupyterlab-spreadsheet-editor extension can be very useful,

Thank you it’s nice to hear!

> but I do not know how to convert formulas into values.

If you could open an issue on [GitHub - jupyterlab-contrib/jupyterlab-spreadsheet-editor: JupyterLab spreadsheet editor for tabular data (e.g. csv, tsv)](https://github.com/jupyterlab-contrib/jupyterlab-spreadsheet-editor) I can look at what would be needed; we could probably add a button on the toolbar that converts formulas into values easily.