Sign OS
  • Features
  • Trade Link
  • Integrations
  • Compare
  • Pricing
  • Guides
  • About
☰
  • Features
  • Trade Link
  • Integrations
  • Compare
  • Pricing
  • Guides
  • About
  • Sign in
Sign inStart free trial
Sign OS

Job management software for sign shops. Built in Victoria by someone who’s done the jobs.

Product

  • All features
  • Trade Link
  • Pricing
  • Integrations
  • What's new
  • Status

Compare

  • vs shopVOX
  • vs CoreBridge
  • vs SignTracker
  • vs Hexicom
  • vs Cyrious Control
  • vs Ordant
  • vs PrintPLANR
  • vs WorkflowMax
  • vs Printavo
  • vs tradie job apps

Resources

  • Sign shop guides
  • Free templates
  • Overhead calculator
  • Landed cost calculator
  • Blog
  • Help centre

Company

  • About
  • Contact
  • Your data
  • Terms
  • Privacy
  • For installers
  • For suppliers
© 2026 Sign OS · Run by Todd Farrell, sole trader · Victoria, Australia · ABN 50 613 736 709Prices in AUD · Sign in
Help/Bulk import/Build products from a spreadsheet
Bulk import4 of 4How-to

Build products from a spreadsheet

How do I build a lot of products at once without making each one by hand?

For
Whoever sets up the catalogue
Where to find it
Sidebar › Catalogue › Products › Build from spreadsheet
Takes
30 minutes for a first batch
You need
A login that can add products, with your materials, machines and labour already set up

What it is for

When you have dozens or hundreds of products to set up, a spreadsheet is quicker than the builder. One tab names the products and another lists what each one is made of, a line per row. The dropdowns hold your own materials, machines, labour and items, so you can only pick what your shop has. Everything is checked before anything is built, and each built product comes back with a test price to check.

After this you can

  • Download the spreadsheet with your own catalogue in its dropdowns
  • Fill in the Products and Recipe tabs
  • Upload it and fix anything it finds
  • Check each product's test price, and undo the upload if it is wrong

Before you start

  • Add your materials, machines, labour rates and items first. The dropdowns can only offer what is already in your catalogue.

The Build products from a spreadsheet screen

Catalogue›Products›Build from spreadsheet
The Build products from a spreadsheet screen with four numbered parts
  1. 11. Download the spreadsheetIt opens in Excel or Google Sheets. The first tab explains each column with an example.
  2. 2Download spreadsheetMakes a fresh copy with your catalogue as it is right now.
  3. 32. Upload it when it's filled inSave it as an Excel file first.
  4. 4The file pickerPick the file and it is checked straight away. Nothing is built yet.

Step by step

  1. 1

    Open the screen

    Go to Catalogue, then Products, and press Build from spreadsheet.

  2. 2

    Download the spreadsheet

    Press Download spreadsheet and open it in Excel or Google Sheets.

  3. 3

    Name your products

    On the Products tab, give each product a name and a family. SKU and description are optional.

  4. 4

    List what each is made of

    On the Recipe tab, add a row for each thing a product uses. Pick it under Uses, choose what it is Charged per, and fill in the quantity, minutes or price that line needs.

  5. 5

    Save and upload

    Save it as an Excel file and pick it under 2. Upload it when it's filled in.

    You’ll seeEither a list of things to fix, with the tab and row of each, or All good. Ready to build.

  6. 6

    Fix what it found

    Fix each row it lists in the spreadsheet, save, and upload it again.

  7. 7

    Build

    Press the Build button, which counts your products. Keep the page open until it finishes.

    You’ll seeEach product with a test price and anything worth a look.

  8. 8

    Check the test prices

    Read down the test prices. If something is wrong, press Undo this upload, fix the spreadsheet and upload it again.

The tabs in the spreadsheet

TabWhat it holds
How to useWhat each column means, with an example.
ProductsOne row per product: Product name, Family, SKU, Description and Same recipe as.
RecipeOne row per thing a product uses: Product name, Uses, Charged per, Quantity, Minutes, Setup minutes, Waste %, Price $, Name on quote, Choice group and Show on quote.
ListsWhat fills the dropdowns. Leave it alone.

The columns that matter most

ColumnWhat to put in it
UsesA material, a machine, labour or an item from your own catalogue, a fixed fee, or None for a line with no charge.
Charged perSquare metre, Linear metre (edge), Each sign or Whole job.
Same recipe asThe name of another product in the sheet, to give this one the same recipe without typing it again.
Choice groupRows with the same group name become a choice on the product, such as a laminate.
Show on quoteYes or No: whether the customer sees this line's name on the quote.

What the test price is

Every built product is priced once so you can see it is in the right range.

Size1200 x 600 mm
Quantity1
ChoicesThe first in each choice group
Price shownBefore GST

A test price that looks far too high or low usually means a wrong Charged per or a quantity in the wrong unit.

Tips

Pasting in hundreds of rows is fine. A pasted cell can say m2 or ea in place of the dropdown's wording and it is still understood.

Download a fresh spreadsheet after adding new materials or machines, so they are in the dropdowns.

Use Same recipe as for products that only differ by name, such as the same sign in several stock sizes.

If the build stops part way, press Carry on building. What was built already is kept.

Watch out

Nothing is built while there is anything left to fix. Fix every row it lists first.

It only shows the first batch of problems. Fix those and upload again to see the rest.

One spreadsheet takes up to 1,000 products and 10,000 recipe rows.

Undo this upload removes every product that upload built. Use it before anyone quotes with them.

Don't rename the tabs or the column headings. The upload reads them by name.

Open this in Sign OS →

Where to next

Before this

Add materials (your stock library)The substrates and media you consume, in real units at real prices.Add your machines and what they cost to runPrice printer, laminator, router and laser time automatically.Set labour rates per departmentWhat an hour of each department costs, and more than one rate where the work runs at different speeds.

Next step

Build a productA priced recipe of material, work and choices that anyone can quote in seconds.

Related

Bulk-import from a spreadsheetLoad customers, suppliers, hardware items and rates fast, from CSV.Use premade products or build your ownWhen to pick a ready product versus building a one-off custom line.
Also found by searchingspreadsheetexcelbulkproductsbuild productsimport productsrecipeuploadtest price

On this page

  1. The Build products from a spreadsheet screen
  2. Step by step
  3. The tabs in the spreadsheet
  4. The columns that matter most
  5. What the test price is
  6. Tip and watch out
  7. Where to next