MCCC Knowledge Base

Creating an Excel file from a CSAR report


2019


Creating an Excel file from a CSAR report

 

 

 

Step 1. Run a CSAR Report or any Colleague Report

 

 

 

 

 

Step 2. Click Save As after report has completed.

 

 

 
Step 3. Right click the Blue Download button and click save link as. 
Step 4. Click the Save as type Drop Down and select All Files. Then add a .txt extension at the end of the file name. Once done you can click the save button.

 

 

Step 5. Open Excel and start a new worksheet.

 

 

 
Step 6. Click on the Data tab at the top of the worksheet. 

 

 

Step 7. On the left there should be either a Get External Data drop down or an option that says From Text. If you see the Get External Data drop down menu click that and select From Text. If you see From Text just select it.

 

 

 
Step 8. Navigate to your saved .txt file and open it you should get the box that is shown on the right and select next.
Step 9. Add/Remove/Adjust break-lines to your liking and then select Finish.

 

Attached Files
There are no attachments for this article.
Comments
There are no comments for this article. Be the first to post a comment.
Name
Email
Related Articles RSS Feed
EDU Student Clearance Record Keeping
Viewed 18880 times since Tue, Jan 12, 2016
Adding and Editing Sections Detailed Billing Information
Viewed 7563 times since Wed, Feb 18, 2015
Colleague - Overview
Viewed 5402 times since Thu, Jan 24, 2019
Directions for pulling a CSAR for subjects at mutliple locations and specific Gen Ed sections
Viewed 6980 times since Fri, Feb 24, 2017
Entering Faculty Observation and Evaluation Data in Colleague
Viewed 3733 times since Wed, Aug 7, 2019
Non-Credit, Open Enrollment Section Entry
Viewed 8200 times since Wed, Oct 22, 2014
Colleague Background Processes Options
Viewed 3825 times since Tue, Jun 12, 2018
Colleague Keyboard Shortcuts
Viewed 6076 times since Thu, Jan 24, 2019
Delete an Assignment Contract
Viewed 5079 times since Fri, Mar 3, 2017
Colleague - Record Delete
Viewed 4252 times since Fri, Feb 15, 2019

Need Help?