@James I wanted to share that if you filter the enrollments file to only display rows where the role is "teacher" prior to copying the data to the master (rather than deleting all other roles later on), that saves a whole lot of time. I'm going to share updated steps below in case anyone in the community wants to use your first method. Also including the formulas to pull in email addresses for those who may be interested. We wouldn't have been able to get this much needed info without your help. Very much appreciated. -- Generate provisioning reports.  Admin > Account > Settings > Reports  Generate Provisioning reports for: Courses, Enrollments, and Users. Select the desired term. Download the provisioning reports and open them all up. Open a new Excel worksheet which you will use as a master. Save it to your device.  Create three tabs in the master and name them (1) courses, (2) enrollments, and (3) users.  From the downloaded enrollments file, filter to display only rows where role is “teacher”. Copy the results to the master.  Copy the other two provisioning reports into the designated tabs in the master spreadsheet. Format each report as a table. Go to Home > Format as Table or Insert > Table to convert the data into a table. The table style doesn't matter. Name the tables (upper left) (1) courses, (2) enrollments, (3) users so you can refer to them later in the scripts. Go to the enrollments table. We are going to pull the name of the first instructor listed in each course onto this page.  In the enrollments table, click in the next available column and add a header called full_name. Right below the header, enter the following formula: =XLOOKUP([@[canvas_user_id]],users[canvas_user_id],users[full_name]) Go to the courses table. We are now going to duplicate the name of the first instructor for the course onto this page. Click in the next available column and add a header of full_name.  Right below that, enter the following formula: =XLOOKUP([@[canvas_course_id]],enrollments[canvas_course_id],enrollments[full_name],"") Filter based on course status Go to the courses table, Filter and select only active or unpublished to view the list of courses you would like to see.  Bonus: Include emails. Go to the enrollments table. In the next column, add the header “emails”. In the cell beneath the header, enter =XLOOKUP([@[canvas_user_id]],users[canvas_user_id],users[full_name]) Go to the courses table.  In the next column, add the header “emails”. In the cell beneath the header, enter =XLOOKUP([@[canvas_course_id]],enrollments[canvas_course_id],enrollments[emails],"") ... View more

@James The updated instructions for Method 1 worked. Thanks so much! My goal was to get a list of published courses with instructor information (rather than Unpublished courses) so I don't think the Google Sheets method would be able to get me what I needed. I was curious though, so I did attempt to Method 3 to see if I can get a list of unpublished courses. Unfortunately, I continued to run into quite a few errors so it didn't work out in my favor. Anyway, thanks again for your wonderful blog. Very much appreciated! ... View more

@James Thanks! The formula now pulls the instructor names into the courses sheet but the instructor names don't seem to be correctly placed next to the proper course. Is that expected? I looked back at your recording and when you sort your spreadsheet, it looks like the full_name column remains static while the rest of the sheet reorganizes based on how you tell it to sort. Any way to get the instructor names in the same row as the course they're teaching?  ... View more

@James Thanks so much for this amazing resource! I'm attempting Method 1 and am able to get past Step 6. However, when I add the INDEX formula from step 7, I get #SPILL! errors all down the full_name column in the courses sheet. I compared the columns in each of my sheets with those in your video (had to delete a few columns since the reports now include more columns) to confirm they match since the video specifically mentions column 6 from the users table. When Googling, #SPILL! errors seem to be when a formula returns multiple results, and Excel cannot return the results to the grid. Any suggestions as to how I can work around this? Thanks again!     ... View more