The file Lexique.zip contains a version of the database in Excel format (.xlsx
), and the Openlexicon databases are available in .tsv
(tab separated values) or .csv
(comma separated values) formats. These can easily be imported into OpenOffice Calc (File/Open/format=csv) or into Excel (see How to open a .tsv file in Excel)
To perform searches in a data table with a spreadsheet such as Excel or OpenOffice Calc, you can use, for example, the Vlookup function.
It is also possible, and more flexible, to use the Index and Match functions described in the following tutorials, which show how to look up items in a spreadsheet from a list.
- Using Excel’s Index and Match functions
- Marc Brysbaert’s How to read SUBTLEX-US frequencies into your Excel stimulus file
- How to use Excel Index Match (the right way)
- Match and Index for OpenOffice Calc