How to insert a table in Visio 2010

Hi...

 

I need to create a table in Visio 2010 that has 12 rows and 4 columns. I cant for the life of me see where and how I can accomplish this! Any help is greatly appreciated! :) 

February 28th, 2011 6:17pm

Visio 2007 Professional contains a set of Grid table shapes that allow you to adjust the row and column count.  To access from the stencil menu path: Business -> Charts and Graphs -> Charting Shapes.

If that's also in 2010, you may be good to go.

Free Windows Admin Tool Kit Click here and download it now
February 28th, 2011 6:55pm

Thanks Stephen!!! That worked perfectly :)
March 1st, 2011 6:41pm

Insert an Excel Worksheet

Use: Insert \ Object \ Microsoft Excel Worksheet

This is the only way to do this without it being a kludge

Free Windows Admin Tool Kit Click here and download it now
February 9th, 2012 7:20pm

Those tables from charting shapes are horrible.

Too bad Visio doesn't have a problem table create function, its not always handy to import from excel. If you have access to a Mac with omnigraffle has a nice table function though haha ;)

Anyway I prefer it this way, to go Data -> Link Data to Shapes, this way have more control about what you import from the excel sheet and what not and easier to resize. 

April 19th, 2012 2:25pm

Yes, the Grid Control provided in "Charting Shapes" isn't very usable given it doesn't seem to resize properly when you adjust the number of rows/columns.

I was hoping I could paste from Excel, but this doesn't seem to work.

Any other ideas?

Edit: I used Insert/Object Microsoft Excel Worksheet and it sort of works. 

  • Edited by Peter_D503 Thursday, April 26, 2012 1:18 AM Insert/Object
  • Proposed as answer by Alex Serafico Wednesday, April 24, 2013 3:05 PM
  • Unproposed as answer by Alex Serafico Wednesday, April 24, 2013 3:06 PM
Free Windows Admin Tool Kit Click here and download it now
April 26th, 2012 1:13am

Yes, the Grid Control provided in "Charting Shapes" isn't very usable given it doesn't seem to resize properly when you adjust the number of rows/columns.

I was hoping I could paste from Excel, but this doesn't seem to work.

Any other ideas?

Edit: I used Insert/Object Microsoft Excel Worksheet and it sort of works. 

  • Edited by Peter_D503 Thursday, April 26, 2012 1:18 AM Insert/Object
  • Proposed as answer by Alex Serafico Wednesday, April 24, 2013 3:05 PM
  • Unproposed as answer by Alex Serafico Wednesday, April 24, 2013 3:06 PM
April 26th, 2012 1:13am

Yes, the Grid Control provided in "Charting Shapes" isn't very usable given it doesn't seem to resize properly when you adjust the number of rows/columns.

I was hoping I could paste from Excel, but this doesn't seem to work.

Any other ideas?

Edit: I used Insert/Object Microsoft Excel Worksheet and it sort of works. 

  • Edited by Peter_D503 Thursday, April 26, 2012 1:18 AM Insert/Object
  • Proposed as answer by Alex Serafico Wednesday, April 24, 2013 3:05 PM
  • Unproposed as answer by Alex Serafico Wednesday, April 24, 2013 3:06 PM
Free Windows Admin Tool Kit Click here and download it now
April 26th, 2012 1:13am

To insert a table in Visio Basic:

  • Create the table in Excel or Word
  • Copy the screen image to clipboard (Alt-Print Scrn)
  • Open Paint
  • Paste screen image into Paint
  • Crop the image to only the table.
  • Save cropped image as a .png file
  • Insert .png file as a picture in Visio.
  • Resize and place picture as needed within Visio

Kinda roundabout method, but it works.

mcgruk

July 9th, 2012 6:21pm

Hello Peter,

Regarding the Grid shape resizing problem - I wrote a blog post about this a while ago and it includes a download shape that solves the problem:

http://visualsignals.typepad.co.uk/vislog/2012/02/modifying-the-visio-grid-shape.html

http://visualsignals.typepad.co.uk/vislog/2012/03/building-visio-shapes-with-code.html

Best regards

John

Free Windows Admin Tool Kit Click here and download it now
July 10th, 2012 7:38am

I've just been having the same problem and tried all the suggestions below but wasn't happy with the results, so I kept trying and found something that works for me:

  1. Copy a section of an Excel spreadsheet
  2. Right Click in your Visio drawing
  3. Select 'Paste Special' 
  4. Select 'Microsoft Excel Worksheet'
  5. Click OK and the copied cells are inserted.
  6. Double-Click inside the inserted cells and they open up in Excel format and behave just as though you are working in Excel, within Visio!
  7. Create you Table as you want it
  8. Double-Click outside the Table and it becomes part of the drawing again!

Good Luck!

John

  • Proposed as answer by twelve345 Tuesday, December 16, 2014 10:21 PM
September 17th, 2013 10:55am

I've just been having the same problem and tried all the suggestions below but wasn't happy with the results, so I kept trying and found something that works for me:

  1. Copy a section of an Excel spreadsheet
  2. Right Click in your Visio drawing
  3. Select 'Paste Special' 
  4. Select 'Microsoft Excel Worksheet'
  5. Click OK and the copied cells are inserted.
  6. Double-Click inside the inserted cells and they open up in Excel format and behave just as though you are working in Excel, within Visio!
  7. Create you Table as you want it
  8. Double-Click outside the Table and it becomes part of the drawing again!

Good Luck!

John

  • Proposed as answer by twelve345 Tuesday, December 16, 2014 10:21 PM
Free Windows Admin Tool Kit Click here and download it now
September 17th, 2013 10:55am

I've just been having the same problem and tried all the suggestions below but wasn't happy with the results, so I kept trying and found something that works for me:

  1. Copy a section of an Excel spreadsheet
  2. Right Click in your Visio drawing
  3. Select 'Paste Special' 
  4. Select 'Microsoft Excel Worksheet'
  5. Click OK and the copied cells are inserted.
  6. Double-Click inside the inserted cells and they open up in Excel format and behave just as though you are working in Excel, within Visio!
  7. Create you Table as you want it
  8. Double-Click outside the Table and it becomes part of the drawing again!

Good Luck!

John

  • Proposed as answer by twelve345 Tuesday, December 16, 2014 10:21 PM
September 17th, 2013 10:55am

nice one..
Free Windows Admin Tool Kit Click here and download it now
April 27th, 2014 6:34am

This works great in any Visio version

1. Open Power Point with a blank slide.

2. Copy Excel Grids / Cells

3. Paste in Power point slide . It creates a Table.

4. Copy the Power point Table

5. Paste in VISIO.... WOW....!!

Regards

Udhay

September 6th, 2014 6:20am

This works for Visio 2013 (not sure of 2010). In Word, copy your table to the clipboard. In Visio, choose (from the ribbon) Insert > Object > Microsoft Word Document and then paste the content from the clipboard. You now have an editable Word object with in Visio which you can format.
Free Windows Admin Tool Kit Click here and download it now
November 11th, 2014 2:00pm

Thanks so much Ian, your method works perfectly!!
April 21st, 2015 9:44am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics