Your First Dashboard
Learn how to create an interactive dashboard from an Excel file in just minutes
With Squadbase, you can transform your Excel files into interactive dashboards in just minutes. This guide walks you through creating your first dashboard and sharing it with your team—no prior experience required.
Time Required
About 15 minutes
What You'll Need
- A Squadbase account (free to sign up)
- An Excel file you want to analyze (.xlsx, .xls, or .csv format)
Don't have an Excel file handy? Download our sample file to follow along.
Create a New Project
- Log in to Squadbase and navigate to your Space > Projects, then click "Create Project"
- Select Excel from the data source options and upload your file
- Enter a project name (optional) and additional context about your data
- The additional context helps the AI understand your data better
- Example for the sample file: "This dataset contains 1,999 daily sales records organized by date, region, and product category. It includes sales metrics like revenue, quantity, and unit price, plus marketing data such as ad spend and promotion status."
- Click "Create Project" to proceed
Let AI Analyze Your Data
- Once the project is created, AI will begin analyzing your data
- The AI may ask clarifying questions (e.g., how to handle empty fields)—make your selections and click Submit
- After reviewing your data, the AI will suggest next steps. Choose the action you'd like to take

- Select a step to execute the task. If you choose to create a dashboard, you'll see something like this:

Refine Your Dashboard
The AI-generated dashboard can be refined through continued conversation—iterate as many times as you need.
Example refinements:
Change the chart colors to blue tonesSet the title to "2026 Sales Summary"Add a filter for month and yearYou can also add entirely new dashboards. Click "Create AI Suggestion" from the thread list, and the AI will analyze your current data structure and dashboards to suggest new visualizations.

Share with Your Team
Once your dashboard is ready, share it with your team members.
- Click the "Publish to Team" button in the top right corner
- In the chat, AI will prepare the app for publication (checking for any issues)
- Click Publish changes to start deployment. You can monitor progress from the deployment view

- When deployment completes, access your app via "Open App" on the Project detail page

Viewing is free! Squadbase viewer licenses are free by default. Share dashboards with your entire team and foster data-driven decision making across your organization.
Troubleshooting
File Upload Fails
- Check if the file size is too large
- Verify the file format is supported (.xlsx, .xls, .csv)
- Make sure the file isn't corrupted by trying to open it in another application
AI Doesn't Understand My Request
- Enable Element Selection Mode in the top right of the preview to give AI instructions for specific components. This is useful when you want to change only a particular element

- Try being more specific (e.g., instead of "make a chart", say "show monthly sales as a bar chart")
- Break complex requests into smaller, sequential steps