In Visio 2010 go to Insert -> Object -> Microsoft Excel Worksheet. You can also create tables from the shapes in Visio in the following way.
- Open the stencil containing the table shape you want: click the Shapes button on the Standard toolbar, select Charts And Graphs and then select Charting Shapes.
Visio adds the stencil to your drawing.
- Drag the Grid shape from the stencil to the location on the page you want.
The Custom Properties dialog box appears.
- Click the arrows to enter the number of rows and columns you want.
You can always add rows and columns to your table later.
- Click OK.
- If you want to change the cell width, you can grab a grid handle and expand or shrink the grid.
Visio adds a table with your specifications to the drawing page.
- If you want to use angled column labels, drag the Column Header shape from the Charting Shapes stencil into position over the first table column. Repeat this task for each column and resize as necessary to fit the column.
- If you want to have separate row labels, drag the Row Header shape from the Charting Shapes stencil into position to the left of the first row. Repeat for each row and resize as necessary to fit the row.
- To add text, click a row header, column header, or table cell, and then type