Tidy Tables logoTidy Tables

Before you ask for a quote

Choose your Excel columns

Pick the columns you want in your cleaned spreadsheet, put them in order, and copy the list into the Desired output box of the quote request. Start from the suggestions for a supplier price list or an inventory sheet, and add your own.

Pick and order your columns

Suggested columns

Pack size and pack price are two columns

Suppliers often write them together, as in "50/box $18.50". Keep them apart: the pack size says how many units come in a pack, and the pack price is what one whole pack costs. Here is a made-up example from a fictional supplier, Harbour Paper Co.

Kraft mailers: 50 per box, SGD 18.50 per box

SKUProductUnits per packPack typePack priceCurrencyReview notes
HP-210Kraft mailers50box18.50SGD
HP-244Packing tape6caseSGDPrice unclear in source - confirm with supplier

Say which currency you want

Name it in your request, for example "prices in SGD", or keep a Currency column so every price carries its own. If a supplier mixes currencies, tell us which one to convert to, or ask us to leave them as written.

Ask for unclear entries to be flagged

Keep a Review notes column and ask that anything we cannot read or are unsure of is left blank and flagged there, as with the packing tape above, instead of being guessed.

Ready to ask for a quote?

Copy your column list above, then paste it into the Desired output box on the quote form.