{"id":1918,"date":"2023-10-28T02:40:46","date_gmt":"2023-10-28T02:40:46","guid":{"rendered":"https:\/\/exceladvisor.org\/nl\/tekstbestand-openen\/"},"modified":"2023-12-06T05:50:39","modified_gmt":"2023-12-06T05:50:39","slug":"tekstbestand-openen","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/nl\/tekstbestand-openen\/","title":{"rendered":"Hoe open je een tekstbestand in excel? (.tekst)"},"content":{"rendered":"<div class=\"excel-voor-de-inhoud\" id=\"excel-1842066770\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p>Om een tekstbestand in Excel te openen, kunt u het eenvoudig openen via het dialoogvenster Openen. Zodra u het opent, toont Excel u de optie Tekst naar kolommen om gegevens in het werkblad te importeren. Als de gegevens in tabelvorm zijn, zijn er slechts een paar klikken nodig om deze aan Excel toe te voegen. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-77769\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fichier-texte-ouvert-dans-excel.png\" sizes=\"auto, \" srcset=\"\" alt=\"open-tekstbestand-in-excel\" width=\"687\" height=\"506\"><\/figure><\/div><p> In deze zelfstudie bekijken we de drie verschillende manieren om een tekstbestand te openen met Excel.<\/p><h2 class=\"wp-block-heading\"> Stappen om een tekstbestand in Excel te openen<\/h2><ol><li> Ga eerst naar het tabblad Bestand, klik op Openen en klik vervolgens op Bladeren. <br><img loading=\"lazy\" decoding=\"async\" title=\"Open en blader in 2 klikken\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-cliquez-sur-ouvrir-et-parcourir.png\" sizes=\"auto, \" srcset=\"\" alt=\"click-open-and-browse\" width=\"436\" height=\"480\"><\/li><li> Selecteer daarna in het navigatiedialoogvenster &#8220;Alle bestanden&#8221; in het vervolgkeuzemenu naast de bestandsnaam. <br><img loading=\"lazy\" decoding=\"async\" title=\"3-selecteer-alle-bestanden\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-selectionner-tous-les-fichiers.png\" sizes=\"auto, \" srcset=\"\" alt=\"select-all-files\" width=\"550\" height=\"95\"><\/li><li> Klik vervolgens op het tekstbestand dat u wilt openen en klik op OK. <br><img loading=\"lazy\" decoding=\"async\" title=\"4-selecteer-het-tekstbestand\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-selectionnez-le-fichier-texte.png\" sizes=\"auto, \" srcset=\"\" alt=\"select-the-text-file\" width=\"436\" height=\"362\"><\/li><li> U hebt het dialoogvenster Tekst-naar-kolommen. Klik op de knop Volgende om door te gaan naar de volgende stap en vink \u201cMijn gegevens hebben headers\u201d aan. Als uw gegevens al headers hebben. <br><img loading=\"lazy\" decoding=\"async\" title=\"5 Dialoogvenster Tekst naar kolommen\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-boite-de-dialogue-de-texte-en-colonne.png\" sizes=\"auto, \" srcset=\"\" alt=\"text-to-column-dialog-box\" width=\"618\" height=\"442\"><\/li><li> Vink in de volgende stap het vakje &#8220;Tab&#8221; aan en klik vervolgens op Volgende. <br><img loading=\"lazy\" decoding=\"async\" title=\"6-check-tab-en-klik-volgende\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-onglet-coche-et-cliquez-sur-suivant.png\" sizes=\"auto, \" srcset=\"\" alt=\"checkmark-tab-and-click-next\" width=\"528\" height=\"410\"><\/li><li> Klik aan het einde op Voltooien om de gegevens in de spreadsheet te krijgen. <br><img loading=\"lazy\" decoding=\"async\" title=\"Voltooi in 7 klikken\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Terminer-en-7-clics.png\" sizes=\"auto, \" srcset=\"\" alt=\"click-finish\" width=\"529\" height=\"408\"><\/li><\/ol><p> Zodra u op Voltooien klikt, ziet u de gegevens in het blad zoals hieronder: <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-77776\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/8-donnees-ouvertes-dans-la-feuille.png\" sizes=\"auto, \" srcset=\"\" alt=\"open-data-in-sheet\" width=\"487\" height=\"425\"><\/figure><\/div><p> Zodra u een tekstbestand in Excel opent, krijgt u de gegevens, maar wordt dat tekstbestand niet opgeslagen als een Excel-bestand. Sla het op als een Excel-werkmap, ga naar Bestand \u21e2 <a href=\"https:\/\/exceladvisor.org\/nl\/opslaan-als\/\">Opslaan als<\/a> .<\/p><h2 class=\"wp-block-heading\"> Open een tekstbestand in Excel met Power Query<\/h2><ol><li> Ga naar Gegevens \u21e2 Uit bestand \u21e2 Uit tekst\/CSV. <br><img loading=\"lazy\" decoding=\"async\" title=\"9-open-tekstbestand-met-power-query\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/9-fichier-texte-ouvert-avec-requete-de-puissance.png\" sizes=\"auto, \" srcset=\"\" alt=\"open-text-file-with-power-query\" width=\"515\" height=\"482\"><\/li><li> Selecteer het bestand dat u wilt importeren en klik op de knop Importeren. <br><img loading=\"lazy\" decoding=\"async\" title=\"10-bestand-selecteren-en-importeren\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/10-selectionner-le-fichier-et-importer.png\" sizes=\"auto, \" srcset=\"\" alt=\"select-file-and-import\" width=\"498\" height=\"245\"><\/li><li> Klik op de knop Laden om de gegevens in het spreadsheet te laden. <br><img loading=\"lazy\" decoding=\"async\" title=\"11-laadbestand\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/11-charger-le-fichier.png\" sizes=\"auto, \" srcset=\"\" alt=\"load-the-file\" width=\"663\" height=\"308\"><\/li><li> U hebt nu de gegevens in het spreadsheet. <br><img loading=\"lazy\" decoding=\"async\" title=\"12 gegevens geladen in een blad\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/12-donnees-chargees-dans-la-feuille.png\" sizes=\"auto, \" srcset=\"\" alt=\"data-loaded-in-sheet\" width=\"530\" height=\"237\"><\/li><\/ol><p> Het beste deel van het gebruik van <a href=\"https:\/\/exceladvisor.org\/nl\/stroom-verzoek\/\">Power Query<\/a> om gegevens uit een tekstbestand te importeren, is dat het dynamisch is. Wanneer u de gegevens in het tekstbestand bijwerkt, kunt u deze eenvoudig in Excel bijwerken door op de knop Vernieuwen te klikken.<\/p><h2 class=\"wp-block-heading\"> Kopieer en plak gegevens uit een tekstbestand naar een Excel-spreadsheet<\/h2><p> Open hiervoor het tekstbestand en gebruik de sneltoets Ctrl + A om alle gegevens in het tekstbestand te selecteren. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-77781\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/13-copier-coller-des-donnees-du-texte-vers-excel.png\" sizes=\"auto, \" srcset=\"\" alt=\"kopieer-plak-gegevens-van-tekst-naar-Excel\" width=\"674\" height=\"362\"><\/figure><\/div><p> Ga naar het spreadsheet, selecteer cel A1 en <a href=\"https:\/\/exceladvisor.org\/nl\/kopieren-plakken\/\">druk op Ctrl + V<\/a> om de gegevens daar te plakken. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-77782\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/14-donnees-textuelles-collees-dans-la-feuille.png\" sizes=\"auto, \" srcset=\"\" alt=\"tekst-gegevens-geplakt-in-blad\" width=\"513\" height=\"372\"><\/figure><\/div><div class=\"gb-container gb-container-4db6181c gb-container-mt\"> <a class=\"gb-button gb-button-c5897111 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/nl\/excel-vooruitgang\/\">Geavanceerde Excel-zelfstudies<\/a><h2 class=\"gb-headline gb-headline-665e5f6b gb-headline-text gb-headline-mt-heading\"> Gerelateerde tutorials <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a20baf7c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-65ddf67e\"><div class=\"gb-container gb-container-65ddf67e\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/nl\/herstel-corrupt-excel-bestand\/\">Reparatie beschadigd Excel-bestand<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/niet-opgeslagen-bestanden-herstellen\/\">Herstel niet-opgeslagen Excel-bestanden wanneer Excel crasht<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/xlsx-naar-csv\/\">Excel-bestand (werkmap) opslaan in CSV-formaat (XLSX NAAR CSV)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/verberg-toon-werkmap\/\">Een werkmap verbergen en weergeven in Excel<\/a><\/li><\/ul><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-1918","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Hoe open je een tekstbestand in Excel? (.TEKST)<\/title>\n<meta name=\"description\" content=\"Leer hoe u een tekstbestand (.txt) opent in Excel en hoe u de gegevens uit dat bestand in de spreadsheet kunt krijgen.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/nl\/tekstbestand-openen\/\" \/>\n<meta property=\"og:locale\" content=\"nl_NL\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Hoe open je een tekstbestand in Excel? (.TEKST)\" \/>\n<meta property=\"og:description\" content=\"Leer hoe u een tekstbestand (.txt) opent in Excel en hoe u de gegevens uit dat bestand in de spreadsheet kunt krijgen.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/nl\/tekstbestand-openen\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T05:50:39+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fichier-texte-ouvert-dans-excel.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Geschatte leestijd\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minuten\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/tekstbestand-openen\/\",\"url\":\"https:\/\/exceladvisor.org\/nl\/tekstbestand-openen\/\",\"name\":\"Hoe open je een tekstbestand in Excel? (.TEKST)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/tekstbestand-openen\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/tekstbestand-openen\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fichier-texte-ouvert-dans-excel.png\",\"datePublished\":\"2023-10-28T02:40:46+00:00\",\"dateModified\":\"2023-12-06T05:50:39+00:00\",\"description\":\"Leer hoe u een tekstbestand (.txt) opent in Excel en hoe u de gegevens uit dat bestand in de spreadsheet kunt krijgen.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/tekstbestand-openen\/#breadcrumb\"},\"inLanguage\":\"nl-NL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/nl\/tekstbestand-openen\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/tekstbestand-openen\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fichier-texte-ouvert-dans-excel.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fichier-texte-ouvert-dans-excel.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/tekstbestand-openen\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Thuis\",\"item\":\"https:\/\/exceladvisor.org\/nl\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Hoe open je een tekstbestand in excel? (.tekst)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/#website\",\"url\":\"https:\/\/exceladvisor.org\/nl\/\",\"name\":\"Excel Advisor\",\"description\":\"Uw gids voor datadominantie\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/nl\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"nl-NL\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/nl\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/nl\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/nl\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Hoe open je een tekstbestand in Excel? (.TEKST)","description":"Leer hoe u een tekstbestand (.txt) opent in Excel en hoe u de gegevens uit dat bestand in de spreadsheet kunt krijgen.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/exceladvisor.org\/nl\/tekstbestand-openen\/","og_locale":"nl_NL","og_type":"article","og_title":"Hoe open je een tekstbestand in Excel? (.TEKST)","og_description":"Leer hoe u een tekstbestand (.txt) opent in Excel en hoe u de gegevens uit dat bestand in de spreadsheet kunt krijgen.","og_url":"https:\/\/exceladvisor.org\/nl\/tekstbestand-openen\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T05:50:39+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fichier-texte-ouvert-dans-excel.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Geschatte leestijd":"2 minuten"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/nl\/tekstbestand-openen\/","url":"https:\/\/exceladvisor.org\/nl\/tekstbestand-openen\/","name":"Hoe open je een tekstbestand in Excel? (.TEKST)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/nl\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/nl\/tekstbestand-openen\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/nl\/tekstbestand-openen\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fichier-texte-ouvert-dans-excel.png","datePublished":"2023-10-28T02:40:46+00:00","dateModified":"2023-12-06T05:50:39+00:00","description":"Leer hoe u een tekstbestand (.txt) opent in Excel en hoe u de gegevens uit dat bestand in de spreadsheet kunt krijgen.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/nl\/tekstbestand-openen\/#breadcrumb"},"inLanguage":"nl-NL","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/nl\/tekstbestand-openen\/"]}]},{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/exceladvisor.org\/nl\/tekstbestand-openen\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fichier-texte-ouvert-dans-excel.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fichier-texte-ouvert-dans-excel.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/nl\/tekstbestand-openen\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Thuis","item":"https:\/\/exceladvisor.org\/nl\/"},{"@type":"ListItem","position":2,"name":"Hoe open je een tekstbestand in excel? (.tekst)"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/nl\/#website","url":"https:\/\/exceladvisor.org\/nl\/","name":"Excel Advisor","description":"Uw gids voor datadominantie","publisher":{"@id":"https:\/\/exceladvisor.org\/nl\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/nl\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"nl-NL"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/nl\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/nl\/","logo":{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/exceladvisor.org\/nl\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/nl\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/nl\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/nl\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/1918","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/comments?post=1918"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/1918\/revisions"}],"predecessor-version":[{"id":2766,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/1918\/revisions\/2766"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/media?parent=1918"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}