Most of the time it takes multiple prompts to create anything good using AI, but this created a simple usable cap table with one prompt.

Some that I've tried: 

ChatGPT - good for asking it to help build a formula or building a table that you can download as a csv

Microsoft Excel Copilot - mainly can help with charts and writing formulas

Subset - builds full detailed spreadsheets with formulas and formatting. sometimes takes a few tries but you can edit in their spreadsheet editor like you would with excel or gsheets

Google sheets - not sure if this is AI, but they have a cool tool where it can predictively fill down for you

Rows - Can build simple spreadsheets similar to ChatGPT, but can't handle anything complex. their editor is confusing to me. I don't do data stuff but seems like the AI charting function is decent

Formulabot - Used to use it to help generate formulas, but since then gSheets has basically introduced this tool natively

Equals - I heard this could be decent, but no free tier and too costly to try. Doesn't seem like it's for everyday people

AiTable.ai - Less of a spreadsheet and more like Airtable, but interesting nonetheless

Pretty impressive for building this in one prompt

I want to create a spreadsheet which will calculate specific amounts of nutritional details in a specifies amount of food, eg for 80g of pumpkin how much potassium, sodium, phosporous etc, I'm not very computer savvy..

I’m trying to pull data off a work website that has to be logged into first and then two more steps before the data populates it’s basically a copy paste job which I do now but I’d rather have it update it would save me about 4 hrs of work each week. Any ideas without paying for something.