Excel University Blog

Read on for in-depth articles, tutorials, and videos. Search or browse for specific topics. Be sure to subscribe if you'd like to be notified when we write something new.

Web Browser

Import Web Data by Jeff Lenning

Get & Transform: An Alternative to Excel’s Web Browser

By Jeff Lenning | July 7, 2016 |

Excel has a built-in web browser that can be used to view web pages and import selected web data. This browser worked well for many years, but, recently, script errors began appearing on some pages. This makes it challenging to import data from some web pages, and frustrates users. The good news is that we can…

Read More

Pull External Data into Excel

By Jeff Lenning | March 28, 2013 |

Often, we use Excel to summarize detail that comes from some other program or accounting system. There are essentially three ways that I am aware of to get data from another program into a destination Excel worksheet, I’ll nickname them: Copy/Paste Pull Push Copy/Paste The Copy/Paste method is probably the most common.  It is when…

Read More