This is a useful option, if you are collecting this data for the whole site by going from page and page and performing steps 1 to 3 again and again. 4. Now what?

The free online tool called import.io (pronounced import-eye-oh) will let you extract large amounts of data from a web page into an Excel spreadsheet. For example, you could go to an estate agent's ...

Excel filters help you find exactly what you want, no matter how big your spreadsheet database is. Here's how to set number, text and data filters.

If you want to parse strings such as "First Last" into separate columns, you don't need to use fancy formulas. Excel has a tool that makes the job a snap. In “Save time by using Excel’s Left ...