Data Explorer, on the other hand, neatly lists the tables in a column to the left of your document for one-click import. While you can import HTML tables from "regular" Excel without an add-on, I didn't always find that to be an elegant process. It will import from multiple databases including MySQL, PostgreSQL, Oracle and IBM DB2 as well as Microsoft's own SQL Server, Azure and Access and is also designed to help shape "semi-structured" plain text into a better format for analysis.Įnter a URL and Data Explorer will come back with a list of tables in the Web page select a table and the data will immediately import into Excel. ![]() What's cool: This plug-in handles an impressively large array of data formats such as HTML tables, CSV, XML, Hadoop, Active Directory and, yes, Facebook.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |