{"id":199,"date":"2019-04-09T07:00:00","date_gmt":"2019-04-09T07:00:00","guid":{"rendered":"http:\/\/www.lexique.org\/?page_id=199"},"modified":"2019-12-10T09:19:32","modified_gmt":"2019-12-10T09:19:32","slug":"comment-interroger-lexique-avec-un-tableur-excel-calc","status":"publish","type":"page","link":"http:\/\/www.lexique.org\/?page_id=199","title":{"rendered":"Comment interroger les bases de donn\u00e9es avec un Tableur (Excel, Calc&#8230;)"},"content":{"rendered":"\n<p>Le fichier <a href=\"http:\/\/www.lexique.org\/databases\/Lexique382\/Lexique382.zip\">Lexique.zip<\/a> contient une version de la base au format Excel (<code>.xlsx<\/code>) et les <a href=\"https:\/\/chrplr.github.io\/openlexicon\/databases\/\">bases d&#8217;Openlexicon<\/a> sont disponibles aux formats <code>.tsv<\/code> (tab separated values) ou <code>.csv<\/code> (comma separated  values). Ces derniers  peuvent facilement \u00eatre import\u00e9s dans OpenOffice Calc (File\/Open\/format=csv) ou dans Excel (voir <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>Pour faire des recherches dans un tableau de donn\u00e9es avec un tableur comme Excel ou OpenOffice Calc, vous pouvez utiliser, par exemple, la fonctions <a href=\"https:\/\/help.smartsheet.com\/fr\/function\/vlookup\">Vlookup<\/a>. <br>Il est \u00e9galement possible, et plus souple, d&#8217;utiliser les fonctions Index et Match d\u00e9crites dans les tutoriels suivants qui montrent comment rechercher des items dans une feuille de calcul \u00e0 partir d&#8217;une liste.<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\">Utiliser les fonctions lndex et Equiv d&#8217;Excel<\/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 subtlexus 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","protected":false},"excerpt":{"rendered":"<p>Le fichier Lexique.zip contient une version de la base au format Excel (.xlsx) et les bases d&#8217;Openlexicon sont disponibles aux formats .tsv (tab separated values) ou .csv (comma separated values). Ces derniers peuvent facilement \u00eatre import\u00e9s dans OpenOffice Calc (File\/Open\/format=csv) ou dans Excel (voir How to open a .tsv file in Excel) Pour faire des [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":294,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-199","page","type-page","status-publish","hentry","post-preview"],"_links":{"self":[{"href":"http:\/\/www.lexique.org\/index.php?rest_route=\/wp\/v2\/pages\/199","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=199"}],"version-history":[{"count":5,"href":"http:\/\/www.lexique.org\/index.php?rest_route=\/wp\/v2\/pages\/199\/revisions"}],"predecessor-version":[{"id":211,"href":"http:\/\/www.lexique.org\/index.php?rest_route=\/wp\/v2\/pages\/199\/revisions\/211"}],"up":[{"embeddable":true,"href":"http:\/\/www.lexique.org\/index.php?rest_route=\/wp\/v2\/pages\/294"}],"wp:attachment":[{"href":"http:\/\/www.lexique.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=199"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}