Import your services and gear from a spreadsheet

Fill in the Google Sheets template with your services and rental products, export each tab and import it under Settings. It saves hours compared with typing everything in.

Project Binder builds every estimate from your own services and gear, so the first job in a new account is getting them in. If they are already in a spreadsheet, or you would rather type them into one, import them in two files: one for services and one for rental products.

Before you start#

  • Open the Google Sheets template. Google will ask to make a copy in your own account.
  • In Project Binder, set up your organizational groups first, under Settings (the gear icon at the top right). The import matches each line to a group that already exists. Anything it cannot match, you assign by hand during the import.

Steps#

  1. Fill in the Services tab. One row per service: name, description, category, group, subgroup, price, cost, unit of measurement, and the three Yes/No columns. Overwrite the example rows.
  2. Fill in the Rental Products tab. One row per main item: camera bodies, lenses, lights, tripods, recorders.
  3. Check both tabs. Every required field has data, every Yes/No column is answered, and there are no empty rows at the bottom.
  4. Export each tab as its own file. With the tab open, choose File, Download, Comma Separated Values (.csv). Do this once for each tab.
  5. Import the file. In Project Binder, go to Settings, Products & Services, Options, Import CSV, and upload the file.
  6. Review the preview. The columns map themselves if you left the headers alone. A line highlighted in orange has a group that did not match: pick the right one from the list.
  7. Confirm the import with the button under the preview (Add new for services, Add Rental Products for rental products), then repeat steps 5 and 6 for the other file.
The services tab of the template, with example rows
The services tab of the template, with example data

What to leave out of the Rental Products tab#

  • Kits and packages, such as a lighting package or a sound bag. Build these as Rental Packages inside Project Binder once the products are in.
  • Small accessories, such as batteries, media and cables. These are entered as Rental Items inside Project Binder.

After the import#

  • Imported rental products have no picture yet. Open a product and search for an image from its page.
  • Click any service in the list to change its rate, cost or group later.

Read the guide

  • Estimate

    Build a rate sheet for your services and gear

    One list of everything you sell, with what you charge and what it costs you. It keeps your pricing consistent from one estimate to the next, and a free template gets you started.

    3 min read

The whole product tour