How to Create an Excel Worksheet in Power BI: 1-Min Guide

How to Create an Excel Worksheet in Power BI

Updated on:

May 12, 2026

By:

Use this interactive demo to learn how to build an Excel-style worksheet visual in Power BI.

Quick summary

This tutorial shows how to import an Excel workbook into Power BI Desktop and create a table visual that replicates a spreadsheet-style worksheet. Follow each step to connect your data, choose the right visualization, and format it for clarity.

Steps

Open Power BI Desktop, click Home, and select Get data.
Select Excel workbook as your data source.
Click Load to import your data set into Power BI.
In the Visualizations pane, select the Table icon.
Add fields to the table visual from your loaded data set.
Format the visual to make it look more like an Excel worksheet.

📌 Why this matters

Power BI's ability to import Excel workbooks and render data as a formatted table visual gives analysts a familiar, spreadsheet-style interface inside a powerful BI environment. This workflow lets teams transition from static Excel files to dynamic, refreshable Power BI reports without losing the row-and-column layout their stakeholders expect. Creating an Excel-style worksheet in Power BI bridges the gap between traditional spreadsheet reporting and modern data visualization, making insights easier to share and act on.

Your product deserves an interactive demo

Start free

How to Uninstall Power BI

How to Compare Two Measures in Power BI

How to Compare Months in Power BI