In order to generate a bond ladder spreadsheet, you need to know a little bit about your bonds. Make sure that the bonds you want to look at are backed by a government or some kind of legal entity. Don't forget that government bonds are always backed by the government. You can see your requirements on the bond page of your local financial firm.