Many times we need to get data which is on web (in tabular format) into Excel.
If we do copy-paste, all data is placed in a single column and then we need to go and manually (or thru Data>Text to columns..) edit it.
Instead you can try this.
Take an example of following scorecard of India Srilanka match.
Say you want this data in the excel properly.
-Open a New Workbook
-Data -> Get External Data -> New Web Query
-in the field enter the url given above (or the data you want to import)
-select from: entire page / only tables /only specific tables
-If you like the colour scheme on the web, select from the formatting options
-if you want that the link should not be maintained after import, go to Advanced.. and check "disable data recognition"
The entire data will be placed in the excel sheet. No need to separate it in columns again.
This has benifited me and some of my friends immensely, hope this helps you as well.:cheers: