{"id":19987,"date":"2026-11-14T09:27:08","date_gmt":"2026-11-14T07:27:08","guid":{"rendered":"https:\/\/www.beseit.net\/?p=19987"},"modified":"2026-11-14T10:08:33","modified_gmt":"2026-11-14T08:08:33","slug":"libreoffice-base-crear-taula-nova-a-base-de-dades","status":"publish","type":"post","link":"http:\/\/www.beseit.net\/?p=19987","title":{"rendered":"LibreOffice base. crear taula nova a base de dades"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Exactament! Per\u00f2 no cal que cre\u00efs pr\u00e8viament la taula. <strong>LibreOffice Base pot crear-la autom\u00e0ticament a partir del CSV<\/strong>, amb els camps que ja tens a Calc.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Segueix aquests passos:<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>1. Prepara el CSV des de Calc<\/strong><\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Obre el full de Calc.<\/li>\n\n\n\n<li>Ves a <strong>Fitxer \u2192 Anomena i desa<\/strong>.<\/li>\n\n\n\n<li>Selecciona el format <strong>Text CSV (.csv)<\/strong>.<\/li>\n\n\n\n<li>Desa&#8217;l, per exemple, com <code>llistes_youtube.csv<\/code>.<\/li>\n\n\n\n<li>Quan aparegui l&#8217;av\u00eds, confirma <strong>Utilitza el format Text CSV<\/strong>.<\/li>\n<\/ol>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>2. Importa&#8217;l a Base<\/strong><\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li>A Base, entra a <strong>Taules<\/strong>.<\/li>\n\n\n\n<li>Obre el fitxer CSV amb el gestor de fitxers (tamb\u00e9 pots arrossegar-lo a la zona de taules).<\/li>\n\n\n\n<li>Selecciona totes les dades, incloent-hi els encap\u00e7alaments.<\/li>\n\n\n\n<li>Copia-les amb <code>Ctrl+C<\/code>.<\/li>\n\n\n\n<li>Torna a Base i prem <code>Ctrl+V<\/code>.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"515\" height=\"882\" src=\"https:\/\/www.beseit.net\/wp-content\/uploads\/2026\/11\/imatge-13.png\" alt=\"\" class=\"wp-image-19989\" srcset=\"http:\/\/www.beseit.net\/wp-content\/uploads\/2026\/11\/imatge-13.png 515w, http:\/\/www.beseit.net\/wp-content\/uploads\/2026\/11\/imatge-13-175x300.png 175w\" sizes=\"auto, (max-width: 515px) 100vw, 515px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>3. Configura la taula<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">A l&#8217;assistent que apareixer\u00e0:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Nom de la taula:<\/strong> <code>llistes_youtube<\/code><\/li>\n\n\n\n<li>Selecciona <strong>Definici\u00f3 i dades<\/strong>.<\/li>\n\n\n\n<li>Marca <strong>Primera l\u00ednia cont\u00e9 noms de columnes<\/strong>.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Configura els camps:<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><th>Camp<\/th><th>Tipus<\/th><\/tr><tr><td>id<\/td><td>Enter<\/td><\/tr><tr><td>nom_llista<\/td><td>Text [VARCHAR]<\/td><\/tr><tr><td>num_videos<\/td><td>Enter<\/td><\/tr><tr><td>data_entrada<\/td><td>Data<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Atenci\u00f3:<\/strong> Si et pregunta per la clau prim\u00e0ria, pots utilitzar <code>id<\/code>, sempre que sigui \u00fanic.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Quan acabis, prem <strong>Crea<\/strong>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Si vols, quan arribis a la finestra de configuraci\u00f3 dels camps, envia&#8217;m una captura i t&#8217;indicar\u00e9 exactament qu\u00e8 has de seleccionar per evitar problemes amb els tipus de dades.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">puc obrir directament .csv directament des de &#8216;taules&#8217; \/obre?<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">No directament. <strong>LibreOffice Base no permet obrir un CSV des de Taules \u2192 Obre<\/strong> com si fos una taula pr\u00f2pia de Base.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Per\u00f2 pots importar-lo f\u00e0cilment:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Obre el CSV amb LibreOffice Calc.<\/li>\n\n\n\n<li>Selecciona totes les dades (<code>Ctrl+A<\/code>) i copia-les (<code>Ctrl+C<\/code>).<\/li>\n\n\n\n<li>Torna a Base \u2192 <strong>Taules<\/strong>.<\/li>\n\n\n\n<li>Prem <code>Ctrl+V<\/code> sobre la zona de taules.<\/li>\n\n\n\n<li>S&#8217;obrir\u00e0 l&#8217;assistent per crear la taula a partir de les dades.<\/li>\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">Aix\u00ed tindr\u00e0s una taula real dins de la base de dades <code>.odb<\/code>, no simplement un fitxer CSV enlla\u00e7at.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u00c9s el procediment que et recomano.<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">fantastic i facilissim!!<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Fant\u00e0stic! \ud83d\ude03 M&#8217;alegro que hagi anat tan b\u00e9.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Ara ja tens les llistes de YouTube incorporades com una taula pr\u00f2pia de LibreOffice Base. Una soluci\u00f3 senzilla i sense complicacions! \ud83d\udc4c<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">Copiar dades d&#8217;un full de c\u00e0lcul a una taula nova a LibreOffice Base<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">A la teva imatge es veu que ja tens les dades al <strong>Calc<\/strong> (columnes: <code>id<\/code>, <code>nom_llista<\/code>, <code>num_videos<\/code>, <code>data_entrada<\/code>) i la finestra de <strong>Base<\/strong> oberta al costat. Aqu\u00ed tens els passos:<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">M\u00e8tode 1: Copiar i enganxar directament (el m\u00e9s r\u00e0pid)<\/h2>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Al Calc<\/strong>, selecciona totes les dades (incloent la cap\u00e7alera):\n<ul class=\"wp-block-list\">\n<li>Fes clic a la cel\u00b7la <strong>A1<\/strong><mark style=\"background-color:rgba(0, 0, 0, 0);color:#f22121\" class=\"has-inline-color\"> i prem <code>Ctrl + Shift + End<\/code> <\/mark>per seleccionar fins a l&#8217;\u00faltima fila.<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"325\" height=\"872\" src=\"https:\/\/www.beseit.net\/wp-content\/uploads\/2026\/11\/imatge-17.png\" alt=\"\" class=\"wp-image-20000\" srcset=\"http:\/\/www.beseit.net\/wp-content\/uploads\/2026\/11\/imatge-17.png 325w, http:\/\/www.beseit.net\/wp-content\/uploads\/2026\/11\/imatge-17-112x300.png 112w\" sizes=\"auto, (max-width: 325px) 100vw, 325px\" \/><\/figure>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Copia amb <code>Ctrl + C<\/code>.<\/li>\n\n\n\n<li><strong>Al Base<\/strong>, ves a la pestanya <strong>Taules<\/strong> (ja hi ets).<\/li>\n\n\n\n<li>Fes clic dret a l&#8217;espai buit de la llista de taules \u2192 <strong>Enganxa<\/strong> (o <code>Ctrl + V<\/code>). (millir arrastrar)<\/li>\n\n\n\n<li>Et preguntar\u00e0 si vols crear una taula nova. Confirma <strong>S\u00ed<\/strong>.<\/li>\n\n\n\n<li>Et demanar\u00e0 si la primera fila cont\u00e9 els noms de les columnes \u2192 marca <strong>S\u00ed<\/strong>.<\/li>\n\n\n\n<li>Assigna un nom a la taula (per exemple <code>llista_nova<\/code>) i accepta.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"681\" src=\"https:\/\/www.beseit.net\/wp-content\/uploads\/2026\/11\/imatge-15-1024x681.png\" alt=\"\" class=\"wp-image-19995\" srcset=\"http:\/\/www.beseit.net\/wp-content\/uploads\/2026\/11\/imatge-15-1024x681.png 1024w, http:\/\/www.beseit.net\/wp-content\/uploads\/2026\/11\/imatge-15-300x199.png 300w, http:\/\/www.beseit.net\/wp-content\/uploads\/2026\/11\/imatge-15-768x510.png 768w, http:\/\/www.beseit.net\/wp-content\/uploads\/2026\/11\/imatge-15-451x300.png 451w, http:\/\/www.beseit.net\/wp-content\/uploads\/2026\/11\/imatge-15.png 1148w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">M\u00e8tode 2: Utilitzar l&#8217;assistent de creaci\u00f3 de taules<\/h2>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Al <strong>Base<\/strong>, fes doble clic a <strong>\u00abCrea una taula en vista de disseny\u00bb<\/strong> o <strong>\u00abCrea una taula utilitzant l&#8217;assistent\u00bb<\/strong>.<\/li>\n\n\n\n<li>Si fas servir l&#8217;assistent, podr\u00e0s importar camps, per\u00f2 <strong>no importa dades directament<\/strong>.<\/li>\n\n\n\n<li>Per importar les dades, el millor \u00e9s el <strong>M\u00e8tode 1<\/strong> o el <strong>M\u00e8tode 3<\/strong>.<\/li>\n<\/ol>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">M\u00e8tode 3: Connectar el Base al fitxer Calc\/CSV (recomanat si les dades canvien)<\/h2>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Al <strong>Base<\/strong>, ves a <strong>Eines \u2192 SQL<\/strong> o crea una connexi\u00f3:\n<ul class=\"wp-block-list\">\n<li><strong>Fitxer \u2192 Nou \u2192 Base de dades<\/strong> \u2192 Selecciona <strong>\u00abConnecta a una base de dades existent\u00bb<\/strong> \u2192 Tria <strong>Full de c\u00e0lcul<\/strong>.<\/li>\n\n\n\n<li>Selecciona el teu fitxer <code>.ods<\/code> o <code>.csv<\/code>.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Aix\u00f2 crear\u00e0 una taula vinculada que llegeix directament les dades del full.<\/li>\n<\/ol>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u26a0\ufe0f Important sobre els teus datos<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">A la teva taula actual <code>llista<\/code> ja existeix. Si vols <strong>afegir les dades a la taula existent<\/strong> en lloc de crear-ne una de nova:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Copia les dades del Calc <strong>sense la cap\u00e7alera<\/strong> (des de la fila 2).<\/li>\n\n\n\n<li>Al Base, obre la taula <code>llista<\/code> en mode <strong>Edici\u00f3 de dades<\/strong> (doble clic).<\/li>\n\n\n\n<li>Fes clic a l&#8217;\u00faltima fila buida i enganxa amb <code>Ctrl + V<\/code>.<\/li>\n<\/ol>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\">El <strong>M\u00e8tode 1<\/strong> \u00e9s el m\u00e9s senzill per al teu cas. Proveu-lo i si tens algun error, digue-m&#8217;ho! \ud83d\ude0a<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Exactament! Per\u00f2 no cal que cre\u00efs pr\u00e8viament la taula. LibreOffice Base pot crear-la autom\u00e0ticament a partir del CSV, amb els camps que ja tens a Calc. Segueix aquests passos: 1. Prepara el CSV des de Calc 2. Importa&#8217;l a Base &hellip; <a href=\"http:\/\/www.beseit.net\/?p=19987\">Continua llegint <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":3167,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[209,1],"tags":[],"class_list":["post-19987","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-libreoffice","category-bloc-de-notes"],"_links":{"self":[{"href":"http:\/\/www.beseit.net\/index.php?rest_route=\/wp\/v2\/posts\/19987","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.beseit.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.beseit.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.beseit.net\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/www.beseit.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=19987"}],"version-history":[{"count":6,"href":"http:\/\/www.beseit.net\/index.php?rest_route=\/wp\/v2\/posts\/19987\/revisions"}],"predecessor-version":[{"id":20002,"href":"http:\/\/www.beseit.net\/index.php?rest_route=\/wp\/v2\/posts\/19987\/revisions\/20002"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/www.beseit.net\/index.php?rest_route=\/wp\/v2\/media\/3167"}],"wp:attachment":[{"href":"http:\/\/www.beseit.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=19987"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.beseit.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=19987"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.beseit.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=19987"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}