Pasting Parameter Values from Excel into Microsoft Test Manager

Pasting multiple columns into your parameters does not work as you would expect when you use the CTRL + V shortcut

For example let’s take this table in Excel














When you try to use the CTRL + V shortcut keys you will most likely get this result

The work around is to Right click and then select paste. But make sure the cursor is not located in any of the fields

And the results are what you would expect, each cell copied is pasted in the same manner

  1. #1 by Dave Diehl on August 3, 2011 - 3:39 pm

    Nice catch. I was banging my head on the desk trying to figure this one out when I found your post. Thanks.

    HOWEVER — one gotcha. If you have a blank Excel column, the paste skips it and shifts the other columns to the right. Ick.

  2. #2 by Brian Megilligan on January 13, 2016 - 2:39 pm

    Thank you for this! Frustrated the microsoft’s documentation isn’t a little clearer on this point. This is functionality that could definitely be improved!

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: