Exporting Reports

​

Before You Start

You’ll need:

• At least one generated report with data to export
• Appropriate user permissions to access the report type
• A program, course, instructor, or job selected in the report settings

​

Available Export Formats

Mapademics currently supports Excel (.xlsx) format for all report exports. This format provides:

• Formatted data with proper column headers and styling
• Multiple sheets for complex reports (like Skills Gap Analysis)
• Professional formatting including currency, percentage, and number formats
• Structured data that preserves relationships between metrics

​

Exporting Program Reports

Program reports offer the most comprehensive export options, with different formats depending on the report type selected.

​

Occupation Crosswalk Export

When viewing an Occupation Crosswalk report:

1. Select your program from the Program dropdown in the report settings
2. Choose “Occupation Crosswalk” as your report type
3. Wait for data to load completely
4. Click the “Export to Excel” button in the top-right corner of the report

What gets exported:

• Job titles and descriptions
• Median wage data (formatted as currency)
• Total employment figures (formatted with commas)
• Employment change percentages (2023-33 projections)
• Annual job opening rates

​

Skills Gap Analysis Export

The Skills Gap Analysis export creates multiple Excel sheets—one for each occupation analyzed:

1. Configure your report settings with the desired program
2. Select “Skills Gap Analysis” as the report type
3. Click “Export to Excel” once data has loaded

Export structure:

• Sheet per occupation: Each Standard Occupational Classification (SOC) gets its own sheet
• Skills breakdown: Lists all required skills with relevance levels
• Course contributions: Shows how each course contributes to skill development
• Proficiency tracking: Displays acquired vs. required proficiency levels (as percentages)

​

Course Breakdown Export

Course Breakdown exports show how individual courses contribute to program objectives:

1. Select your program and choose “Course Breakdown” report type
2. Click “Export to Excel” when data is ready

Export contents:

• Program summary row: Overall skill proficiency levels across all courses
• Individual course rows: Each course’s contribution to specific skills
• Skill columns: Required proficiency levels shown in column headers
• Percentage values: All contributions displayed as percentages for easy comparison

​

Exporting Course Reports

Course-level exports focus on individual course analysis and section comparisons.

​

How to Export Course Reports

1. Navigate to the Course Reports tab in the Reports section
2. Select a specific course from the dropdown menu
3. Wait for course data and visualizations to load
4. Click “Export to Excel” in the report header

Current course export features:

• Section-by-section skills analysis
• Instructor assignments and contributions
• Skills coverage across all course sections
• Heat map data for skills distribution

​

Exporting Instructor Reports

Instructor reports provide insights into individual faculty members’ course contributions and skills coverage.

​

Generating Instructor Exports

1. Go to the Instructor Reports tab
2. Choose an instructor from the selection dropdown
3. Review the loaded report data
4. Click “Export to Excel” to download

Planned instructor export contents:

• All courses taught by the selected instructor
• Skills coverage across instructor’s course sections
• Student outcome contributions
• Teaching load and skills diversity metrics

​

Exporting Skills Reports

Skills reports allow you to analyze how specific skills are distributed across your programs and courses.

​

Skills Report Export Process

1. Access the Skills Reports tab
2. Select one or more skills you want to analyze
3. Choose your report type:
   • Program Skill Contribution: Shows how selected programs contribute to skill development
   • Course Skill Contribution: Displays individual course contributions to skills
4. Select the entities (programs or courses) to include in your analysis
5. Click “Export to Excel” once data has loaded

​

Exporting Job Reports

Job market reports help you understand employer demands and skills gaps in your local job market.

​

Job Report Export Steps

1. Open the Job Reports section
2. Configure your report settings:
   • Select programs or credentials to compare against job requirements
   • Choose specific employers or job categories
   • Set geographic or industry filters if available
3. Let the job market analysis complete
4. Use the “Export to Excel” button to download results

​

Understanding Export File Structure

​

Single-Sheet Exports

Simple reports like Occupation Crosswalk create single Excel sheets with:

• Bold header rows for easy identification
• Properly formatted data (currency, percentages, numbers)
• Descriptive column names that explain the metrics

​

Multi-Sheet Exports

Complex reports like Skills Gap Analysis create multiple sheets where:

• Each sheet represents a different occupation or analysis dimension
• Sheet names match the occupation codes or entity names being analyzed
• Consistent column structure across all sheets for easy comparison
• Professional formatting maintained throughout all sheets

​

Best Practices for Report Exports

​

Timing Your Exports

• Wait for complete data loading before exporting to ensure all information is included
• Export immediately after generating reports for the most current data
• Re-export if you change report settings to capture the updated analysis

​

File Management

• Use descriptive filenames - the system automatically generates meaningful names
• Organize exports by date if you’re tracking changes over time
• Keep exports in dedicated folders for easy access during accreditation or planning cycles

​

Data Validation

• Review exported data in Excel before sharing with stakeholders
• Check for completeness by comparing export contents with on-screen reports
• Verify formatting appears correctly across all sheets and columns

​

Sharing and Collaboration

​

Sharing Exported Reports

Exported Excel files are standard .xlsx format, making them easy to:

• Email to colleagues and stakeholders
• Upload to shared drives or cloud storage
• Import into other analysis tools like Power BI or Tableau
• Include in accreditation reports and institutional documentation

​

Collaborative Analysis

Use exported data to:

• Create custom visualizations in Excel or other tools
• Combine with external datasets for comprehensive analysis
• Generate summary reports for different audience needs
• Archive historical data for trend analysis over time

​

Troubleshooting Export Issues

​

Export Button Is Disabled

Possible causes:

• Report data is still loading
• No data available for the selected configuration
• Network connectivity issues preventing data retrieval

Solutions:

1. Wait for data loading to complete completely
2. Verify your selections in the report settings
3. Refresh the page and reconfigure your report
4. Check your internet connection and try again

​

Export File Won’t Open

Common issues:

• File may be corrupted during download
• Excel version compatibility problems
• Antivirus software blocking the download

Solutions:

1. Try downloading again from the same report
2. Use a different browser if the issue persists
3. Check your Downloads folder for partial or corrupted files
4. Contact your IT support if Excel won’t open the file

​

Related Tasks

• Program Reports - Learn how to generate comprehensive program analyses
• Course Reports - Understand course-level reporting capabilities
• Skills Reports - Explore skills distribution and mapping analysis
• Job Reports - Analyze job market demands and requirements