Site/Service that Generates Sortable Spreadsheet of Schools of Interest?

Hi all - My rising junior D is starting to make a list of schools she may be interested in. Is there a site/service (even if requires subscription payment) that allows a student select colleges and populate a sortable Excel (or similar) spreadsheet as they go? Will eventually need to customize, but wondering if could get a spreadsheet started without having to fill in the blanks. The more robust that self-populating data/info, the better, but even fairly limited start would be fine. So far (albeit fairly limited attempts), the sites I’ve seen with college compare functions limit the # of schools, don’t really convert the search into a downloadable/sortable spreadsheet, etc.

If not, no worries. Thanks all!

What variables are you trying to isolate? The closest ones that I can think of are the [IPEDS Data Center](The Integrated Postsecondary Education Data System) and the US News [College Compass](http://www.usnews.com/usnews/store/college_compass.htm?src=homepage&int=a9d609).

Cool, thanks whenhen. I’ll dig around those. Nothing particularly unique soughti in terms of variables. On the CC college compare function for schools that are “pinned,” they have a nice basic range of info on enrollment, gender breakdown, location, admit rate, racial demographics, average test scores, greek system or no, etc. All those are good starting points for a helpful sortable spreadsheet, but I don’t see that as a CC functionality, so looking for an alternative. Tried to do it internally in Naviance, and that does not seem to really work very well either. I bet the US News one has that sort of thing - thanks much!

I suggest using the sorting search tool at collegeboard.org as a means to narrow down your search based on selected parameters…

https://bigfuture.collegeboard.org/college-search?navid=gh-cs

Once you have a list of schools, you can further research each school there directly, but I also recommend looking through the current and past student survey results and rankings available at…

https://colleges.niche.com/rankings/best-colleges/

Good Luck…

Great, thanks WWWard!

So I checked out the college board one. From what I can tell, you can select schools, and then compare up to three across a pretty limited set of variables (and not self-selected variables).

All good, and helpful, and thank you.

I guess I’m looking for a site that allows you to export your search queries/results into a sortable, save-able spreadsheet (e.g. Excel) that can be maintained on one’s one hard drive. I’m wondering if she can find a site/service that has solid (or even robust) search capabilities in terms of data sets/info, and then allows the search results with the list of schools of interest to be downloaded into a spreadsheet not anchored to the particular website/service (so she can edit it/add to it/create own columns/use Excel’s sort functions/etc.)

But failing that, I think maybe that US News College Compass service might well do the trick even if the search/spreadsheet results all stay embedded in its website. Probably unlimited number of schools that can be compared in a sortable spreadsheet format with lots of variables to choose from.

Thanks!

■■■■■■■■■■■■■■■■■■ has all the IPEDS data and can export to a multi-page Excel spreadsheet with lots of data. And it’s free.

You can use the advanced search to drill down on specific search parameters, and you can also compare schools to a preselected set of their peer schools. You can also create your own custom comparison of specific schools, which is great for exporting data on just the schools you intend to research further or apply to.

People are going to think I own the site, I hype it so much. :smiley: But it really is a very valuable tool.

You’re welcome @JMS111 With collegeboard.org, you should at least be able to narrow down your search field. In my daughter’s case, it quickly narrowed down the field of contenders from 3843 colleges down to her starting list of 38 colleges. From that point, with further research there on collegeboard.com and within each school’s own website and with the help of US News and Niche, she again narrowed from 38 to the 14 she plans to finally apply to. Those 14 include 5 reach schools, 5 match schools and 4 safeties.

She actually created her own college matrix on Excel… where she details their median ACT/SAT scores versus hers, semester vs quarter system, acceptance rates, pros vs cons, Niche ranks, US News ranks, rank of her chosen field of study, cost (future), decision (future), whether she applied already or not, whether she sent in test scores already or not, etc. It only took her about an hour to create initially… and now she can update things quickly as she proceeds.

In her case, she simply looked up the data and entered it. Not sure what compass does… but it sounds similar.

Good luck…

Thanks dreamschool, I am going to go over and check that out right now. I appreciate the help very much!

WWWard, thanks again, and yes she is taking the process on much as your D did. Not yet to her first list, but then will need to pare down and then will need to work with and update a spreadsheet as she goes. Hopefully she’ll be as organized as your D is!

Thanks again!

You’re welcome

Dreamschool, checked out the college results website. That’s nifty and allows the downloading of the data to excel - sweet! The underlying data set is 2013-14, so she will need to update as she narrows list, but this gives a great baseline and is the sort of functionality I was hoping for. Thanks again!

Yes, the most current full IPEDS data set is for 2014. Once IPEDS releases the 2015 data officially (some is provisionally available already), the Collegeresults site will be updated.

MurphyBrown - not sure, I’ll start to keep an eye out as we start to plow through this process!

DreamSchool, so do you think the “2014” data is for kids admitted to start the fall of 2015? So it is basically one year lag? Or is the data for kids admitted to start in fall of 2014? All good either way, just wondering.

I don’t think there is, but it’s easy to create a list on another tab in Excel of schools that have minimal or no distribution reqs, and then create a formula that sets the value of a column to Yes or No based on whether a college is in that list.

I took a similar approach when using the CR data set to filter colleges that had high reputations for undergraduate teaching - collected the list manually online and then used a formula.

Actually, I’m thinking now the data is probably for kids entering as freshmen the fall of 2013.

You can buy the entire IPEDS database in excel format from diycollegerankings.com.
She also sells subsets for students looking for athletic programs.

The government’s College Navigator College Navigator - National Center for Education Statistics is very useful and allows one to export results into a spreadsheet.

@JMS111 Yes, the current data reflects 2013 admissions. In the next upcoming dataset, though, IPEDS has changed their data collection on admission characteristics to a winter data collection, so the 2014-2015 IPEDS dataset should reflect 2015 fall admissions.

moved

Thanks DreamSchool! I appreciate the info (I was away for a week or so or would have thanked you sooner!).

If of help to anyone else, here is my understanding based upon the replies above and some digging around:

■■■■■■■■■■■■■■■■■■ and diycollegerankings are both populated primarily with IPEDS data. But diycollegerankings probably updates its product on a more timely basis to reflect “provisional” updates to IPED than the collegeresults website (which I think as of now updates once a year it looks like). The currently released “provisional” and “final release” IPEDS data sets can be found listed here:

https://nces.ed.gov/ipeds/datacenter/login.aspx?gotoReportId=3

So for admissions data for example, the provisional data is out for 2014-15 and the final data is out for 2013-14 (and before).

The upshot, as far as I can tell, is that ■■■■■■■■■■■■■■■■■■ is populated with admissions data for students who entered college in fall 2013 (as Dreamschool helpfully explained), while the diycollegerankings spreadsheet would include admissions data for students who entered in the fall of 2014. That’s b/c college results uses only final data and the DIY website updates its product upon release of provisional data.

Collegeresults would presumably catch up in the spring - its website says it updates its database once a year in the spring.

On the other hand, collegeresults is free. So if choosing between the two at the moment (versus in the spring for example), it may come down to a personal choice of whether the more up-to-date provisional info and the database of all schools provided by DIY is worth the price versus collegeresults, which has admissions data that is a year older and from which you would export data from schools you identify (rather than receive a spreadsheet including all schools). I should note I have not purchased diycollegerankings, at least not yet, so am only giving info based on digging around.

As for the US News & World Report’s College Compass, I found one online discussion of that website from last year that said search results are not exportable or downloadable from College Compass to Excel or otherwise (and apparently a similar product Money Magazine’s website offers also does not allow searches to be downloaded/exported). I’ve emailed the US News folks to ask them directly and will post any response I receive.

Two other options based on helpful replies above:

As far as I can tell, the college board’s search tool limits the schools that can be compared to three at a time, I’m not sure it is exportable, and the data seems limited.

The government’s College Navigator is an interesting option. It appears the admission data available through it is for the college class that entered in 2015 (some of the other data fields are populated by data from 2014 - it varies by data field). So it is the most up to date. You can export search results, and by using the compare function you can export helpful info for more than one school at a time. Even if the number of schools that can be compare dis limited, you can always clear, start a new search, export that data, and cut-and-paste it all into one spreadsheet after exported. But, base don the way the data is exported, there doe snot seem to be a particularly easy way to sort it (unlike collegeresults or diycollegerankings, which allow you to easily sort schools by any of the downloaded variables).

Finally, you can do searches on the IPEDS website itself, including searches using the most recent provisional data sets. You can do the searches across the IPED variables you select. I don;t think the search results are downloadable through. It does appear you can download the entire data set in a specified format for use in statistical applications - it could be that gives you the same sort of thing that diycollegerankings does, but at first blush ta least it looks to me like the data isn’t downloaded in Excel format - could be it is easy to dump into Excel, I don’t know. I probably need to dig there a little more to figure out exactly what you can export from the site.

All told, what I’ve found out is that it does not appear to be real easy to download a sortable spreadsheet of schools with lots of data from the most recent admissions class (entered fall of 2015). Collegeresults is 2013 data at the moment, diycollegerankings is 2014 data, college navigator is 2015 but its output is a little less flexible/easy to sort/manipulate, college board is limited in a number of ways, and US News’ College Compass does not allow downloading of sortable spreadsheets at all it appears.

Hope that makes sense and helps someone - maybe just to decide the best way is the old-fashioned one of creating one’s own spreadsheet and filling in the data one cares about most by hand! Thanks very much all!