You can use the Get External Data feature of Excel to do this. I do not know your exact requirement but the simple way to do this is to use Excel feature of pulling external data and specify your SP and range where you want to write data.
I can help you to do this. Let me know what version of Excel you have.