Skip to main content

How to add or import components to study using a spreadsheet

In this guide, you will learn how to add components from a spreadsheet to a study without components or with components

Import a component list to a study without any components

1. Go to the Editor for the Study and click the Components section

Click on handyman…

2. Click on Add component(s) button

Click on Property test 52…

3. Click on the "IMPORT SPREADSHEET" menu option

Click on Import Spreadsheet

Note: To import components, ensure the Excel spreadsheet is filled in with the required information. Click the highlighted link to download the template.

Click on Click here to download Component List Import Template

4. Drag and drop the Excel file into the box or click the box to select from your local files

Select "HRIQ Component List Import Template v2 (5).xlsx" from file upload menu

5. Choose the Unit of Time option, Months or Years, based on whether the life values in the spreadsheet are months or years

Click on Months

6. If there are already components in the study, choose whether the new components should be added to the existing list or replace them

Click on Do you want to add to the existing components or replace them?

7. Click on "IMPORT FILE" button

Click on IMPORT FILE
Related Articles
Did this answer your question?