Skip to main content

Importing tables from websites into spreadsheets

Sometimes in the course of humanities research it can be useful to take information, such as document lists from archives, from a website for future reference. If these items are in a table on a webpage, it is possible to capture these and import them into a spreadsheet for further analysis with the help of browser extensions. This short resource will show the user how to download an extension to copy tables from websites (in this case, ‘Table Capture’ in the Google Chrome browser), and then import the table into a spreadsheet program.

Please note - any data taken from websites should always be given a proper citation.

Learning outcomes

After viewing this training resource, users will be able to:

  • Find and download a browser extension to suit their needs
  • Quickly recreate a table from a website for further analysis
Interested in learning more?

Check out Importing tables from websites into spreadsheets

Go to this resource

Cite as

Rachel Pistol (2019). Importing tables from websites into spreadsheets. Version 1.0.0. EHRI. [Training module]. https://github.com/EHRI/ehri-data-analysis-tools/tree/master/importing-web-tables

Reuse conditions

Resources hosted on DARIAH-Campus are subjects to the DARIAH-Campus Training Materials Reuse Charter

Full metadata

Title:
Importing tables from websites into spreadsheets
Authors:
Rachel Pistol
Domain:
Social Sciences and Humanities
Language:
en
Published:
3/1/2023
Content type:
Training module
Licence:
CCBY 4.0
Sources:
EHRI
Topics:
Data management
Version:
1.0.0