How to create a pricing sheetPerform market research. As I mentioned right off the bat, you need to first develop a pricing strategy. ... Calculate profit margins. ... Open your spreadsheet document. ... Create a column for products and services. ... Create a column for prices. ... Enter business contact information.