Export tables from a web page to CSV and JSON
Pastylink detects the tables on a web page and shows them as CSV text and JSON, ready to copy into Excel, Google Sheets or a script. Just paste the page link. The feature is currently available only for Wikipedia.
How to
- Open the web page that contains the table and copy its address from the browser address bar.
- Paste the link in the box at the top of this page: the analysis starts automatically.
- Copy the result: each table found appears as CSV text (tab-separated columns) and as JSON.
What you get
- A section for each table on the page, in order.
- The CSV text, with one row for each row of the table.
- The same content in JSON, useful for scripts and applications.
- Cells cleaned of footnotes, flags and sort keys.
Limits
- For now only Wikipedia pages are supported, in any language, and only standard tables (those with borders and a header): sidebars such as infoboxes are not included.
- Merged cells spanning multiple rows or columns are not repeated: the value appears only once.
FAQ
Can I use the data in Excel or Google Sheets?
Yes. The CSV text uses tab-separated columns: pasting it into an Excel or Google Sheets cell will arrange the columns automatically.Do I need an account or a browser extension?
No. Just paste the page link, no registration and no installation needed.Can I reuse data from a table?
Wikipedia content is generally published under the CC BY-SA license: when reusing it, you must credit the source and authors and keep the same license.
Example
Suggest new features
Do you need another type of extraction? Would you like Pastylink to have another web page analysis feature? Write your idea here.