Build a dashboard from your Excel files – Step-by-Step Guide | Vibe96
Vibe Studio

Build a dashboard from your Excel files

Published Last updated 2 min readBy Vibe96 team

Short answerAttach one or more Excel workbooks or CSV files and ask for a dashboard. Nova reads every sheet, loads every row into the app's database and builds the figures, charts and filters on your real data.

Your numbers live in spreadsheets. Turn them into an app your team can open on any screen.

What Nova reads

Attach your workbooks and Nova reads every sheet:

  • what each column holds,
  • the date ranges,
  • the totals,
  • how the sheets link to each other.

Large CSV files are understood as a whole.

Steps

  1. Start a project, or open one, and go to Nova's chat.
  2. Press Attach and add your Excel (.xlsx) or CSV files. You can also add them on the new-project page.
  3. Say what you want to see. For example: "A sales dashboard by month and by branch, with a filter for product group."
  4. Check the tasks Nova writes and tick the ones you want.
  5. Press Develop.

What you get

The app is built on your real data. Every row is loaded into the app's database, and every figure, chart and filter is worked out from it. Nothing is typed in by hand as a sample.

Apps built this way come with a Data screen. Upload a newer file there to refresh the numbers. No new build is needed for new data in the same shape.

๐Ÿ’ก Tidy your sheet first: one header row, one kind of value in each column, real dates in date columns. Clean data gives clear charts.

Good questions to ask for

  • "Show the top 10 customers by revenue this year."
  • "Compare this month with the same month last year."
  • "Add a page for late deliveries, with the driver and the reason."
  • "Let managers see only their own branch."

Keep your data safe

  • Add sign-in so only your team can open the dashboard.
  • Remove columns you do not need before you upload, such as personal details.
  • Your test link is hidden from search engines, but anyone with the address can open an app that has no sign-in.

Go further

Ask for scheduled reports by email, a CSV or Excel export, or phone apps for managers. Add these as new tasks after the first build is on your test link.

Check the first numbers

Pick one figure you know by heart, such as last month's total, and compare it with the dashboard. If it differs, tell Nova which sheet and column it should come from. One checked figure builds trust in all the others.

๐Ÿ’ก Start with one workbook and three charts. Look at the result, then ask for the next ones. It is cheaper than a big plan you later change.

For the build itself, see Build your first app.

Questions

Can I update the numbers later?

Yes. Open the Data screen in your app and upload a newer file.

Does it work with CSV files?

Yes. Excel workbooks and CSV files both work, and you can attach more than one.

Is my data used as sample data only?

No. Every row is loaded into the app's database and the figures are worked out from it.

Was this guide helpful?