It is simple to design a data spreadsheet. There are some basic components and guidelines to follow in making the spreadsheet. The first step is to make sure that the data is organized in the table. This should be done in a column and row format.