Setting up the Web query is a fairly simple process and eliminates the need for writing code or copying and pasting Web data into your spreadsheet. How To Automate a Table in Word Using Excel.