Navigate to [https://docs.google.com/spreadsheets/d/1ziZjwhGdcsow9lqMdKA82G4BNDIaURUTYT-qxJjSRDI/template/preview](https://docs.google.com/spreadsheets/d/1ziZjwhGdcsow9lqMdKA82G4BNDIaURUTYT-qxJjSRDI/template/preview)

This W2 cell (Yes, the picture shows V2, it is an old version) has the "Magic Code" that will create your review formatting.

Fill in cells B-V (You can copy some of this from a Goodreads export if you want to use you TBR)

Boom, there is your review. To make it more readable click here.

You can copy this cell and past your formatted review anywhere!

Or if you copy the cell and past it lower in column V in the spreadsheet it will copy the formula.

Note this copied the formula, not the text

If you get rid of or add columns you will need to update the formula to account for it.

=CONCATENATE(B380, CHAR(10), CHAR(10), "I just finished reading ", C380, " by ", D380, ". I read the ", F380, " published by ", E380, ". ", H380, I380, J380, CHAR(10), CHAR(10), "This book is a must read if you like: ", K380, CHAR(10), CHAR(10), L380, CHAR(10), CHAR(10), M380, CHAR(10), CHAR(10), N380, CHAR(10), CHAR(10), O380, CHAR(10), CHAR(10), P380, CHAR(10), CHAR(10), Q380, CHAR(10), CHAR(10), R380, CHAR(10), CHAR(10), S380, CHAR(10), CHAR(10), T380, CHAR(10), CHAR(10), "Content Warnings: ", U380, ".")


Google Sheets is a powerful online tool to help you do quantitative analysis. Learn how to use formulas to manipulate and analyze datasets, such as Google Sheets' COUNTIF and SUMIF functions, among many others.

How To Use The Google Sheets Template For Book Reviews