To use the Columbia preferred/contracted rates, attendees need to first register here: https://www.worldtravelinc.com/columbia.visitors.portal
Once registered, you could log in to search for hotels nearby Columbia University (e.g., by putting 10027 as the zip code). See the screenshot below.
The most recommended hotels for visitors to Columbia University are Lucerne, Arthouse, Belleclaire, and Aloft. See the screenshot below.