{"id":665,"date":"2021-06-10T22:22:25","date_gmt":"2021-06-11T02:22:25","guid":{"rendered":"https:\/\/pubproof.studentclearinghouse.org\/kbsandbox\/?p=665"},"modified":"2025-06-10T08:49:33","modified_gmt":"2025-06-10T12:49:33","slug":"analysis-ready-file-templates","status":"publish","type":"ht_kb","link":"https:\/\/help.studentclearinghouse.org\/pdp\/knowledge-base\/analysis-ready-file-templates\/","title":{"rendered":"Analysis-Ready File Templates"},"content":{"rendered":"<p>You can use the following templates as guides to help you review your analysis-ready (AR) file. The templates are in Microsoft Excel format. Click an icon to download the file.<\/p>\n<div class=\"info\">\n<p><strong>Note:<\/strong> Depending on your permissions\/role with PDP, you will receive either identified or de-identified versions of the AR files. View the appropriate templates below.<\/p>\n<\/div>\n<h2>Identified AR File Templates<\/h2>\n<table style=\"border-collapse: collapse; width: 450px; background-color: #ffffff !important;\">\n<tbody>\n<tr>\n<th colspan=\"3\">These files are sent to data providers\/institutions.<\/th>\n<\/tr>\n<tr>\n<td style=\"width: 150px; text-align: center; vertical-align: top;\">\n<p style=\"line-height: 15pt; margin-top: 20px; margin-bottom: 20px;\"><a href=\"https:\/\/help.studentclearinghouse.org\/pdp\/wp-content\/uploads\/course_analysis_ready_file_template_Identified_01_27_25.xlsx\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1001 size-full\" style=\"margin-bottom: 7px !important;\" src=\"https:\/\/help.studentclearinghouse.org\/pdp\/wp-content\/uploads\/2021\/07\/icon-xls.png\" alt=\"\" width=\"75\" height=\"75\" \/><\/a><a href=\"https:\/\/help.studentclearinghouse.org\/pdp\/wp-content\/uploads\/course_analysis_ready_file_template_Identified_01_27_25.xlsx\"><strong>Course AR File Template<\/strong><\/a><\/p>\n<\/td>\n<td style=\"width: 150px; text-align: center; vertical-align: top;\">\n<p style=\"line-height: 15pt; margin-top: 20px; margin-bottom: 20px;\"><a href=\"https:\/\/help.studentclearinghouse.org\/pdp\/wp-content\/uploads\/cohort_analysis_ready_file_template_Identified_01-27-25.xlsx\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1001 size-full\" style=\"margin-bottom: 7px !important;\" src=\"https:\/\/help.studentclearinghouse.org\/pdp\/wp-content\/uploads\/2021\/07\/icon-xls.png\" alt=\"\" width=\"75\" height=\"75\" \/><\/a><a href=\"https:\/\/help.studentclearinghouse.org\/pdp\/wp-content\/uploads\/cohort_analysis_ready_file_template_Identified_01-27-25.xlsx\" rel=\"noopener\"><strong>Cohort AR<br \/>\nFile Template<\/strong><\/a><\/p>\n<\/td>\n<td style=\"width: 150px; text-align: center; vertical-align: top;\">\n<p style=\"line-height: 15pt; margin-top: 20px; margin-bottom: 20px;\"><a href=\"https:\/\/help.studentclearinghouse.org\/pdp\/wp-content\/uploads\/financialaid_analysis_ready_file_template.xlsx\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1001 size-full\" style=\"margin-bottom: 7px !important;\" src=\"https:\/\/help.studentclearinghouse.org\/pdp\/wp-content\/uploads\/2021\/07\/icon-xls.png\" alt=\"\" width=\"75\" height=\"75\" \/><\/a><a href=\"https:\/\/help.studentclearinghouse.org\/pdp\/wp-content\/uploads\/financialaid_analysis_ready_file_template.xlsx\" rel=\"noopener\"><strong>Financial Aid AR<br \/>\nFile Template<\/strong><\/a><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2>De-identified AR File Templates<\/h2>\n<table style=\"border-collapse: collapse; width: 450px; background-color: #ffffff !important;\">\n<tbody>\n<tr>\n<th colspan=\"2\">These files are sent to third parties.<\/th>\n<\/tr>\n<tr>\n<td style=\"width: 225px; text-align: center; vertical-align: top;\">\n<p style=\"line-height: 15pt; margin-top: 20px; margin-bottom: 20px;\"><a href=\"https:\/\/help.studentclearinghouse.org\/pdp\/wp-content\/uploads\/course_analysis_ready_file_template_Deidentified_01_27_25.xlsx\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1001 size-full\" style=\"margin-bottom: 7px !important;\" src=\"https:\/\/help.studentclearinghouse.org\/pdp\/wp-content\/uploads\/2021\/07\/icon-xls.png\" alt=\"\" width=\"75\" height=\"75\" \/><\/a><a href=\"https:\/\/help.studentclearinghouse.org\/pdp\/wp-content\/uploads\/course_analysis_ready_file_template_Deidentified_01_27_25.xlsx\"><strong>Course AR File Template<\/strong><\/a><\/p>\n<\/td>\n<td style=\"width: 225px; text-align: center; vertical-align: top;\">\n<p style=\"line-height: 15pt; margin-top: 20px; margin-bottom: 20px;\"><a href=\"https:\/\/help.studentclearinghouse.org\/pdp\/wp-content\/uploads\/cohort_analysis_ready_file_template_Deidentified_01_27_25.xlsx\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1001 size-full\" style=\"margin-bottom: 7px !important;\" src=\"https:\/\/help.studentclearinghouse.org\/pdp\/wp-content\/uploads\/2021\/07\/icon-xls.png\" alt=\"\" width=\"75\" height=\"75\" \/><\/a><a href=\"https:\/\/help.studentclearinghouse.org\/pdp\/wp-content\/uploads\/cohort_analysis_ready_file_template_Deidentified_01_27_25.xlsx\" rel=\"noopener\"><strong>Cohort AR<br \/>\nFile Template<\/strong><\/a><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Use these file templates as guides to help you review your Analysis-Ready (AR) file.<\/p>\n","protected":false},"author":6,"menu_order":50,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":"","_links_to":"","_links_to_target":""},"ht-kb-category":[57,78],"ht-kb-tag":[],"class_list":["post-665","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-about-ar-files-their-elements","ht_kb_category-institutional-researchers"],"_links":{"self":[{"href":"https:\/\/help.studentclearinghouse.org\/pdp\/wp-json\/wp\/v2\/ht-kb\/665","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/help.studentclearinghouse.org\/pdp\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/help.studentclearinghouse.org\/pdp\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/help.studentclearinghouse.org\/pdp\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/help.studentclearinghouse.org\/pdp\/wp-json\/wp\/v2\/comments?post=665"}],"version-history":[{"count":52,"href":"https:\/\/help.studentclearinghouse.org\/pdp\/wp-json\/wp\/v2\/ht-kb\/665\/revisions"}],"predecessor-version":[{"id":16631,"href":"https:\/\/help.studentclearinghouse.org\/pdp\/wp-json\/wp\/v2\/ht-kb\/665\/revisions\/16631"}],"wp:attachment":[{"href":"https:\/\/help.studentclearinghouse.org\/pdp\/wp-json\/wp\/v2\/media?parent=665"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/help.studentclearinghouse.org\/pdp\/wp-json\/wp\/v2\/ht-kb-category?post=665"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/help.studentclearinghouse.org\/pdp\/wp-json\/wp\/v2\/ht-kb-tag?post=665"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}