7

I found this site with solar system moon orbit data: Table of moons in solar system.

I ran that through the http://import.io site and it only came up with Jupiter data. Is there a more comprehensive tool that will identify multiple tables and import into a single table?
(I also tried the import.io desktop app).

  • 2
    ScraperWiki and Kimono are similar-ish to import.io – Mark Silverberg Sep 30 '15 at 0:34
  • Copying the HTML table to Excel does the job too and doesn't require too too much clean up (if you dont expect the data to update often) – Mark Silverberg Sep 30 '15 at 0:35
  • TableTools2 for Firefox can copy tables directly. – Anton Tarasenko May 29 '16 at 10:40
3

Data Scraping Studio can do this and it's free software.

I just created a scraping agent using this tool and extracted all tables into one using a REGEX parser. The extracted data should be exactly what you need.

Note: I wrote the REGEX for TD tag with links. You can modify the pattern to get both linked/non-linked using Regex OR condition.

Orbit website scraping sample

2

you can use google docs importHtml functionality to get what you want. add =ImportHtml("URL", "table", num) into a spread sheet, replacing URL with the HTML document's URL, and num with the HTML <table>'s number in the source code. The <table>'s number in the source code is simply based off the number of them are being used in the markup, and its order regarding to that number. so if you want the first table you come across in the HTML, put 1 for num.
I threw together a google spread sheet that pulls in the first two tables from the moons document you linked to, and i separated them with a row marking Table 1, Table 2; the first two rows are just info, first is the importHtml function, second is the url you wanted. Its not perfect by any means, but it works.
I've also used this allowing only one import statement per sheet; so I create a new sheet, past the import function, and alter the table number per sheet. I went ahead and set up two new sheets doing this to show you what i mean.
Again, not perfect, but something I've done to clean it up a bit and keep everything where I want it. Below is the spread sheet function to get the first table, then the second, and finally a link to the spread sheet for you to view/copy/etc. Please note that I broke them up into separate lines for readability, this should be one line placed into one table cell:

 =ImportHtml("http://www.windows2universe.org/our_solar_system/moons_table.html",  
 "table",  
 1)  
=ImportHtml("http://www.windows2universe.org/our_solar_system/moons_table.html",  
 "table",  
 2)  

https://docs.google.com/spreadsheets/d/16INpQMP7dyhtTICZ3ft1wbdf1NkBgCec-Sg6IpFMRcw/edit?usp=sharing

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.