You’ll need: The material data with its source and units, and a spreadsheet application.
Prepare the workbook#
- Open Material Library → Import Materials.
- Click Save Excel Template and save a copy.
- Open the template. Keep its sheets and headers as they are.
- In Settings, set UnitSystem to Metric or Imperial. Leave TemplateVersion unchanged; BatchName is optional.
- Fill in the Materials sheet and save.
Load and review#
- In Import Materials, click Choose Excel File.
- Select your workbook.
- Confirm the units and batch shown.
- Work through each row’s status. Use Search or Status to filter.
| Status | What to do |
|---|---|
| New | Check the entry, then import. |
| Warning | Read the warning and fix the data if needed. |
| Exact match | Usually skip — it already exists. |
| Possible duplicate | Import only if you really want a second copy. |
| Error | Fix the row in the workbook; it can’t be imported. |
Import the chosen rows#
- Tick only the rows you want, and check the selected count.
- Click Import Selected.
- Wait for it to finish.
New and Warning rows may be ticked for you. That isn’t approval — untick anything you haven’t checked.
Check your result#
The new materials appear in the library with the right units and band values.