Tutorial: How to Import Excel Recipes & P6 Resources


1. This tutorial will show you multiple data import methods in ALICE

Step 1 image

2. Click Recipes

Step 2 image

3. Click Import Excel file

Step 3 image

4. Click highlight to select a file to import or drag and drop.

Step 4 image

5. Users can import all recipes in the recipe matrix format or select key recipes.
Note: recipe matrix was exported from Trial Projects - Infra Recipe Library

Infra Recipe Library Download link

Step 5 image

6. Scroll down and click Import Recipes

Step 6 image

7. Click OK, reload page

Step 7 image

8. Click Recipes

Step 8 image

9. Users can now see the recipe library was successfully imported and available for planning

Step 9 image

10. Click Resources to see additional data that can be imported in the resource pool

Step 10 image

11. click Import from P6 to import Crews from an existing P6 schedule

Step 11 image

12. Click highlight to select a file to import or drag and drop.

Step 12 image

13. Click on the top box to select all

Here is a link to the GWP P6 file for import.

Step 13 image

14. Click Bulk Edits

Step 14 image

15. Bulk edits can be made to the subcontractor

Step 15 image

16. Click ALICE Recipe Template Library to assign a subcontractor

Note: create new subcontractor names prior to importing the file

Step 16 image

17. Click your preferred calendar to bulk assign

Step 17 image

18. Input an hourly cost or leave blank

Users can also bulk assign cost and available maximum crews

Note: recommend leaving this crew availability blank as the crew max might vary by crew type

Step 18 image

19. Click Save to apply bulk changes

Step 19 image

20. Scroll down and click Next

Step 20 image

21. Click Import & Reload

Step 21 image

22. Click Equipment tab to see the option for importing equipment from an existing P6 file

Step 22 image

23. Click Import from P6 to import equipment from an existing P6 file

Step 23 image

24. Click Calendars

Step 24 image

25. Click Import from P6

Step 25 image

26. Click highlight

Step 26 image

27. Click to Select all calendars from the P6 file for import

Step 27 image

28. Click Next

Step 28 image

29. Click Import & Reload

Step 29 image

30. Now you can see all of your P6 calendars are successfully imported

Step 30 image

** Best experienced in Full Screen (click the icon in the top right corner before you begin) **


Next step

This clickable tutorial shares best practices for importing a recipe matrix from excel and importing your resources from an existing P6 schedule file. 

Next step

Was this article helpful?
0 out of 0 found this helpful