How to Create an Excel Worksheet in Power BI
- George Apostolov
How to Create an Excel Worksheet in Power BI: step-by-step guide
Open Power BI Desktop. Click 'Home' and select 'Get data'.
Select 'Excel workbook'.
Click 'Load' to load your data set.
In the 'Visualizations' pane, select the 'Table' icon.
Add fields to the visual.
Format the visual to look more like a worksheet.
Quick answer: To create an Excel worksheet in Power BI Desktop, open the app, get data from an Excel workbook, and load the dataset. Next, select the table icon in the visualizations pane, add your fields to the visual, and format it to resemble a worksheet.
About this Excel tutorial
Import Excel data into Power BI Desktop, add a table visual, and format the fields to build your worksheet quickly. This guide shows how to create an Excel Worksheet in Power BI in 6 steps, starting with "Open Power BI Desktop. Click 'Home' and select 'Get data'" and finishing with "Format the visual to look more like a worksheet". The interactive demo above is a click-through copy of the real Excel interface, so you can rehearse each step before doing it in your own account.
Frequently asked questions
How many steps does it take to create an Excel Worksheet in Power BI?
6 steps. Each one is listed in order above, and the demo highlights exactly where to click.
Can I try it without changing my own account?
Yes. Clicking through the demo doesn't touch your Excel data or settings. Once you know the flow, repeat it in your own workspace.
This tutorial is filed under Excel and Power BI. Related guides: How to create data entry form in microsoft excel, How to create drop down list in microsoft excel and How to Create Labels Microsoft Excel. Last reviewed 05 Oct 2026.
Create your first interactive demo in minutes
No credit card required • Start building today
