posted Mar 8, 2014, 3:09 PM by Eric Curts   [ updated May 17, 2014, 10:24 AM ]
Normally when we think of spreadsheets, what comes to mind is numbers, statistics, and charts. But how about playing a game?

Since I am a Google Geek, I decided to create a playable version of the beloved Battleship game inside of Google Sheets. And with that, Battlesheets was born!

Here's how it works:
  • Basically it is an online game where each player uses a different tab in a shared spreadsheet, types in letters in one grid to place their ships, and then takes turns typing in X's in another grid to drop their bombs.
  • Pre-made formulas and conditional formatting then show you if you have hit your opponent and if they have hit you.
  • The game continues until one player has sunk all of their opponent's ships.
  • Replay is as easy as deleting the contents of your grids and starting over.
  • Detailed directions are included on the first tab of the spreadsheet labeled "Instructions".

Battlesheets is available as a read only spreadsheet template, which means you will need to make your own copy of the spreadsheet, and then share it with your opponent to play. To access the Battlesheets template click the link below:

To learn more about the Google Sheets features used to make the game, check out the Google help pages on topics such as conditional formatting, the spreadsheet function list, and specifically the IF function.

If you have any suggestions or feedback please let me know so I can continue to improve the game. Plus a big thanks to Doug Terhune for testing the game with me and offering great ideas for improvement.

So find a friend, drop your bombs, and let the Internet hear you cry "You sunk my Battlesheet!"

The gadget spec URL could not be found