Import export

Import and Export

Export

You can save tables directly to the CSV file, like:

    var data = [{a:1,b:10},{a:2,b:20}];
    alasql('select * into csv("a.csv",{headers:true}) from ?',[data]);

Try this example in jsFiddle.

AlaSQL also supports export to CSV, TAB (or TSV), XLSX, and JSON formats.

Import

You can read tables directly from the CSV file, like:

    var res = alasql('SELECT * FROM CSV("a.csv",{headers:true})');