# ✨ Spreadsheets and Editable Tables in AI-generated Apps with Plotly Studio

**URL:** <https://community.plotly.com/t/spreadsheets-and-editable-tables-in-ai-generated-apps-with-plotly-studio/93595>\
**Category:** Plotly Studio\
**Tags:** show-and-tell, tips-and-tricks\
**Created:** [August 6, 2025, 10:16pm UTC](https://community.plotly.com/t/spreadsheets-and-editable-tables-in-ai-generated-apps-with-plotly-studio/93595 "2025-08-06T22:16:00Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![chriddyp](https://sea2.discourse-cdn.com/flex024/user_avatar/community.plotly.com/chriddyp/32/16855_2.png) [@chriddyp](https://community.plotly.com/u/chriddyp)\
**Post date:** [August 6, 2025, 10:16pm UTC](https://community.plotly.com/t/spreadsheets-and-editable-tables-in-ai-generated-apps-with-plotly-studio/93595/1 "2025-08-06T22:16:00Z")

</div>

Plotly Studio generates Python code that uses Dash components, including editable tables! This means you can generate simulation apps that have editable tables akin to a spreadsheet.

Here’s an example I just made shows the performance of 3 different stock portfolios and you can edit the portfolios directly in the table:

 ![image](https://us1.discourse-cdn.com/flex024/uploads/plot/original/3X/f/5/f5aff0bcb77a5d6a9bb61a543c96dadfae5485bb.jpeg)

Full prompt:

> Editable, compact (short rows) ag grid table to create 3 portfolios (ticker, percentage of portfolio 1, portfolio 2, portfolio 3). Include 10 tickers (10% each for first portfolio, and then different ones for 2nd & 3rd) by default in table. Make table 500px tall, use column names P1, P2, P3 and set column width to 40px. Include a “submit button” below table that updates the charts with the portfolios in the table. Do popular UK stocks by default.  
> Then, display two charts on the right that are very short (200px)
> 
> 1. Historical returns of the 3 portfolios from the table as separate lines
> 2. Monte Carlo Value at Risk calculator as a histogram showing P&L distribution for the 3 portfolios from table with rich hover data and risk metrics. Stagger annotations vertically.
> 
> Don’t display any other parameters.  
> Show in the chart hover data the portfolio composition.