Can you access data over the Internet in a local Excel Spreadsheet?

Yes, for both reading and writing.  View the following networking video on how to network to remote data services:

Easy Networking

How to network all products to central service using a fixed IP Address or registered domain name for the Internet.