{"id":845,"date":"2025-09-04T08:57:09","date_gmt":"2025-09-04T08:57:09","guid":{"rendered":"http:\/\/www.lexique.org\/?page_id=845"},"modified":"2025-09-04T08:57:10","modified_gmt":"2025-09-04T08:57:10","slug":"how-to-query-tables-with-a-spreadsheet","status":"publish","type":"page","link":"http:\/\/www.lexique.org\/?page_id=845&lang=en","title":{"rendered":"How to query tables with a spreadsheet"},"content":{"rendered":"\n<p>The file <a href=\"http:\/\/www.lexique.org\/databases\/Lexique382\/Lexique382.zip\">Lexique.zip<\/a> contains a version of the database in Excel format (<code>.xlsx<\/code>), and the <a href=\"https:\/\/chrplr.github.io\/openlexicon\/databases\/\">Openlexicon databases<\/a> are available in <code>.tsv<\/code> (tab separated values) or <code>.csv<\/code> (comma separated values) formats. These can easily be imported into OpenOffice Calc (File\/Open\/format=csv) or into Excel (see <a rel=\"noreferrer noopener\" aria-label=\"How to open a .tsv file in Excel. (opens in a new tab)\" href=\"https:\/\/rievent.zendesk.com\/hc\/en-us\/articles\/360000029172-FAQ-How-do-I-open-a-tsv-file-in-Excel-\" target=\"_blank\">How to open a .tsv file in Excel<\/a>) <\/p>\n\n\n\n<p>To perform searches in a data table with a spreadsheet such as Excel or OpenOffice Calc, you can use, for example, the <a href=\"https:\/\/help.smartsheet.com\/fr\/function\/vlookup\">Vlookup<\/a> function. <br>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.<br><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><a rel=\"noreferrer noopener\" href=\"https:\/\/www.excel-pratique.com\/fr\/fonctions\/index_equiv.php\" target=\"_blank\">Using Excel\u2019s Index and Match functions<\/a><\/li><li>Marc Brysbaert&#8217;s <a rel=\"noreferrer noopener\" aria-label=\"How to read subtlexus frequencies into your excel stimulus file (opens in a new tab)\" href=\"https:\/\/www.ugent.be\/pp\/experimentele-psychologie\/en\/research\/documents\/subtlexus\/howtoread.pdf\/at_download\/file\" target=\"_blank\">How to read SUBTLEX-US frequencies into your Excel stimulus file<\/a> <\/li><li><a rel=\"noreferrer noopener\" href=\"https:\/\/www.youtube.com\/watch?v=F264FpBDX28\" target=\"_blank\">How to use Excel Index Match (the right way)<\/a><\/li><li><a rel=\"noreferrer noopener\" href=\"https:\/\/www.google.com\/search?client=ubuntu&amp;channel=fs&amp;q=Match+and+Index+openoffice+calc&amp;ie=utf-8&amp;oe=utf-8#kpvalbx=1\" target=\"_blank\">Match and Index for OpenOffice Calc<\/a><\/li><\/ul>\n\n\n\n<p><br><\/p>\n\n","protected":false},"excerpt":{"rendered":"<p>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 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":841,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-845","page","type-page","status-publish","hentry","post-preview"],"_links":{"self":[{"href":"http:\/\/www.lexique.org\/index.php?rest_route=\/wp\/v2\/pages\/845","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.lexique.org\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"http:\/\/www.lexique.org\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"http:\/\/www.lexique.org\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.lexique.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=845"}],"version-history":[{"count":1,"href":"http:\/\/www.lexique.org\/index.php?rest_route=\/wp\/v2\/pages\/845\/revisions"}],"predecessor-version":[{"id":846,"href":"http:\/\/www.lexique.org\/index.php?rest_route=\/wp\/v2\/pages\/845\/revisions\/846"}],"up":[{"embeddable":true,"href":"http:\/\/www.lexique.org\/index.php?rest_route=\/wp\/v2\/pages\/841"}],"wp:attachment":[{"href":"http:\/\/www.lexique.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=845"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}