Technology

#How to Embed a Microsoft Excel Sheet on Your Blog or Site

“How to Embed a Microsoft Excel Sheet on Your Blog or Site”

Microsoft Excel logo on a green background

While you can easily share an Excel workbook or spreadsheet, you might want to make it available to a larger audience. If you have a blog or website, you can embed the file by copying and pasting the embed code.

You can grab the code to embed the spreadsheet from either OneDrive or Excel on the web. Then, customize the appearance and ways your visitors can interact with the workbook or sheet.

Method 1: Get the Embed Code From OneDrive

Visit OneDrive on the web and sign in. Locate the Excel file you want to use and select it. When the toolbar appears at the top, click “Embed.”

If you’re using List or Compact List view, you can also click the three dots next to the file and select “Embed.”

Embed options for a OneDrive file

A sidebar will open with a preview of the sheet and the embed code. You can copy the code as-is or make changes to it so that it fits your needs. Select the link at the bottom of the sidebar if you’d like to customize the code.

Embed code sidebar in OneDrive

Method 2: Get the Embed Code From Excel on the Web

Visit Excel on the web and sign in. Locate the file you want to use and open it. Head to the File tab and select Share > Embed.

Embed in the Share options for Excel on the web

You can then make the adjustments described below to customize the code.

Customize the Code

Regardless of which method you use above, you’ll see the same options for customizing the code. These options appear on the left side of the screen with a preview on the right so that you can see how your changes affect the sheet.

Customize code window

What to Show: You can choose the entire workbook, a specific range, a chart, table, or other option that you see.

Customize What To Show

Appearance: Check the boxes for hiding the grid lines or headers, and optionally to include a download link.

Customize Appearance

Interaction: Check the boxes to let others sort and filter or enter data in the cells. Note that if you allow the second option, changes they make are not saved. You can also enter a specific cell to start with or click a cell in the Preview to set the active cell.

Customize Interaction

Dimensions: If you want the spreadsheet to be a certain size, enter the width and height in pixels.

Customize Dimensions

Preview: As mentioned, you’ll see any changes you apply on the left side to the preview on the right side. If you’re sharing the whole workbook, you can move through each sheet using the tabs.

If you adjusted the dimensions for the workbook, you can use the View Actual Size link to open the size that will display in a new browser tab.

Workbook preview

You’ll also see a small toolbar across the bottom in both the Preview and View Actual Size. This contains buttons for opening Excel on the web, downloading the file if you marked that option, refreshing the connections, obtaining information about the workbook, and opening the file in full-size.

Workbook actual size and toolbar options

Embed Code or JavaScript: On the bottom left is a box containing the code that you’ll copy after making your adjustments and reviewing the preview. You can choose Embed Code or JavaScript per your preference.

Embed code for an Excel file

Place your cursor inside the box to select all of the code. Then either right-click and pick “Copy” or use the keyboard shortcut Ctrl+C on Windows or Command+C on Mac.

Copy in the shortcut menu

You then have the code on your clipboard that you can paste into your blog or website where needed.

By sharing the Excel workbook, sheet, table, or chart on your site, your visitors can see a nice snapshot of the data you want to share.

For more, look at how to embed Google Calendar on your site too!

If you liked the article, do not forget to share it with your friends. Follow us on Google News too, click on the star and choose us from your favorites.

For forums sites go to Forum.BuradaBiliyorum.Com

If you want to read more like this article, you can visit our Technology category.

Source

Related Articles

Leave a Reply

Your email address will not be published. Required fields are marked *

Back to top button
Close

Please allow ads on our site

Please consider supporting us by disabling your ad blocker!