Echo - Convert HTML tables to JSON/CSVs
Echo is able to read tables from a website or a html file and convert it to JSON or CSV. Perfect for saving data from a website and loading it into excel, database, etc.
Install
npm i "echo-table-2-file"
Example usage
For our examples we will be using the tables from www.coolgithubprojects.com. We use .convert for local HTML files and .convertUrl for online retrieval.
// Site was saved locally in process folder. The follow code will read it and generate the json.
var echo = require('echo-table-2-file');
echo.convert('process', 'output', 'json');
// Here we grab the tables from the site and save the data to a csv (default type).
var echo = require('echo-table-2-file');
echo.convertUrl('https://www.coolgithubprojects.com', 'output');
// Lastly, we filter the tables to only include the month table (based on table ID).
var echo = require('echo-table-2-file');
echo.convertUrl('https://www.coolgithubprojects.com', 'output', 'months');
/* OUTPUT EXAMPLE : ./output/month.csv
"0","Language","Change","Name"
"","JavaScript","+5607","iojs/io.js"
"","Go","+5439","golang/go"
"","Other","+4581","prakhar1989/awesome-courses"
"","JavaScript","+4045","dimsemenov/PhotoSwipe"
"","PHP","+3284","isohuntto/openbay"
...
*/
Contributing
Pull requests welcome!