Export a table to csv
Written byPhuoc Nguyen
Category
Level 2 — Intermediate
Created
17 Mar, 2020
Last updated
07 May, 2021
Assume that we have a
`table`
element and a `button`
for exporting the table cells to CSV as following:<table id="exportMe" class="table">
...
</table>
<button id="export">Export</button>
#Export the table cells to CSV
The function below exports all the cells of
`table`
to CSV format. First, we select all the rows, loop over them and export each row to CSV.In each row, we go through all cells, and retrive their text content.
const toCsv = function (table) {
// Query all rows
const rows = table.querySelectorAll('tr');
return [].slice
.call(rows)
.map(function (row) {
// Query all cells
const cells = row.querySelectorAll('th,td');
return [].slice
.call(cells)
.map(function (cell) {
return cell.textContent;
})
.join(',');
})
.join('\n');
};
#Download the CSV
The function below creates a fake
`a`
element whose content is `text`
and triggers the `click`
event.
For more information, you can visit the Download a file post.const download = function (text, fileName) {
const link = document.createElement('a');
link.setAttribute('href', `data:text/csv;charset=utf-8,${encodeURIComponent(text)}`);
link.setAttribute('download', fileName);
link.style.display = 'none';
document.body.appendChild(link);
link.click();
document.body.removeChild(link);
};
The last thing is to connect all pieces together. We just need to handle the
`click`
event of the Export button:const table = document.getElementById('exportMe');
const exportBtn = document.getElementById('export');
exportBtn.addEventListener('click', function () {
// Export to csv
const csv = toCsv(table);
// Download it
download(csv, 'download.csv');
});
#Demo
#See also
Questions? 🙋
Do you have any questions? Not just about this specific post, but about any topic in front-end development that you'd like to learn more about? If so, feel free to send me a message on Twitter or send me an email. You can find them at the bottom of this page.
I have a long list of upcoming posts, but your questions or ideas for the next one will be my top priority. Let's learn together! Sharing knowledge is the best way to grow 🥷.
Recent posts ⚡
Copy the content of an element to your clipboard
01 Oct, 2023
Make a text area fit its content automatically
30 Sep, 2023
Quickly insert alternate characters while typing
30 Sep, 2023
Zebra-like background
30 Sep, 2023
Add autocomplete to your text area
28 Sep, 2023
Linear scale of a number between two ranges
28 Sep, 2023
Highlight the current line in a text area
27 Sep, 2023
Create your own custom cursor in a text area
27 Sep, 2023
Mirror a text area for improving user experience
26 Sep, 2023
Display the line numbers in a text area
24 Sep, 2023
Select a given line in a text area
24 Sep, 2023
Newsletter 🔔
If you're into front-end technologies and you want to see more of the content I'm creating, then you might want to consider subscribing to my newsletter.
By subscribing, you'll be the first to know about new articles, products, and exclusive promotions.
Don't worry, I won't spam you. And if you ever change your mind, you can unsubscribe at any time.
Phước Nguyễn