US Election results in Excel


Office for Mere Mortals
Your beginners guide to the secrets of Microsoft Office
Invalid email address
Tips and help for Word, Excel, PowerPoint and Outlook from Microsoft Office experts.  Give it a try. You can unsubscribe at any time.  Office for Mere Mortals has been running for over 20 years, we've never, ever revealed or sold subscriber details.  Privacy policy

If you’re interested in the hard numbers about the 2016 US election, David Wasserman @redistrict has done the work for you.  Channel your inner ‘Nate Silver’ <g>.

Go to https://docs.google.com/spreadsheets/d/133Eb4qQmOxNvtesw2hdVns073R68EZx4SfCnP4IGQf8/htmlview?sle=true#gid=19 to see a ‘read only’ Google Docs worksheet showing the state-by-state results.

us election results in excel 11461 - US Election results in Excel

Not visible above are columns with the total number of votes cast in both 2012 and 2016.

To get a Google worksheet into Excel is simple.

Just select the cells in the browser view of the worksheet, copy, then switch to Excel and paste.

This will copy the visible numbers, not any underlying cell formulas.  Any cell colors are also lost.

Alternatively, you could use Data | Get External Data | From Web and enter the web link.  This will grab the entire online worksheet.

subs profile e1563205311409 - US Election results in Excel
Latest news & secrets of Microsoft Office

Microsoft Office experts give you tips and help for Word, Excel, PowerPoint and Outlook.

Give it a try. You can unsubscribe at any time.  Office Watch has been running for over 20 years, we've never, ever revealed or sold subscriber details.  Privacy policy
Invalid email address