How to Scrape Websites with Excel

word image 26 - How to Scrape Websites with Excel

Believe it or not, Excel has had the ability to extract data from websites for a long time, at least since Excel 2003. It’s just that web scraping is something most people don’t think of, let alone think of using a spreadsheet program to do the job. But it’s surprisingly easy, and powerful. Steps: 1.

Read More

How to Export Excel Files as Text Files

Txt File

To export text files, execute the following steps. 1. Open an Excel file. 2. On the File tab, click Save As. 3. Click Browse. 4. Select Text (Tab delimited) or CSV (Comma delimited) from the drop-down list. 5. Click Save. 6. Result. A .csv file (comma separated) or a .txt file (tab separated).    

How to Chart Your Data in Excel

word image 8 - How to Chart Your Data in Excel

If you haven’t done this before, you’ll probably be surprised at how easy Excel makes charting your spreadsheets. Say, for example, that in the worksheet we were working on in the previous section that you wanted to chart only the first two columns of data (columns B and C), leaving out column D. This entails

Read More

Get to Know Different Rounding Effects in Excel

The displaying of rounding in Excel 2016

When you work with digits, it’s crucial how you round them. It doesn’t depend on what exactly you are rounding – decimals, thousands, or millions. You can see very different amounts after summing the figures, rounded in different ways: 1. Rounded to an integer: 2. Rounded to two decimal digits: 3. The functions for rounding:

Read More

How to Keep Scraped Data Current in Excel

word image 32 - How to Keep Scraped Data Current in Excel

Here we’re going to learn how to keep our scraped data fresh in Excel. This is a great way to illustrate just how powerful Excel is for data scraping. Even with this, we’re only doing the most basic scraping that Excel can do. Steps: 1. For this example, let’s use a stock information web page

Read More