{"id":976,"date":"2011-12-29T01:37:14","date_gmt":"2011-12-28T17:37:14","guid":{"rendered":"http:\/\/blog.quickschools.com\/?p=976"},"modified":"2018-09-21T00:56:45","modified_gmt":"2018-09-21T07:56:45","slug":"importing-studentsteachers-from-excel","status":"publish","type":"post","link":"https:\/\/blog.quickschools.com\/2011\/12\/29\/importing-studentsteachers-from-excel\/","title":{"rendered":"Importing Students\/Teachers from Excel"},"content":{"rendered":"<div id=\"bsf_rt_marker\"><\/div><p>When getting started with <a title=\"Powerfully Simple School Management\" href=\"http:\/\/www.quickschools.com\">QuickSchools<\/a>, you have the option of importing student and teacher information via Excel. We currently do not support importing of historical information, like grades, attendance and report cards. Here are some videos that describe how to create\/import student records:<\/p>\n<p style=\"text-align:center;\"><em><div class=\"jetpack-video-wrapper\"><span class=\"embed-youtube\" style=\"text-align:center; display: block;\"><iframe loading=\"lazy\" class=\"youtube-player\" width=\"809\" height=\"456\" src=\"https:\/\/www.youtube.com\/embed\/5MqWWhjTmTY?version=3&#038;rel=1&#038;showsearch=0&#038;showinfo=1&#038;iv_load_policy=1&#038;fs=1&#038;hl=en-US&#038;autohide=2&#038;wmode=transparent\" allowfullscreen=\"true\" style=\"border:0;\" sandbox=\"allow-scripts allow-same-origin allow-popups allow-presentation allow-popups-to-escape-sandbox\"><\/iframe><\/span><\/div><\/em><\/p>\n<p style=\"text-align:center;\"><a title=\"QuickSchools on YouTube\" href=\"http:\/\/www.youtube.com\/quickschools\" target=\"_blank\" rel=\"noopener\">Watch more videos on our YouTube channel<\/a><\/p>\n<p>If you already have your data in Excel format, you can already import your data by mapping the columns in your Excel file with fields in the database. However, if you want to save time with the mappings, you can rename the column headers, or use one of our sample files below:<\/p>\n<ul>\n<li><a title=\"QuickSchools Sample Student Excel Import File\" href=\"https:\/\/dl.dropbox.com\/s\/etd9iakdkc4fjg3\/Student%20Import%20Template.xlsx?dl=0\">SampleStudentImport.xls<\/a><\/li>\n<li><a title=\"QuickSchools Sample Teacher Excel Import File\" href=\"https:\/\/dl.dropbox.com\/s\/xrz2kusq22j5jb5\/Teacher%20Import%20Template.xlsx?dl=0\">SampleTeacherImport.xls<\/a><\/li>\n<\/ul>\n<p>One thing to note:<\/p>\n<p>If you notice extra fields in the mapping dropdown, which you do not see on screen (like \u201cEPF\u201d, and \u201cSOCSO\u201d), most of these are actually deprecated (i.e. old) fields which we no longer support. These fields currently still exists in the database, but they will be removed in a future release. Other fields like \u201cRace\u201d and \u201cReligion\u201d are hidden fields, which we can activate if needed. For the complete list of active\/valid fields for import, please refer to the sample files above.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>When getting started with QuickSchools, you have the option of importing student and teacher information via Excel. We currently do not support importing of historical information, like grades, attendance and report cards. Here are some videos that describe how to create\/import student records: Watch more videos on our YouTube channel If you already have your [&hellip;]<\/p>\n","protected":false},"author":5617131,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_coblocks_attr":"","_coblocks_dimensions":"","_coblocks_responsive_height":"","_coblocks_accordion_ie_support":"","_crdt_document":"","jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"_wpas_customize_per_network":false},"categories":[28883],"tags":[],"class_list":["post-976","post","type-post","status-publish","format-standard","hentry","category-tips-and-tutorials"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Importing Students\/Teachers from Excel - QuickSchools Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/blog.quickschools.com\/2011\/12\/29\/importing-studentsteachers-from-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Importing Students\/Teachers from Excel - QuickSchools Blog\" \/>\n<meta property=\"og:description\" content=\"When getting started with QuickSchools, you have the option of importing student and teacher information via Excel. We currently do not support importing of historical information, like grades, attendance and report cards. Here are some videos that describe how to create\/import student records: Watch more videos on our YouTube channel If you already have your [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/blog.quickschools.com\/2011\/12\/29\/importing-studentsteachers-from-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"QuickSchools Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/quickschools\" \/>\n<meta property=\"article:published_time\" content=\"2011-12-28T17:37:14+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-09-21T07:56:45+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/i0.wp.com\/blog.quickschools.com\/wp-content\/uploads\/2013\/07\/quickschoolslogo.jpg?fit=1037%2C263&ssl=1\" \/>\n\t<meta property=\"og:image:width\" content=\"1037\" \/>\n\t<meta property=\"og:image:height\" content=\"263\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Azroy Kandan\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@quickschools\" \/>\n<meta name=\"twitter:site\" content=\"@quickschools\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Azroy Kandan\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/blog.quickschools.com\\\/2011\\\/12\\\/29\\\/importing-studentsteachers-from-excel\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/blog.quickschools.com\\\/2011\\\/12\\\/29\\\/importing-studentsteachers-from-excel\\\/\"},\"author\":{\"name\":\"Azroy Kandan\",\"@id\":\"https:\\\/\\\/blog.quickschools.com\\\/#\\\/schema\\\/person\\\/f0e658eb86a09d8b261f3229f1dfb8d5\"},\"headline\":\"Importing Students\\\/Teachers from Excel\",\"datePublished\":\"2011-12-28T17:37:14+00:00\",\"dateModified\":\"2018-09-21T07:56:45+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/blog.quickschools.com\\\/2011\\\/12\\\/29\\\/importing-studentsteachers-from-excel\\\/\"},\"wordCount\":208,\"commentCount\":4,\"publisher\":{\"@id\":\"https:\\\/\\\/blog.quickschools.com\\\/#organization\"},\"articleSection\":[\"Tips and Tutorials\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/blog.quickschools.com\\\/2011\\\/12\\\/29\\\/importing-studentsteachers-from-excel\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/blog.quickschools.com\\\/2011\\\/12\\\/29\\\/importing-studentsteachers-from-excel\\\/\",\"url\":\"https:\\\/\\\/blog.quickschools.com\\\/2011\\\/12\\\/29\\\/importing-studentsteachers-from-excel\\\/\",\"name\":\"Importing Students\\\/Teachers from Excel - QuickSchools Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/blog.quickschools.com\\\/#website\"},\"datePublished\":\"2011-12-28T17:37:14+00:00\",\"dateModified\":\"2018-09-21T07:56:45+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/blog.quickschools.com\\\/2011\\\/12\\\/29\\\/importing-studentsteachers-from-excel\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/blog.quickschools.com\\\/2011\\\/12\\\/29\\\/importing-studentsteachers-from-excel\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/blog.quickschools.com\\\/2011\\\/12\\\/29\\\/importing-studentsteachers-from-excel\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/blog.quickschools.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Importing Students\\\/Teachers from Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/blog.quickschools.com\\\/#website\",\"url\":\"https:\\\/\\\/blog.quickschools.com\\\/\",\"name\":\"QuickSchools Blog\",\"description\":\"Powerfully simply school management\",\"publisher\":{\"@id\":\"https:\\\/\\\/blog.quickschools.com\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/blog.quickschools.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/blog.quickschools.com\\\/#organization\",\"name\":\"QuickSchools Blog\",\"url\":\"https:\\\/\\\/blog.quickschools.com\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/blog.quickschools.com\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/i0.wp.com\\\/blog.quickschools.com\\\/wp-content\\\/uploads\\\/2024\\\/03\\\/SQUARE-LOGO-1.png?fit=829%2C914&ssl=1\",\"contentUrl\":\"https:\\\/\\\/i0.wp.com\\\/blog.quickschools.com\\\/wp-content\\\/uploads\\\/2024\\\/03\\\/SQUARE-LOGO-1.png?fit=829%2C914&ssl=1\",\"width\":829,\"height\":914,\"caption\":\"QuickSchools Blog\"},\"image\":{\"@id\":\"https:\\\/\\\/blog.quickschools.com\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/quickschools\",\"https:\\\/\\\/x.com\\\/quickschools\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/quickschools.com\\\/\",\"https:\\\/\\\/www.instagram.com\\\/quickschools\\\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/blog.quickschools.com\\\/#\\\/schema\\\/person\\\/f0e658eb86a09d8b261f3229f1dfb8d5\",\"name\":\"Azroy Kandan\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b50a7d7d1611b36586907aace6a62c5697796a5fcd268e5070502f2814030f79?s=96&d=identicon&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b50a7d7d1611b36586907aace6a62c5697796a5fcd268e5070502f2814030f79?s=96&d=identicon&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b50a7d7d1611b36586907aace6a62c5697796a5fcd268e5070502f2814030f79?s=96&d=identicon&r=g\",\"caption\":\"Azroy Kandan\"},\"sameAs\":[\"http:\\\/\\\/www.azroykandan.com\"],\"url\":\"https:\\\/\\\/blog.quickschools.com\\\/author\\\/gokun2\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Importing Students\/Teachers from Excel - QuickSchools Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/blog.quickschools.com\/2011\/12\/29\/importing-studentsteachers-from-excel\/","og_locale":"en_US","og_type":"article","og_title":"Importing Students\/Teachers from Excel - QuickSchools Blog","og_description":"When getting started with QuickSchools, you have the option of importing student and teacher information via Excel. We currently do not support importing of historical information, like grades, attendance and report cards. Here are some videos that describe how to create\/import student records: Watch more videos on our YouTube channel If you already have your [&hellip;]","og_url":"https:\/\/blog.quickschools.com\/2011\/12\/29\/importing-studentsteachers-from-excel\/","og_site_name":"QuickSchools Blog","article_publisher":"https:\/\/www.facebook.com\/quickschools","article_published_time":"2011-12-28T17:37:14+00:00","article_modified_time":"2018-09-21T07:56:45+00:00","og_image":[{"width":1037,"height":263,"url":"https:\/\/i0.wp.com\/blog.quickschools.com\/wp-content\/uploads\/2013\/07\/quickschoolslogo.jpg?fit=1037%2C263&ssl=1","type":"image\/jpeg"}],"author":"Azroy Kandan","twitter_card":"summary_large_image","twitter_creator":"@quickschools","twitter_site":"@quickschools","twitter_misc":{"Written by":"Azroy Kandan","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/blog.quickschools.com\/2011\/12\/29\/importing-studentsteachers-from-excel\/#article","isPartOf":{"@id":"https:\/\/blog.quickschools.com\/2011\/12\/29\/importing-studentsteachers-from-excel\/"},"author":{"name":"Azroy Kandan","@id":"https:\/\/blog.quickschools.com\/#\/schema\/person\/f0e658eb86a09d8b261f3229f1dfb8d5"},"headline":"Importing Students\/Teachers from Excel","datePublished":"2011-12-28T17:37:14+00:00","dateModified":"2018-09-21T07:56:45+00:00","mainEntityOfPage":{"@id":"https:\/\/blog.quickschools.com\/2011\/12\/29\/importing-studentsteachers-from-excel\/"},"wordCount":208,"commentCount":4,"publisher":{"@id":"https:\/\/blog.quickschools.com\/#organization"},"articleSection":["Tips and Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/blog.quickschools.com\/2011\/12\/29\/importing-studentsteachers-from-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/blog.quickschools.com\/2011\/12\/29\/importing-studentsteachers-from-excel\/","url":"https:\/\/blog.quickschools.com\/2011\/12\/29\/importing-studentsteachers-from-excel\/","name":"Importing Students\/Teachers from Excel - QuickSchools Blog","isPartOf":{"@id":"https:\/\/blog.quickschools.com\/#website"},"datePublished":"2011-12-28T17:37:14+00:00","dateModified":"2018-09-21T07:56:45+00:00","breadcrumb":{"@id":"https:\/\/blog.quickschools.com\/2011\/12\/29\/importing-studentsteachers-from-excel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/blog.quickschools.com\/2011\/12\/29\/importing-studentsteachers-from-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/blog.quickschools.com\/2011\/12\/29\/importing-studentsteachers-from-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/blog.quickschools.com\/"},{"@type":"ListItem","position":2,"name":"Importing Students\/Teachers from Excel"}]},{"@type":"WebSite","@id":"https:\/\/blog.quickschools.com\/#website","url":"https:\/\/blog.quickschools.com\/","name":"QuickSchools Blog","description":"Powerfully simply school management","publisher":{"@id":"https:\/\/blog.quickschools.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/blog.quickschools.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/blog.quickschools.com\/#organization","name":"QuickSchools Blog","url":"https:\/\/blog.quickschools.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/blog.quickschools.com\/#\/schema\/logo\/image\/","url":"https:\/\/i0.wp.com\/blog.quickschools.com\/wp-content\/uploads\/2024\/03\/SQUARE-LOGO-1.png?fit=829%2C914&ssl=1","contentUrl":"https:\/\/i0.wp.com\/blog.quickschools.com\/wp-content\/uploads\/2024\/03\/SQUARE-LOGO-1.png?fit=829%2C914&ssl=1","width":829,"height":914,"caption":"QuickSchools Blog"},"image":{"@id":"https:\/\/blog.quickschools.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/quickschools","https:\/\/x.com\/quickschools","https:\/\/www.linkedin.com\/company\/quickschools.com\/","https:\/\/www.instagram.com\/quickschools\/"]},{"@type":"Person","@id":"https:\/\/blog.quickschools.com\/#\/schema\/person\/f0e658eb86a09d8b261f3229f1dfb8d5","name":"Azroy Kandan","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/b50a7d7d1611b36586907aace6a62c5697796a5fcd268e5070502f2814030f79?s=96&d=identicon&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/b50a7d7d1611b36586907aace6a62c5697796a5fcd268e5070502f2814030f79?s=96&d=identicon&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/b50a7d7d1611b36586907aace6a62c5697796a5fcd268e5070502f2814030f79?s=96&d=identicon&r=g","caption":"Azroy Kandan"},"sameAs":["http:\/\/www.azroykandan.com"],"url":"https:\/\/blog.quickschools.com\/author\/gokun2\/"}]}},"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_likes_enabled":true,"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/pu3aW-fK","_links":{"self":[{"href":"https:\/\/blog.quickschools.com\/wp-json\/wp\/v2\/posts\/976","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.quickschools.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.quickschools.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.quickschools.com\/wp-json\/wp\/v2\/users\/5617131"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.quickschools.com\/wp-json\/wp\/v2\/comments?post=976"}],"version-history":[{"count":9,"href":"https:\/\/blog.quickschools.com\/wp-json\/wp\/v2\/posts\/976\/revisions"}],"predecessor-version":[{"id":4311,"href":"https:\/\/blog.quickschools.com\/wp-json\/wp\/v2\/posts\/976\/revisions\/4311"}],"wp:attachment":[{"href":"https:\/\/blog.quickschools.com\/wp-json\/wp\/v2\/media?parent=976"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.quickschools.com\/wp-json\/wp\/v2\/categories?post=976"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.quickschools.com\/wp-json\/wp\/v2\/tags?post=976"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}