{"id":55591,"date":"2020-01-10T22:18:50","date_gmt":"2020-01-10T21:18:50","guid":{"rendered":"https:\/\/hlrnet.com\/technoblog\/?p=55591"},"modified":"2020-11-01T12:10:07","modified_gmt":"2020-11-01T11:10:07","slug":"gegevens-in-een-lange-reeks-in-excel-csv-bestanden","status":"publish","type":"post","link":"https:\/\/hlrnet.com\/technoblog\/inicio\/gegevens-in-een-lange-reeks-in-excel-csv-bestanden\/","title":{"rendered":"Gegevens in \u00e9\u00e9n lange reeks in Excel: CSV bestanden"},"content":{"rendered":"<p>V. Als ik dit bestand open in Excel, komen alle gegevens in \u00e9\u00e9n cel terecht. Wat kan ik doen?<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-trevillethumbnailsmall wp-image-55595\" src=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2020\/01\/csv1.png\" alt=\"\" width=\"197\" height=\"143\" \/><\/p>\n<p>A. Het gaat over een CSV bestand (comma seperated values). Als het lijstscheidingsteken op jouw pc anders is dan die van de computer waarop de gegevens zijn opgeslagen, zie je dat zo.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-trevillethumbnailsmall wp-image-55594\" src=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2020\/01\/csv2.png\" alt=\"\" width=\"1017\" height=\"294\" srcset=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2020\/01\/csv2.png 1017w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2020\/01\/csv2-300x87.png 300w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2020\/01\/csv2-768x222.png 768w\" sizes=\"auto, (max-width: 1017px) 100vw, 1017px\" \/><\/p>\n<p>Wat je kan doen: de gegevens selecteren, Gegevens, Tekst naar kolommen.<\/p>\n<p>Duid het teken aan dat de waarden scheidt &#8211; tot je de kolommen ziet zoals je ze verwacht.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-55593\" src=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2020\/01\/csv3.png\" alt=\"\" width=\"507\" height=\"446\" srcset=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2020\/01\/csv3.png 507w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2020\/01\/csv3-300x264.png 300w\" sizes=\"auto, (max-width: 507px) 100vw, 507px\" \/> <img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-55592\" src=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2020\/01\/csv4.png\" alt=\"\" width=\"507\" height=\"446\" srcset=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2020\/01\/csv4.png 507w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2020\/01\/csv4-300x264.png 300w\" sizes=\"auto, (max-width: 507px) 100vw, 507px\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>V. Als ik dit bestand open in Excel, komen alle gegevens in \u00e9\u00e9n cel terecht. Wat kan ik doen? A. Het gaat over een CSV bestand (comma seperated values). Als het lijstscheidingsteken op jouw pc anders is dan die van de computer waarop de gegevens zijn opgeslagen, zie je dat<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"iawp_total_views":2,"footnotes":""},"categories":[54,79,10,160],"tags":[456],"class_list":["post-55591","post","type-post","status-publish","format-standard","hentry","category-excel","category-odisee","category-office","category-tabellen","tag-csv"],"publishpress_future_action":{"enabled":false,"date":"2026-05-02 17:38:50","action":"delete","newStatus":"draft","terms":[],"taxonomy":"category","extraData":[]},"publishpress_future_workflow_manual_trigger":{"enabledWorkflows":[]},"_links":{"self":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts\/55591","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/comments?post=55591"}],"version-history":[{"count":0,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts\/55591\/revisions"}],"wp:attachment":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/media?parent=55591"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/categories?post=55591"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/tags?post=55591"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}