Export HTML table to csv file on client side

Question

I had a html table on my webpage. I need an export functionality like, the user gets a choice of opening or saving it on his local machine upon button click. As i already had the data in table format ready, it needs to read it and export it on client side itself using browser capabilities with out any plugins (jquery,..). Pure JS would be really appreciated.

HTML Table on my webpage:

<table id="incidents">
<tr>
<td>data1</td>
<td>data1</td>
<td>data1</td>
</tr>
<tr>
<td>data2</td>
<td>data2</td>
<td>data2</td>
</tr>
<tr>
<td>data3</td>
<td>data3</td>
<td>data3</td>
</tr>
</table>

I need to export this table into a csv or excel sheet on the clients machine giving the options of open or save

don't think that's gonna happen, a browser cannot write or read files on the client — Ben
– Ben, Commented Oct 15, 2011 at 20:04
I seen someone create a data url with the CSV data from a html table. I just can't find it anymore. But it is possible. Some urls somenotestoself.wordpress.com/2010/06/17/… and stackoverflow.com/questions/4184944/… — Gerben
– Gerben, Commented Oct 15, 2011 at 20:21

Community · Accepted Answer · 2017-05-23 10:29:46Z

9

Generate the contents of the CSV file as a string in JavaScript (I assume you're not asking SO to just write this code for you), then encode it as Base64 and generate a data: URI with the MIME type text/csv. Redirect the browser to that URI and it should trigger a download dialog for the user.

edited May 23, 2017 at 10:29

CommunityBot

11 silver badge

answered Oct 15, 2011 at 20:22

Jordan Running

107k18 gold badges193 silver badges189 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Export HTML table to csv file on client side

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related