{"id":841,"date":"2025-09-04T08:53:33","date_gmt":"2025-09-04T08:53:33","guid":{"rendered":"http:\/\/www.lexique.org\/?page_id=841"},"modified":"2026-04-27T13:27:14","modified_gmt":"2026-04-27T13:27:14","slug":"documentation-2","status":"publish","type":"page","link":"http:\/\/www.lexique.org\/?page_id=841&lang=en","title":{"rendered":"Documentation"},"content":{"rendered":"\n<h3 class=\"wp-block-heading\"><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\">How to cite Lexique<\/h3>\n\n\n\n<p>New, B., Pallier, C., Schalchli, G., Bourgin, J., &amp; Gimenes, M. (2026). <em>Lexique 4: A major upgrade of the \u201cLexique\u201d French lexical database<\/em>. <em>Behavior Research Methods<\/em>. <a href=\"http:\/\/www.lexique.org\/databases\/Lexique400\/Lexique400.pdf\">http:\/\/www.lexique.org\/databases\/Lexique400\/Lexique400.pdf<\/a> <a href=\"https:\/\/rdcu.be\/ffexq\"><strong>Read-only well formated version<\/strong><\/a><\/p>\n\n\n\n<p><em>New, B., Pallier, C., Brysbaert, M., Ferrand, L. (2004)&nbsp;<a href=\"http:\/\/psycho-usmb.fr\/boris.new\/wp-content\/uploads\/2021\/10\/06-New-et-al2004-BRMIC.pdf\">Lexique 2: A New French Lexical Database.<\/a> Behavior Research Methods, Instruments, &amp; Computers, 36 (3), 516-524.&nbsp;<a href=\"https:\/\/doi.org\/10.3758\/bf03195598\">doi.org\/10.3758\/bf03195598&nbsp;<\/a><\/em><\/p>\n\n\n\n<p><em>New B., Pallier C., Ferrand L., Matos R. (2001)&nbsp;<a href=\"http:\/\/psycho-usmb.fr\/boris.new\/wp-content\/uploads\/2021\/10\/01-Lexique_Annee3c.pdf\">A lexical database of contemporary French on the internet: LEXIQUE<\/a>,&nbsp;L\u2019Ann\u00e9e Psychologique, 101, 447-462.&nbsp;&nbsp;<a href=\"https:\/\/doi.org\/10.3758\/s13428-020-01396-2\">doi.org\/10.3758\/s13428-020-01396-2&nbsp;<\/a><\/em><\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Lexique-Infra<\/h4>\n\n\n\n<p>Gimenes, M., Perret, C., &amp; New, B. (2020).&nbsp;<a href=\"https:\/\/drive.google.com\/file\/d\/1uvKrxGqETXkFeRH4PcYaql8ES9FjEdbV\/view?usp=sharing\">Lexique-Infra: grapheme-phoneme, phoneme-grapheme regularity, consistency, and other sublexical statistics for 137,717 polysyllabic French words.&nbsp;<\/a><em>Behavior Research Methods<\/em>.&nbsp;<a href=\"https:\/\/doi.org\/10.3758\/s13428-020-01396-2\">doi.org\/10.3758\/s13428-020-01396-2&nbsp;<\/a><\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Lexique  3Manual<\/h3>\n\n\n\n<p><a href=\"http:\/\/lexique.org\/_documentation\/Manuel_Lexique.3.2.pdf\">Lexique 3 Manual<\/a> (obsolete; for Lexique 4 see the paper below)<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"mce_0\">Online searches<\/h3>\n\n\n\n<p>Some searches can be performed online thanks to dynamic tables. If needed, explanations are available in the <a href=\"http:\/\/www.lexique.org\/?page_id=849\" data-type=\"page\" data-id=\"849\">Online search manual<\/a>.<\/p>\n\n\n\n<p>For &#8220;pattern&#8221; searches, it is essential to know the <a href=\"http:\/\/www.lexique.org\/?page_id=847\" data-type=\"page\" data-id=\"847\">regular expression syntax<\/a>.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Offline searches with R or Python<\/h3>\n\n\n\n<p>To perform some complex queries, or to keep a trace of your criteria when selecting experimental material, rather than using the online search interfaces, it is strongly recommended to use scripts, for example in R or Python on your computer. We have written a few documents to help you: <a href=\"http:\/\/www.lexique.org\/?page_id=853\" data-type=\"page\" data-id=\"853\">\u201cHow to query Lexique with R?\u201d<\/a> and <a href=\"http:\/\/www.lexique.org\/?page_id=851\" data-type=\"page\" data-id=\"851\">\u201cHow to query Lexique with Python?\u201d<\/a>.<\/p>\n\n\n\n<p>To install and automatically access OpenLexicon tables with R, notably Lexique, you can use the following code:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>source('https:\/\/raw.githubusercontent.com\/chrplr\/openlexicon\/master\/datasets-info\/fetch_datasets.R')\nlexique &lt;- get_lexique383_rds()  # downloads the Lexique table<\/code><\/pre>\n\n\n\n<p>The functions defined in <a rel=\"noreferrer noopener\" href=\"https:\/\/raw.githubusercontent.com\/chrplr\/openlexicon\/master\/datasets-info\/fetch_datasets.R\" target=\"_blank\">fetch_datasets.R<\/a> allow you to download the tables and keep local copies.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Offline searches with a spreadsheet (Excel, &#8230;)<\/h3>\n\n\n\n<p>You can also download the tables and use a spreadsheet such as Excel or OpenOffice Calc. 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\" 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 like Excel or OpenOffice Calc, you can use, for example, the <a href=\"https:\/\/help.smartsheet.com\/fr\/function\/vlookup\">Vlookup<\/a> function. It is also possible, and more flexible, to use the <strong>Index<\/strong> and <strong>Match<\/strong> functions described in the following tutorials, which show how to look up items in a spreadsheet from a list<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<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>\n\n\n\n<li>Marc Brysbaert\u2019s <a rel=\"noreferrer noopener\" 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>\n\n\n\n<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>\n\n\n\n<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>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Construction of Lexique and related resources<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"http:\/\/www.lexique.org\/?page_id=286\">Lexique phonetic codes<\/a><\/li>\n\n\n\n<li>Rules and scripts for <a rel=\"noreferrer noopener\" aria-label=\"Lexique syllabification (opens in a new tab)\" href=\"https:\/\/chrplr.github.io\/openlexicon\/scripts\/french-syllabation\/\" target=\"_blank\">Lexique syllabification<\/a> <\/li>\n\n\n\n<li>Explanation of the <a href=\"https:\/\/chrplr.github.io\/openlexicon\/datasets-info\/Voisins\/README-Voisins.html\">neighbor calculation<\/a>.<\/li>\n<\/ul>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>How to cite Lexique New, B., Pallier, C., Schalchli, G., Bourgin, J., &amp; Gimenes, M. (2026). Lexique 4: A major upgrade of the \u201cLexique\u201d French lexical database. Behavior Research Methods. http:\/\/www.lexique.org\/databases\/Lexique400\/Lexique400.pdf Read-only well formated version New, B., Pallier, C., Brysbaert, M., Ferrand, L. (2004)&nbsp;Lexique 2: A New French Lexical Database. Behavior Research Methods, Instruments, &amp; [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-841","page","type-page","status-publish","hentry","post-preview"],"_links":{"self":[{"href":"http:\/\/www.lexique.org\/index.php?rest_route=\/wp\/v2\/pages\/841","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=841"}],"version-history":[{"count":4,"href":"http:\/\/www.lexique.org\/index.php?rest_route=\/wp\/v2\/pages\/841\/revisions"}],"predecessor-version":[{"id":913,"href":"http:\/\/www.lexique.org\/index.php?rest_route=\/wp\/v2\/pages\/841\/revisions\/913"}],"wp:attachment":[{"href":"http:\/\/www.lexique.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=841"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}