Interactive Excel Sample Data

There’s sample data on my Contextures website, and it’s useful for testing formulas and pivot tables in Excel.

sampledatainteractive01

On that page, there’s a link to a downloadable Excel file, with the same sample data. Or, you could just copy and paste the data into a workbook.

Now With Interaction

Now, thanks to Microsoft’s Excel Services, you can play with the data in Excel Interactive View. Just click the button above the sample data table, and the interactive view will open up.

Note: I’ve added the same feature to my Excel Book List page.

sampledatainteractive02

At the left, the Filters tab is selected, and you can click on any field name, to see its items. Then, click on an item to filter the table.

sampledatainteractive03

Sort the Data

In the data table, you can click any of the headings, to sort that column.

sampledatainteractive04

To sort it in the opposite order, click the heading again.

sampledatainteractive05

Create a Chart

You can also create a quick chart from the data. In the View panel at the right, click one of the chart views. On my Sample Data page, there is a chart view for each of the Value fields – Units, Cost and Total.

sampledatainteractive06

Here is the chart for Total values.

sampledatainteractive07

Table View With Data Bars

To return to Table view, click Table in the View panel.

sampledatainteractive08

The value fields in the table also show Data Bars, like the ones you can add in Excel, with Conditional Formatting.

sampledatainteractive09

Save and Print the Data

In the interactive view, you can also save and print the data. To print it, click the Options tab (gear icon), and click Print.

sampledatainteractive10

To download the data, click the Do More tab (X icon), and click Download.

sampledatainteractive11

Open in Excel Web App

To work with the data online, click on the Do More tab, then click Open in Excel Web App. In there, you can add formulas, and change the data, and use the other features available.

sampledatainteractive12

Add an Excel Interactive View on Your Site

To add an Excel interactive view to a table on your site, go to the Excel Mashup website. Click the Learn How link, to go to the page with instructions.

It’s easy to do:

  1. Select a button style
  2. Enter a title
  3. Add your website name
  4. Click the Generate Code button.

sampledatainteractive13

Follow the instructions in the two steps, to copy the code, and paste it into your website source code.

sampledatainteractive14

Then click Close, to go back to the web page.

Try the Interactive Excel View

To see how the interactive view works, go to the sample data page on my Contextures website, click the green button to get started.

Thanks Microsoft – this is an awesome new feature!

sampledatainteractive02

___________________

You may also like...

3 Responses

  1. Robert Ryan says:

    Debra – When I clicked the “sample data” link you provided at the end, the green button you showed above did not appear on the new page. (Running IE8, W7)

    • Thanks Bob, I’m using Firefox, and it works there, and in Chrome too. It even works on my iPad!

      I’ve just tried to add a fix for Internet Explorer, and it showed the button, but underlined all the text on the page. I’ll keep looking for a solution.

  2. Adrian says:

    Hello Debra,

    In first place, sorry for my English level, I’m writing to you from Buenos Aires.

    I’m trying to see your example working (http://www.contextures.com/xlSampleData01.html), but when I click on the button “Excel Interactive View” I get an error message “We’re sorry. We’re having trouble preparing the data right now”
    If I use the example on http://www.excelmashup.com I get the same error.

    Can you open the example without problems? I tried the example with Chrome, Firefox and Internet Explorer and I couldn’t see it.

    I suppose there is a problem in with the Office’s Server because if I open the web browser console to see the logs, I can read information about a “500 http error”.

    Maybe, “Excel Interactive Web” is out of service.

Leave a Reply to Adrian Cancel reply

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