{"id":10001,"date":"2025-11-27T11:34:58","date_gmt":"2025-11-27T10:34:58","guid":{"rendered":"https:\/\/sosexcel.com\/exceltippek\/?p=10001"},"modified":"2025-11-27T13:38:55","modified_gmt":"2025-11-27T12:38:55","slug":"igy-olvass-be-online-adatokat-az-excelbe","status":"publish","type":"post","link":"https:\/\/sosexcel.com\/exceltippek\/igy-olvass-be-online-adatokat-az-excelbe\/","title":{"rendered":"\u00cdgy olvass be online adatokat az Excelbe"},"content":{"rendered":"\n<p>Tudtad, hogy ha egy&nbsp;<strong>weboldalon&nbsp;<\/strong>t\u00e1bl\u00e1zatos form\u00e1ban szerepelnek az adatok,<strong>&nbsp;az Excel (<a href=\"https:\/\/exceltitok.hu\/power-query-minta-feladatok\/\" target=\"_blank\" rel=\"noreferrer noopener\">Power Query)<\/a> k\u00e9pes ezt<\/strong>&nbsp;felismerni, \u00e9s<strong>&nbsp;t\u00e1bl\u00e1zatk\u00e9nt beh\u00fazni Excelbe?<\/strong><\/p>\n\n\n\n<p>Gyakran lenne sz\u00fcks\u00e9g Excelben is webes adatokra, pl. munkasz\u00fcneti napok, MNB \u00e1rfolyamok, Google t\u00e1bl\u00e1zatok, stb.<\/p>\n\n\n\n<p><strong>K\u00e9zi m\u00e1solgat\u00e1s helyett r\u00e1b\u00edzhatod ezt az Excelre,<\/strong>&nbsp;ugyan\u00fagy mint sok m\u00e1s feladatot.<\/p>\n\n\n\n<p>Ha esetleg m\u00e9g az alap Excel funkci\u00f3k \u00e9s f\u00fcggv\u00e9nyek is t\u00e1vol \u00e1llnak m\u00e9g t\u0151led, akkor&nbsp;el\u0151bb \u00e9rdemes <br><a href=\"https:\/\/exceltitok.hu\/kezdo-halado\/\" target=\"_blank\" rel=\"noreferrer noopener\">az Excel alapvet\u0151 tud\u00e1s\u00e1t megismerned 9 alkalmas tanfolyamunkon.<\/a> Ha azonban m\u00e1r rutinos vagy, \u00e9rdemes lehet tov\u00e1bbl\u00e9pni a Power Query fel\u00e9, ami sok-sok \u00f3r\u00e1t megsp\u00f3rolhat neked.<\/p>\n\n\n\n<p>A Power Query egyik \u00e9rdekes tulajdons\u00e1ga, hogy weboldalakr\u00f3l is tud t\u00e1bl\u00e1zatokat beolvasni.&nbsp;Ez egy j\u00f3 bevezet\u0151 t\u00e9ma, hogy megismerkedj a Power Queryben l\u00e9v\u0151 lehet\u0151s\u00e9gekkel.<\/p>\n\n\n\n<p>A workshopon erre sajnos nem szokott id\u0151 jutni (izgalmasabb t\u00e9m\u00e1kat n\u00e9z\u00fcnk), ez\u00e9rt most a VIP Klub \u00e9l\u0151n n\u00e9zt\u00fck meg a gyakorlatban ezt a funkci\u00f3t, t\u00f6bb p\u00e9ld\u00e1n kereszt\u00fcl &#8211; p\u00e9ld\u00e1ul \u00edgy tudsz Google t\u00e1bl\u00e1zatokat is \u00e9l\u0151ben l\u00e1tni az Excelben. Ha \u00e9rdekelnek a r\u00e9szletek, v\u00e1rlak a&nbsp;<a href=\"https:\/\/exceltitok.t.emesz.com\/t\/l\/30yu0\/6Rbm\/Kjn\/2z8\/2sy\/0\/0\/0\/0\/7EiS8rAfykkTaeoRa4483jeaRtepkM06AKmdtqUVAuOfWeG6Bf1750243977\" target=\"_blank\" rel=\"noreferrer noopener\">VIP Klub<\/a>ban &#8211; r\u00e1ad\u00e1sul a workshopokb\u00f3l azonnal&nbsp;<strong>-25% kedvezm\u00e9ny j\u00e1r. <\/strong><\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Hogyan m\u0171k\u00f6dik a folyamat? (l\u00e9p\u00e9sr\u0151l l\u00e9p\u00e9sre)<\/h3>\n\n\n\n<p><strong>1. A weboldal linkj\u00e9nek kim\u00e1sol\u00e1sa<\/strong><\/p>\n\n\n\n<p>A gyorsbillenty\u0171:&nbsp;<strong>Ctrl&nbsp;L&nbsp;<\/strong>(mint link), majd<strong>&nbsp;Ctrl + C<\/strong>&nbsp;(mint copy)<br>Ezzel az \u00e9ppen megnyitott oldal linkj\u00e9t m\u00e1solhatod ki gyorsan.<\/p>\n\n\n\n<p><strong>2. Excelben: Adatok \u2192 Weblapr\u00f3l<\/strong><\/p>\n\n\n\n<p>Az Adatok men\u00fc alatt tal\u00e1lod a Power Query parancsokat, k\u00f6zt\u00fck a \u201eWeblapr\u00f3l\u201d ikont:<a href=\"https:\/\/exceltitok.t.emesz.com\/t\/l\/30yu1\/6Rbm\/Kjn\/2z8\/2sy\/0\/0\/0\/0\/7EiS8rAfykkTaeoRa4483jeaRtepkM06AKmdtqUVAuOfWeG6Bf1750243977\" target=\"_blank\" rel=\"noreferrer noopener\"><\/a><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2025\/11\/adatok_weblaprol.png\"><img fetchpriority=\"high\" decoding=\"async\" width=\"814\" height=\"394\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2025\/11\/adatok_weblaprol.png\" alt=\"\" class=\"wp-image-10002\" srcset=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2025\/11\/adatok_weblaprol.png 814w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2025\/11\/adatok_weblaprol-300x145.png 300w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2025\/11\/adatok_weblaprol-768x372.png 768w\" sizes=\"(max-width: 814px) 100vw, 814px\" \/><\/a><\/figure>\n\n\n\n<p>Ide, a felugr\u00f3 ablakba&nbsp;illesztheted a linket, \u00e9s a Power Query el\u0151n\u00e9zeti ablak\u00e1ban m\u00e1r meg is jelennek a weboldalon tal\u00e1lhat\u00f3 t\u00e1bl\u00e1k.<\/p>\n\n\n\n<p><strong>3. V\u00e1laszd ki a megfelel\u0151 t\u00e1bl\u00e1t<\/strong><\/p>\n\n\n\n<p>A program felismeri, hogy a weboldalon tal\u00e1lhat\u00f3 t\u00e1bl\u00e1kat, \u00e9s el\u0151n\u00e9zetben meg is mutatja. Ha megvan, amit szeretn\u00e9l, kattints a&nbsp;<strong>Bet\u00f6lt\u00e9s&nbsp;<\/strong>gombra.<\/p>\n\n\n\n<p><strong>4. Az Excel automatikusan t\u00e1bl\u00e1zatk\u00e9nt t\u00f6lti be<\/strong><\/p>\n\n\n\n<p>Fontos: minden adat <a href=\"https:\/\/sosexcel.com\/exceltippek\/tablazat-formazasa\/\">&#8216;T\u00e1bl\u00e1zat form\u00e1tumk\u00e9nt&#8217;<\/a> ker\u00fcl be az Excelbe. Ha az eredeti t\u00e1bl\u00e1zat nem tartalmaz oszlopneveket, akkor a rendszer automatikusan gener\u00e1lja (pl. Column1, Column2).<\/p>\n\n\n\n<p><strong>5. Szerkeszt\u00e9s Power Queryben<\/strong><\/p>\n\n\n\n<p>Ha valamit m\u00e1sk\u00e9pp szeretn\u00e9l, innent\u0151l a Power Query szerkeszt\u0151ben \u00e9rdemes v\u00e1ltoztatni, hogy ne kelljen \u00fajra meg \u00fajra megadni. Ha megnyitod a Lek\u00e9rdez\u00e9s szerkeszt\u00e9se ablakot, itt minden m\u00f3dos\u00edt\u00e1st megtehetsz, amit a sima Excelben.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Ismerd meg az Excelben rejl\u0151 lehet\u0151s\u00e9geket<\/h2>\n\n\n\n<p>Egyszer\u0171s\u00edts, automatiz\u00e1lj min\u00e9l t\u00f6bb munk\u00e1t. Szeretettel v\u00e1runk a k\u00e9pz\u00e9seinken:<\/p>\n\n\n\n<p>\u25c6 <a href=\"https:\/\/exceltitok.t.emesz.com\/t\/l\/30yu2\/6Rbm\/Kjn\/2z8\/2sy\/0\/0\/0\/0\/7EiS8rAfykkTaeoRa4483jeaRtepkM06AKmdtqUVAuOfWeG6Bf1750243977\" target=\"_blank\" rel=\"noreferrer noopener\">9 alkalmas Excel kezd\u0151t\u0151l halad\u00f3ig tanfolyam<\/a><br>\u25c6 <a href=\"https:\/\/exceltitok.t.emesz.com\/t\/l\/30yu4\/6Rbm\/Kjn\/2z8\/2sy\/0\/0\/0\/0\/7EiS8rAfykkTaeoRa4483jeaRtepkM06AKmdtqUVAuOfWeG6Bf1750243977\" target=\"_blank\" rel=\"noreferrer noopener\">Power Query workshop<\/a><br>\u25c6 <a href=\"https:\/\/exceltitok.hu\/oktatas\/\" target=\"_blank\" rel=\"noreferrer noopener\">Egy\u00e9ni oktat\u00e1s, Excel konzult\u00e1ci\u00f3<\/a><\/p>\n\n\n\n<p>Ha bizonytalan vagy, gyere a&nbsp;<a href=\"https:\/\/exceltitok.t.emesz.com\/t\/l\/30yu5\/6Rbm\/Kjn\/2z8\/2sy\/0\/0\/0\/0\/7EiS8rAfykkTaeoRa4483jeaRtepkM06AKmdtqUVAuOfWeG6Bf1750243977\" target=\"_blank\" rel=\"noreferrer noopener\">VIP Klubba<\/a>, n\u00e9zd vissza ezt \u00e9s a kor\u00e1bbi 18 el\u0151ad\u00e1st!<\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Tudtad, hogy ha egy&nbsp;weboldalon&nbsp;t\u00e1bl\u00e1zatos form\u00e1ban szerepelnek az adatok,&nbsp;az Excel (Power Query) k\u00e9pes ezt&nbsp;felismerni, \u00e9s&nbsp;t\u00e1bl\u00e1zatk\u00e9nt beh\u00fazni Excelbe? Gyakran lenne sz\u00fcks\u00e9g Excelben is webes adatokra, pl. munkasz\u00fcneti napok, MNB \u00e1rfolyamok, Google t\u00e1bl\u00e1zatok, stb. K\u00e9zi m\u00e1solgat\u00e1s helyett r\u00e1b\u00edzhatod ezt az Excelre,&nbsp;ugyan\u00fagy mint sok m\u00e1s feladatot. Ha esetleg m\u00e9g az alap Excel funkci\u00f3k \u00e9s f\u00fcggv\u00e9nyek is t\u00e1vol \u00e1llnak m\u00e9g [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"set","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[1],"tags":[],"class_list":["post-10001","post","type-post","status-publish","format-standard","hentry","category-excel-tippek-gyakori-kerdesek"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>\u00cdgy olvass be online adatokat az Excelbe - Azonnal haszn\u00e1lhat\u00f3 Excel tippek<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/sosexcel.com\/exceltippek\/igy-olvass-be-online-adatokat-az-excelbe\/\" \/>\n<meta property=\"og:locale\" content=\"hu_HU\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u00cdgy olvass be online adatokat az Excelbe - Azonnal haszn\u00e1lhat\u00f3 Excel tippek\" \/>\n<meta property=\"og:description\" content=\"Tudtad, hogy ha egy&nbsp;weboldalon&nbsp;t\u00e1bl\u00e1zatos form\u00e1ban szerepelnek az adatok,&nbsp;az Excel (Power Query) k\u00e9pes ezt&nbsp;felismerni, \u00e9s&nbsp;t\u00e1bl\u00e1zatk\u00e9nt beh\u00fazni Excelbe? Gyakran lenne sz\u00fcks\u00e9g Excelben is webes adatokra, pl. munkasz\u00fcneti napok, MNB \u00e1rfolyamok, Google t\u00e1bl\u00e1zatok, stb. K\u00e9zi m\u00e1solgat\u00e1s helyett r\u00e1b\u00edzhatod ezt az Excelre,&nbsp;ugyan\u00fagy mint sok m\u00e1s feladatot. Ha esetleg m\u00e9g az alap Excel funkci\u00f3k \u00e9s f\u00fcggv\u00e9nyek is t\u00e1vol \u00e1llnak m\u00e9g [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/sosexcel.com\/exceltippek\/igy-olvass-be-online-adatokat-az-excelbe\/\" \/>\n<meta property=\"og:site_name\" content=\"Azonnal haszn\u00e1lhat\u00f3 Excel tippek\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/bernadett.koros\" \/>\n<meta property=\"article:published_time\" content=\"2025-11-27T10:34:58+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-11-27T12:38:55+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2025\/11\/adatok_weblaprol.png\" \/>\n\t<meta property=\"og:image:width\" content=\"814\" \/>\n\t<meta property=\"og:image:height\" content=\"394\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Bernadett\" \/>\n<meta name=\"twitter:label1\" content=\"Szerz\u0151:\" \/>\n\t<meta name=\"twitter:data1\" content=\"Bernadett\" \/>\n\t<meta name=\"twitter:label2\" content=\"Becs\u00fclt olvas\u00e1si id\u0151\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 perc\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/igy-olvass-be-online-adatokat-az-excelbe\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/igy-olvass-be-online-adatokat-az-excelbe\/\"},\"author\":{\"name\":\"Bernadett\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/person\/ba32d0d071cf1d2ead4c179c9270f29b\"},\"headline\":\"\u00cdgy olvass be online adatokat az Excelbe\",\"datePublished\":\"2025-11-27T10:34:58+00:00\",\"dateModified\":\"2025-11-27T12:38:55+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/igy-olvass-be-online-adatokat-az-excelbe\/\"},\"wordCount\":542,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/#organization\"},\"image\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/igy-olvass-be-online-adatokat-az-excelbe\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2025\/11\/adatok_weblaprol.png\",\"articleSection\":[\"Excel tippek, gyakori k\u00e9rd\u00e9sek\"],\"inLanguage\":\"hu\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/sosexcel.com\/exceltippek\/igy-olvass-be-online-adatokat-az-excelbe\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/igy-olvass-be-online-adatokat-az-excelbe\/\",\"url\":\"https:\/\/sosexcel.com\/exceltippek\/igy-olvass-be-online-adatokat-az-excelbe\/\",\"name\":\"\u00cdgy olvass be online adatokat az Excelbe - Azonnal haszn\u00e1lhat\u00f3 Excel tippek\",\"isPartOf\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/igy-olvass-be-online-adatokat-az-excelbe\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/igy-olvass-be-online-adatokat-az-excelbe\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2025\/11\/adatok_weblaprol.png\",\"datePublished\":\"2025-11-27T10:34:58+00:00\",\"dateModified\":\"2025-11-27T12:38:55+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/igy-olvass-be-online-adatokat-az-excelbe\/#breadcrumb\"},\"inLanguage\":\"hu\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/sosexcel.com\/exceltippek\/igy-olvass-be-online-adatokat-az-excelbe\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"hu\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/igy-olvass-be-online-adatokat-az-excelbe\/#primaryimage\",\"url\":\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2025\/11\/adatok_weblaprol.png\",\"contentUrl\":\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2025\/11\/adatok_weblaprol.png\",\"width\":814,\"height\":394},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/igy-olvass-be-online-adatokat-az-excelbe\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/sosexcel.com\/exceltippek\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u00cdgy olvass be online adatokat az Excelbe\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/#website\",\"url\":\"https:\/\/sosexcel.com\/exceltippek\/\",\"name\":\"Azonnal haszn\u00e1lhat\u00f3 Excel tippek\",\"description\":\"ha S.O.S. seg\u00edts\u00e9gre van sz\u00fcks\u00e9ged!\",\"publisher\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/sosexcel.com\/exceltippek\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"hu\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/#organization\",\"name\":\"Azonnal haszn\u00e1lhat\u00f3 Excel tippek\",\"url\":\"https:\/\/sosexcel.com\/exceltippek\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"hu\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/07\/cropped-sos-excel-logo-nagy-tippek-oktatas.png\",\"contentUrl\":\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/07\/cropped-sos-excel-logo-nagy-tippek-oktatas.png\",\"width\":600,\"height\":133,\"caption\":\"Azonnal haszn\u00e1lhat\u00f3 Excel tippek\"},\"image\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/person\/ba32d0d071cf1d2ead4c179c9270f29b\",\"name\":\"Bernadett\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"hu\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/b83c1df02932359022967a1ac90aea0e45512b862866e93d439ba8ae464b6693?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/b83c1df02932359022967a1ac90aea0e45512b862866e93d439ba8ae464b6693?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/b83c1df02932359022967a1ac90aea0e45512b862866e93d439ba8ae464b6693?s=96&d=mm&r=g\",\"caption\":\"Bernadett\"},\"description\":\"Bernadett 10 \u00e9vig dolgozott a versenyszf\u00e9r\u00e1ban, majd az ott szerzett tapasztalatok alapj\u00e1n \u00e1ll\u00edtotta \u00f6ssze az ExcelTitok k\u00e9pz\u00e9si m\u00f3dszert. 2010 szeptembere \u00f3ta csak Excel oktat\u00e1ssal foglalkozik. Oktat\u00f3i csapat\u00e1val m\u00e1ra m\u00e1r t\u00f6bb mint 2000 emberrel foglalkoztak szem\u00e9lyesen, egy\u00e9ni oktat\u00e1s keret\u00e9ben. C\u00e9lja, hogy \u00edr\u00e1sainak \u00e9s munk\u00e1j\u00e1nak k\u00f6sz\u00f6nhet\u0151en min\u00e9l t\u00f6bben megbar\u00e1tkozzanak az Excellel.\",\"sameAs\":[\"http:\/\/exceltitok.hu\/\",\"https:\/\/www.facebook.com\/bernadett.koros\"],\"url\":\"https:\/\/sosexcel.com\/exceltippek\/author\/sos-excel\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u00cdgy olvass be online adatokat az Excelbe - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","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:\/\/sosexcel.com\/exceltippek\/igy-olvass-be-online-adatokat-az-excelbe\/","og_locale":"hu_HU","og_type":"article","og_title":"\u00cdgy olvass be online adatokat az Excelbe - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","og_description":"Tudtad, hogy ha egy&nbsp;weboldalon&nbsp;t\u00e1bl\u00e1zatos form\u00e1ban szerepelnek az adatok,&nbsp;az Excel (Power Query) k\u00e9pes ezt&nbsp;felismerni, \u00e9s&nbsp;t\u00e1bl\u00e1zatk\u00e9nt beh\u00fazni Excelbe? Gyakran lenne sz\u00fcks\u00e9g Excelben is webes adatokra, pl. munkasz\u00fcneti napok, MNB \u00e1rfolyamok, Google t\u00e1bl\u00e1zatok, stb. K\u00e9zi m\u00e1solgat\u00e1s helyett r\u00e1b\u00edzhatod ezt az Excelre,&nbsp;ugyan\u00fagy mint sok m\u00e1s feladatot. Ha esetleg m\u00e9g az alap Excel funkci\u00f3k \u00e9s f\u00fcggv\u00e9nyek is t\u00e1vol \u00e1llnak m\u00e9g [&hellip;]","og_url":"https:\/\/sosexcel.com\/exceltippek\/igy-olvass-be-online-adatokat-az-excelbe\/","og_site_name":"Azonnal haszn\u00e1lhat\u00f3 Excel tippek","article_author":"https:\/\/www.facebook.com\/bernadett.koros","article_published_time":"2025-11-27T10:34:58+00:00","article_modified_time":"2025-11-27T12:38:55+00:00","og_image":[{"width":814,"height":394,"url":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2025\/11\/adatok_weblaprol.png","type":"image\/png"}],"author":"Bernadett","twitter_misc":{"Szerz\u0151:":"Bernadett","Becs\u00fclt olvas\u00e1si id\u0151":"3 perc"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/sosexcel.com\/exceltippek\/igy-olvass-be-online-adatokat-az-excelbe\/#article","isPartOf":{"@id":"https:\/\/sosexcel.com\/exceltippek\/igy-olvass-be-online-adatokat-az-excelbe\/"},"author":{"name":"Bernadett","@id":"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/person\/ba32d0d071cf1d2ead4c179c9270f29b"},"headline":"\u00cdgy olvass be online adatokat az Excelbe","datePublished":"2025-11-27T10:34:58+00:00","dateModified":"2025-11-27T12:38:55+00:00","mainEntityOfPage":{"@id":"https:\/\/sosexcel.com\/exceltippek\/igy-olvass-be-online-adatokat-az-excelbe\/"},"wordCount":542,"commentCount":0,"publisher":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#organization"},"image":{"@id":"https:\/\/sosexcel.com\/exceltippek\/igy-olvass-be-online-adatokat-az-excelbe\/#primaryimage"},"thumbnailUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2025\/11\/adatok_weblaprol.png","articleSection":["Excel tippek, gyakori k\u00e9rd\u00e9sek"],"inLanguage":"hu","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/sosexcel.com\/exceltippek\/igy-olvass-be-online-adatokat-az-excelbe\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/sosexcel.com\/exceltippek\/igy-olvass-be-online-adatokat-az-excelbe\/","url":"https:\/\/sosexcel.com\/exceltippek\/igy-olvass-be-online-adatokat-az-excelbe\/","name":"\u00cdgy olvass be online adatokat az Excelbe - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","isPartOf":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#website"},"primaryImageOfPage":{"@id":"https:\/\/sosexcel.com\/exceltippek\/igy-olvass-be-online-adatokat-az-excelbe\/#primaryimage"},"image":{"@id":"https:\/\/sosexcel.com\/exceltippek\/igy-olvass-be-online-adatokat-az-excelbe\/#primaryimage"},"thumbnailUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2025\/11\/adatok_weblaprol.png","datePublished":"2025-11-27T10:34:58+00:00","dateModified":"2025-11-27T12:38:55+00:00","breadcrumb":{"@id":"https:\/\/sosexcel.com\/exceltippek\/igy-olvass-be-online-adatokat-az-excelbe\/#breadcrumb"},"inLanguage":"hu","potentialAction":[{"@type":"ReadAction","target":["https:\/\/sosexcel.com\/exceltippek\/igy-olvass-be-online-adatokat-az-excelbe\/"]}]},{"@type":"ImageObject","inLanguage":"hu","@id":"https:\/\/sosexcel.com\/exceltippek\/igy-olvass-be-online-adatokat-az-excelbe\/#primaryimage","url":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2025\/11\/adatok_weblaprol.png","contentUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2025\/11\/adatok_weblaprol.png","width":814,"height":394},{"@type":"BreadcrumbList","@id":"https:\/\/sosexcel.com\/exceltippek\/igy-olvass-be-online-adatokat-az-excelbe\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/sosexcel.com\/exceltippek\/"},{"@type":"ListItem","position":2,"name":"\u00cdgy olvass be online adatokat az Excelbe"}]},{"@type":"WebSite","@id":"https:\/\/sosexcel.com\/exceltippek\/#website","url":"https:\/\/sosexcel.com\/exceltippek\/","name":"Azonnal haszn\u00e1lhat\u00f3 Excel tippek","description":"ha S.O.S. seg\u00edts\u00e9gre van sz\u00fcks\u00e9ged!","publisher":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/sosexcel.com\/exceltippek\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"hu"},{"@type":"Organization","@id":"https:\/\/sosexcel.com\/exceltippek\/#organization","name":"Azonnal haszn\u00e1lhat\u00f3 Excel tippek","url":"https:\/\/sosexcel.com\/exceltippek\/","logo":{"@type":"ImageObject","inLanguage":"hu","@id":"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/logo\/image\/","url":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/07\/cropped-sos-excel-logo-nagy-tippek-oktatas.png","contentUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/07\/cropped-sos-excel-logo-nagy-tippek-oktatas.png","width":600,"height":133,"caption":"Azonnal haszn\u00e1lhat\u00f3 Excel tippek"},"image":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/person\/ba32d0d071cf1d2ead4c179c9270f29b","name":"Bernadett","image":{"@type":"ImageObject","inLanguage":"hu","@id":"https:\/\/secure.gravatar.com\/avatar\/b83c1df02932359022967a1ac90aea0e45512b862866e93d439ba8ae464b6693?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/b83c1df02932359022967a1ac90aea0e45512b862866e93d439ba8ae464b6693?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/b83c1df02932359022967a1ac90aea0e45512b862866e93d439ba8ae464b6693?s=96&d=mm&r=g","caption":"Bernadett"},"description":"Bernadett 10 \u00e9vig dolgozott a versenyszf\u00e9r\u00e1ban, majd az ott szerzett tapasztalatok alapj\u00e1n \u00e1ll\u00edtotta \u00f6ssze az ExcelTitok k\u00e9pz\u00e9si m\u00f3dszert. 2010 szeptembere \u00f3ta csak Excel oktat\u00e1ssal foglalkozik. Oktat\u00f3i csapat\u00e1val m\u00e1ra m\u00e1r t\u00f6bb mint 2000 emberrel foglalkoztak szem\u00e9lyesen, egy\u00e9ni oktat\u00e1s keret\u00e9ben. C\u00e9lja, hogy \u00edr\u00e1sainak \u00e9s munk\u00e1j\u00e1nak k\u00f6sz\u00f6nhet\u0151en min\u00e9l t\u00f6bben megbar\u00e1tkozzanak az Excellel.","sameAs":["http:\/\/exceltitok.hu\/","https:\/\/www.facebook.com\/bernadett.koros"],"url":"https:\/\/sosexcel.com\/exceltippek\/author\/sos-excel\/"}]}},"_links":{"self":[{"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/10001","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/comments?post=10001"}],"version-history":[{"count":2,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/10001\/revisions"}],"predecessor-version":[{"id":10006,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/10001\/revisions\/10006"}],"wp:attachment":[{"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/media?parent=10001"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/categories?post=10001"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/tags?post=10001"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}