Microsoft cloud engineer - SharePoint, Office 365, Azure, DotNet, Angular, JavaScript.
Microsoft cloud engineer - SharePoint, Office 365, Azure, DotNet, Angular, JavaScript.

Excel fill down for easy admin scripting

As an admin I use several scripting languages.    I find one common trick helpful across them all.    It’s amazingly simple and easy to adapt – Excel Fill Down.    Maybe you already use this and that’s cool.   But for those that don’t you’ll want to give it a try.

 

image

 

Simply copy/pasting output from Command Prompt, SQL Studio, or PowerShell can help build an Excel worksheet of inputs.   Simple string concatenation in Excel can build commands in bulk.   Fill down then copy/paste back to your server to execute.    I realize with SharePoint 2010 this could be a moot point considering how nicely PowerShell object collections pipe but I somehow think I’ll still be using Excel fill down to build scripts each day.

It’s a simple trick, but many of our best admin tools are the simple flexible ones we can use in many ways.

One last trick worth sharing is the drag and drop capability of Command Prompt.   File and folder paths can be long and tedious to type.   Why waste your time?    Just open Explorer side by side and drag items to Command Prompt to type them perfectly every time. 

Hot
image

© Copyright 2016
@ SPJeff

Return to Top ▲Return to Top ▲