AI for Excel

Your Excel spreadsheet, made by AI

Columns, formulas and formatting, in a real .xlsx file; Roona also works inside your Excel sheet.

14-day free trial, no credit card, then a subscription at €20 excl. VAT per month.

See the demo
  • A real .xlsx file
  • Formulas included
  • 14-day trial, no card
  • Then €20 excl. VAT a month

A tracking spreadsheet always starts the same way: you know what you want to see, you do not know where to begin, and the blank grid does not help. RoonaWorks is an AI Excel spreadsheet generator: you describe what you want to track, it builds the complete .xlsx file, named columns, formulas in place, formatting applied, and a chart if your figures deserve one. If you would rather stay in your workbook, the same tool installs as a panel on the right of Excel: you select a range, you ask, and the range fills in. A formula you do not know how to write, Roona writes it; a formula you do not understand, it explains it.

What it actually looks like

You ask: A twelve-month cash flow: money in, money out, opening and closing balance.

Roona delivers: Twelve month columns, one row per item, the closing balance becoming the opening balance of the next month, amounts in euros, and an alert row when the balance goes below zero. You open the .xlsx, you replace the figures, everything recalculates.

You ask: A price list for my services, with the price excluding VAT, the VAT and the price including VAT.

Roona delivers: One row per service, the inclusive column calculated from the exclusive price and the rate you give, the rate editable in a single cell, and the formatting ready to print or send.

You ask: A site schedule by trade: start, end, duration, company, progress.

Roona delivers: One row per trade, the duration calculated between the two dates, the dates in your local format, progress as a percentage with a colour that changes at 100 %, and the total duration at the bottom.

You ask: A log of this month’s call-outs: client, date, engineer, duration, status.

Roona delivers: One row per call-out, a drop-down for the status (scheduled, done, to redo), the hours totalled per engineer at the bottom, and columns wide enough to read without resizing anything.

You ask: Here are my sales for the year, unsorted. Turn them into a clean table by month and by product.

Roona delivers: Your rows arranged by month and by product, a total per month and per product, and a summary sheet that sums the year up in ten lines.

You ask: An attendance sheet for the workshop, over four weeks, with the hours totalled per person.

Roona delivers: One column per day, one row per person, the weekends greyed out, the hours totalled per person and per week, and a column for notes.

Expense tracker

Date, supplier, category, net amount, VAT, total: the table is ready to fill in. The total column is calculated by formula from the net amount, amounts display in your currency to two decimal places, and a total row adds everything up with SUM.

Project schedule

One row per work package, with start date, end date, duration and progress. The duration is calculated by formula from the two dates, dates display in your local format, and the header row is coloured so you can find your way around.

Cash flow spreadsheet

Money in, money out, end of month balance: the balance carries over from one month to the next by formula, and a chart shows how the balance moves over the year.

Price list

Reference, description, net price, VAT rate, gross price. The gross price is a formula that follows the rate on each row, with percentages and currency in the right format.

Data analysis

Drop in a file of raw data, an export from your accounting software or your till: Roona sorts it, cleans it and sums it up in a clear table.

The formula written or explained

In the Excel panel, describe the calculation and Roona writes the formula, SUM, IF or VLOOKUP, in the syntax your Excel expects. Select an existing formula and it explains what it does.

A real Excel file, not text to copy out

You get an .xlsx you can edit in Excel, with its formulas live, and hand to your accountant or your team as it is.

How it works

  1. Describe the Excel spreadsheet you want, or drop your data into the tool
  2. Roona generates the columns, the formulas, the formatting and the chart
  3. Open the .xlsx in Excel, or insert the result into your sheet

Frequently asked questions

Which AI tool creates an Excel spreadsheet from a simple description?

Roona. You write what you want to track, for example “an expense tracker with net amount, VAT and category”, and it generates the complete Excel file, formulas and formatting included.

Is it a real Excel file?

Yes, an .xlsx you open in Excel, with columns, live formulas and formatting already in place.

Can Roona write an Excel formula for me?

Yes. Describe the calculation, in the Excel panel or in Roona, and it writes the formula in the syntax your Excel expects: SUM, IF, VLOOKUP.

Can I work directly in my spreadsheet?

Yes. The Roona add-in opens as a panel on the right of Excel, on Windows, Mac or Excel online. You select a range, you ask, and the result is written into the sheet once you approve it.

Can Roona analyse my data?

Yes, drop in a file or select a range: Roona sorts, cleans and summarises the data.

Does Roona add charts?

Yes, a chart suited to your figures is added when it helps read the table, and you can ask for a different one.

Is my data private?

Yes, hosted in Europe, under GDPR, never used to train the AI.

Also worth a look

Create an Excel spreadsheet