Web Query |
Making a web query from Microsoft Excel can be done following the next steps:
•Start Microsoft Excel.
•Open a sheet.
•Place the cursor where the data has to appear.
•Select in the menu ‘Data’ -> ‘Retrieve external data’ -> ‘New web query’.
•Fill out the URL of the application.
•Log in.
•Open the screen where you would like to copy data from.
•Select ‘1 .000 rows per page’ in the search filter to maximize the results on one page.
•Select the correct data.
•Select the arrow in the upper left corner, next to the search results. The arrow changes in a check mark.
•Select the Import button.