One of the great advantages of computers is that they can automate repetitive tasks. This is particularly valuable when it comes to extracting the data stored in tables, which can often be a long and boring job when done manually. Several coders have seen the need for a better way of getting at the data stored in website tables, and released products to help out.
'WebTable' is probably one of the oldest applications, and extracts tables from the website directly into plain-text files in either tab separated or comma separated (CSV) form. These text files can then be imported directly into Excel or similar spreadsheet programs.
The 'Newbie' software suite can be used to automate practically any repetitive task. This includes, but is certainly not limited to, extracting HTML tables. Unlike WebTable it requires some technical knowledge, rather than being point-and-click, and so it might not be ideal for people who are unhappy dealing with a learning curve.
Modern websites have a habit of embedding PDF documents into their content, which can be tricky to extract tables from. Luckily there are websites like 'PDF to Excel', which allow you to quickly and simply extract tables from PDF documents. Download the file you require, upload it to the website and the results will be emailed directly to you.