Auto formatting data into sendmany command
You can export the spreadsheet as a CSV file, then parse it using your favorite programming language into a dictionary. Convert the dictionary to JSON, and that will give you the second argument to the sendmany command. 

I'd do this in Python using the built-in csv and json packages.

I'm not aware of any solutions that will do this if you don't know how to program, though.