Importing the Spreadsheet
The ability to import Excel spreadsheets into Publisher 2010 makes it easy to bring existing data into a Publisher document. To begin, go to Publisher 2010 and click on the "Insert" tab to get to the "Insert" ribbon where you will find the "Insert Object" icon.
Now, click the "Insert Object" icon and you will see the "Insert Object" dialog open. This is where we will import the spreadsheet into your publisher document. In the "Object Type" window, scroll down until you see "Microsoft Excel Worksheet" and highlight that line.
Next, look over to the left of this window: you can choose to create a brand new Excel document if you want to, or you can create your object from your existing spreadsheet. In this case, you want to use the spreadsheet created early, so click the "Create from File." You will now see your "Insert Object" window change.
Here you see the "Browse" button that you will click to locate the Excel spreadsheet you wish to import. You also see a "Link" check box. If you want to make sure that your Publisher 2010 document always has the latest data from your spreadsheet, click "Link."
Let's go ahead and click the "Link" option. Most of the time you probably won't want to use the "Display As Icon" checkbox. Now, browse to your spreadsheet and select it.
Click the "OK" button to import the Excel spreadsheet into Publisher 2010.
The import is now complete: your Excel spreadsheet is now an object placed into a Publisher 2010 document. You may now format this object as you see fit to integrate it into your Microsoft Publisher publication.