Skip to main content
Skip to main content
Microsoft 365

Exploring Manhattan with Power Map for Excel

Power Map NYC 1

Today’s post was written by Daniel Witriol, senior program manager on the Excel Power Map team.

New York is an iconic city with a rich history of innovation. I have a lot of family in New York and grew up visiting the city. Now that I’m living in Seattle, thousands of miles away, I don’t get to visit very often. However, I thought it might be fun to see if I could explore New York from the comfort of my desk using Excel. Through a little Internet searching, I discovered New York City’s “PLUTO” dataset. Created by the Department of City Planning, the PLUTO dataset includes information on every building in the city—more than 500,000 in total. I downloaded the dataset as CSV files and using Power Query for Excel, imported the data directly into Excel. I focused on the data file containing the borough of Manhattan as I’m most familiar with it. The dataset has a separate row for each building complex in the city and about 80 columns of information for each one.

Power Map NYC 2

I started by plotting a point at the address of each building. I quickly ended up with a view that looked about right, complete with a rectangular-shaped hole where Central Park is located.

Power Map NYC 3

The column containing the number of floors immediately caught my attention, I plugged the column into Power Map and told it to plot the number of floors as the bar height. Now I had something truly resembling the city.

Power Map NYC 4

Next, I dragged ‘Year Built’ from the list of fields into Power Map’s “Time” box. I could press the Play button and watch the city grow in front of my eyes. This dataset only includes buildings that are still standing, so it’s not a complete picture, but still very impressive to watch.

I then decided to experiment and plot the bar heights by the amount of Office space rather than the number of floors, and a totally different picture emerged.

Power Map NYC 5

This is a really fun dataset to play with. You can color code by different districts, or use data cards to see who owns buildings, or plot the city’s landmarks with the “Landmark” field.

Check out the video for yourself to see a brief tour I made with Power Map exploring the city.

Of course the best experience is truly to interact with it yourself. I encourage you to give it a try, you can download the Excel file here.

Enjoy!

—Daniel Witriol

——————————-

Power Map for Excel is available with any Office 365 subscription that includes Office desktop apps.  To use Power Map, open Excel and go to Insert > Map.

Learn about all the powerful analytics and visualization features in Excel and take your analysis further by sharing and collaborating on business insights with colleagues using Power BI.

You may also like these articles

Image for: View live transcripts in Microsoft Teams meetings, track Excel changes, and increase hybrid work security—here’s what’s new to Microsoft 365

View live transcripts in Microsoft Teams meetings, track Excel changes, and increase hybrid work security—here’s what’s new to Microsoft 365

This month, we're announcing some top requested features like tracking changes in Excel and live transcriptions in Teams, as well as some soon-to-be-favorites like meeting recaps, turning Word documents in presentations, and more.

Image for: Family hanging out at home baking holiday cookies using Lenovo Ideapad Flex 3 to make holiday cards

New apps and features in Microsoft 365 for individuals and families this fall

Since we introduced Microsoft 365 to individuals and families earlier this year, we have continued to deliver new innovations across our apps and services to help you and your family save time and stay connected. See what’s new below. Locate your loved ones and build better driving habits with Microsoft Family Safety Stay connected even…

Image for: A man is using his Lenovo laptop like a tablet while sitting in a comfortable chair in a Modern office setting

Microsoft Productivity Score and personalized experiences—here’s what’s new to Microsoft 365 in October

As I reflect on an action-packed few weeks, I’m struck by how much work has evolved in these past months. And I know our customers feel it too. After quickly moving to remote and hybrid work models this spring, organizations are now seeking sustainable ways to help people collaborate, be productive, and prioritize their wellbeing…