Using PowerPivot’s Copy-Paste Support for Importing Data from Word

In this article, we will be discussing about using PowerPivot’s copy-paste support for importing data from MS Word.

 

Importing Data into PowerPivot

One of the great features of SQL Server PowerPivot is that it supports importing data directly from the clipboard. This is quite handy in cases you want to import and analyze data fast.

An example of using the above feature is importing data from Microsoft Word. Let’s say you have a Word document containing the following table:

Using PowerPivots Copy-Paste Support for Importing Data from Word - Article on SQLNetHub

The scenario here is to import the data from Word and perform a simple analysis.

The first step is to select the entire table and copy its contents to the clipboard.

Then you have to launch Excel 2010 and open the PowerPivot window:

Using PowerPivots Copy-Paste Support for Importing Data from Word - Article on SQLNetHub

 

Click on “To New Table” and you will be presented with a Paste Preview dialog in which you will be able to see the contents of the clipboard and how they are “translated” by the PowerPivot engine:

Using PowerPivots Copy-Paste Support for Importing Data from Word - Article on SQLNetHub

At the bottom of the dialog you can choose to use the first row as column names and that’s what I did in this example.

You then click on “OK” and you are presented with the data as imported into PowerPivot:

Using PowerPivots Copy-Paste Support for Importing Data from Word - Article on SQLNetHub

Next, by clicking on the “PivotTable” button you are presented with various options regarding what type(s) of pivot tables you can create:

Using PowerPivots Copy-Paste Support for Importing Data from Word - Article on SQLNetHub

For this example I chose to use a “Single PivotChart”.

Then, the PowerPivot dialog closes and the Excel worksheet is presented containing the pivot table:
Using PowerPivots Copy-Paste Support for Importing Data from Word - Article on SQLNetHub
You can then easily perform aggregations using the tools provided by PowerPivot:
Using PowerPivots Copy-Paste Support for Importing Data from Word - Article on SQLNetHub
Using PowerPivots Copy-Paste Support for Importing Data from Word - Article on SQLNetHub

Well, I guess that’s it for today! I hope you found this post useful!

Another post on copy-paste and PowerPivot is coming where we will see how we can copy-paste two tables from Word and build relationships on the data.

 

 

Learn More Tips like this – Enroll to the Course!

Check our online course titled “Essential SQL Server Development Tips for SQL Developers(special limited-time discount included in link).

Sharpen your SQL Server database programming skills via a large set of tips on T-SQL and database development techniques. The course, among other, features over than 30 live demonstrations!

Essential SQL Server Development Tips for SQL Developers - Online Course
(Lifetime Access/ Live Demos / Downloadable Resources and more!)

Learn More

 

Upgrade your Tech Skills – Learn all about Azure SQL Database

Enroll to our online course on Udemy titled “Introduction to Azure SQL Database for Beginners” and get lifetime access to high-quality lessons and hands-on guides about all aspects of Azure SQL Database.

Introduction to Azure SQL Database (Online Course - Lifetime Access)
(Lifetime Access/ Live Demos / Downloadable Resources and more!)
Learn More

 

 

Featured Online Courses:

 

Read Also:

 

Subscribe to our newsletter and stay up to date!

Subscribe to our YouTube channel (SQLNetHubTV)!

Like our Facebook Page!

Check our SQL Server Administration articles.

Check out our latest software releases!

Check our eBooks!

 

Rate this article: 1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)

Loading...

Reference: SQLNetHub.com (https://www.sqlnethub.com)

© SQLNetHub