{"id":61667,"date":"2026-03-05T14:53:32","date_gmt":"2026-03-05T13:53:32","guid":{"rendered":"https:\/\/www.minicrm.hu\/help\/?p=61667"},"modified":"2026-03-05T16:13:02","modified_gmt":"2026-03-05T15:13:02","slug":"sincronizarea-datelor-folosind-excel-power-query","status":"publish","type":"post","link":"https:\/\/www.minicrm.ro\/help\/sincronizarea-datelor-folosind-excel-power-query\/","title":{"rendered":"Sincronizarea datelor folosind Excel Power Query"},"content":{"rendered":"

Po\u021bi exporta datele dintr-un filtru sincronizat cu Google Sheets (Foile de calcul Google) folosind varianta online Excel prin metoda Power Query.<\/p>\n

Prima dat\u0103, asigur\u0103-te c\u0103 ai construit filtrul \u0219i c\u0103 ai activ\u0103 func\u021bia \u201eSincronizare foi de calcul Google<\/em><\/a>\u201d. Dac\u0103 nu ai mai creat p\u00e2n\u0103 acum un filtru, te rog s\u0103 consul\u021bi pagina noastr\u0103<\/a> pe acest subiect.<\/p>\n

Pa\u0219ii pentru aceast\u0103 sincronizare sunt:<\/p>\n

\u00cen filtrul construit \u0219i salvat, apas\u0103 pe Export\u0103<\/strong> \u0219i alege varianta \u201eSincronizeaz\u0103 Oportunit\u0103\u021bi cu Foile de Calcul Google<\/strong>\u201d.\"\"<\/p>\n

 <\/p>\n

Apas\u0103 pe Shared<\/strong>, apoi, din link-ul \u00eencercuit \u00een poz\u0103, copiaz\u0103 de la http \u201dhttps:\/\/r3.minicrm.io\/Api\/SharedFilter……\u201d.\"\"<\/p>\n

 <\/p>\n

Deschide o foaie nou\u0103 \u00een Excel (versiunea online)<\/strong> \u0219i apas\u0103 pe Data<\/strong>, apoi pe Get Data:<\/strong><\/p>\n

\"\"<\/p>\n

 <\/p>\n

Apas\u0103 pe \u201dLaunch Power Query Editor<\/strong>\u201d<\/p>\n

\"\"<\/p>\n

 <\/p>\n

Apas\u0103 pe pictograma \u00eencercuit\u0103<\/strong>, apoi pe \u201dBlank query<\/strong>\u201d<\/p>\n

\"\"<\/p>\n

 <\/p>\n

\u00cen fereastra care se deschide, \u0219terge cele 4 linii de cod:<\/p>\n

\"\"<\/p>\n

Apoi, \u00een aceast\u0103 fereastr\u0103 goal\u0103, copiaz\u0103 \u0219i insereaz\u0103 acest script:<\/div>\n
let
\nUrl =
\n“\u00cenlocuie\u0219te aici cu link-ul copiat anterior (pasul 2)”,
\nRaw = Web.Contents(Url, [Headers=[Accept=”text\/csv”]]),
\nCsv = Csv.Document(
\nRaw,
\n[
\nDelimiter = “,”,
\nEncoding = 65001,
\nQuoteStyle = QuoteStyle.Csv
\n]
\n),
\nPromoted = Table.PromoteHeaders(Csv, [PromoteAllScalars=true])
\nin
\nPromoted<\/div>\n
Aten\u021bie! Folose\u0219te link-ul \u00eentreg copiat \u00een pasul nr.2, \u201dhttps:\/\/r3.minicrm.io\/Api\/SharedFilter..etc\u201d.<\/strong><\/div>\n

Ar trebui s\u0103 vezi fereastra similar, apoi apas\u0103 pe Next<\/strong>:<\/p>\n

\"\"<\/p>\n

 <\/p>\n

Urm\u0103torul pas este s\u0103 ape\u0219i pe pictograma \u00eencercuit\u0103<\/strong> din imagine, apoi pe \u201dClose & Load<\/strong>\u201d:<\/p>\n

\"\"<\/p>\n

 <\/p>\n

Po\u021bi seta rata de refresh al acestui filtru ap\u0103s\u00e2nd pe Data<\/strong>, apoi Queries & Connections.<\/strong> Apas\u0103 apoi pe cele 3 puncte<\/strong> \u00eencercuite \u00een imaginea de mai jos, urmat de Properties<\/strong>, apoi pe \u201dRefresh data when opening the file<\/strong>\u201d \u0219i apoi salveaz\u0103<\/strong>.<\/p>\n

\"\"<\/p>\n

\"\" \"\"<\/p>\n

 <\/p>\n

Dac\u0103 dup\u0103 acest ultim pas ai primit un mesaj de eroare<\/em>, tot ce trebuie s\u0103 faci este s\u0103 ape\u0219i pe Ok<\/strong>, apoi pe cele 3 puncte<\/strong> \u00eencercuite \u00een imagine, \u0219i apoi pe \u201dRefresh<\/strong>\u201d.<\/p>\n

\"\"<\/p>\n","protected":false},"excerpt":{"rendered":"

Po\u021bi exporta datele dintr-un filtru sincronizat cu Google Sheets (Foile de calcul Google) folosind varianta online Excel prin metoda Power Query. Prima dat\u0103, asigur\u0103-te c\u0103 ai construit filtrul \u0219i c\u0103 ai activ\u0103 func\u021bia \u201eSincronizare foi de calcul Google\u201d. Dac\u0103 nu ai mai creat p\u00e2n\u0103 acum un filtru, te rog s\u0103 consul\u021bi pagina noastr\u0103 pe acest […]<\/p>\n","protected":false},"author":124,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2535],"tags":[],"class_list":["post-61667","post","type-post","status-publish","format-standard","hentry","category-depanare-si-intrebari-frecvente"],"yoast_head":"\nSincronizarea datelor folosind Excel Power Query - Documenta\u021bie MiniCRM<\/title>\n<meta name=\"description\" content=\"Po\u021bi exporta datele dintr-un filtru sincronizat cu Google Sheets (Foile de calcul Google) folosind varianta online Excel prin metoda Power Query. Prima\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.minicrm.ro\/help\/sincronizarea-datelor-folosind-excel-power-query\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Sincronizarea datelor folosind Excel Power Query - Documenta\u021bie MiniCRM\" \/>\n<meta property=\"og:description\" content=\"Po\u021bi exporta datele dintr-un filtru sincronizat cu Google Sheets (Foile de calcul Google) folosind varianta online Excel prin metoda Power Query. Prima\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.minicrm.ro\/help\/sincronizarea-datelor-folosind-excel-power-query\/\" \/>\n<meta property=\"og:site_name\" content=\"Documenta\u021bie MiniCRM\" \/>\n<meta property=\"article:published_time\" content=\"2026-03-05T13:53:32+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-03-05T15:13:02+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/minicrm-wp-help.s3.amazonaws.com\/uploads\/2026\/03\/Screenshot-2026-03-05-at-15.48.52.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1\" \/>\n\t<meta property=\"og:image:height\" content=\"1\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Ioana Badea\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Ioana Badea\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.minicrm.ro\/help\/sincronizarea-datelor-folosind-excel-power-query\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.minicrm.ro\/help\/sincronizarea-datelor-folosind-excel-power-query\/\"},\"author\":{\"name\":\"Ioana Badea\",\"@id\":\"https:\/\/www.minicrm.hu\/help\/#\/schema\/person\/e4d1a3ff85c8f2789c94dc8b0cb55abd\"},\"headline\":\"Sincronizarea datelor folosind Excel Power Query\",\"datePublished\":\"2026-03-05T13:53:32+00:00\",\"dateModified\":\"2026-03-05T15:13:02+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.minicrm.ro\/help\/sincronizarea-datelor-folosind-excel-power-query\/\"},\"wordCount\":324,\"image\":{\"@id\":\"https:\/\/www.minicrm.ro\/help\/sincronizarea-datelor-folosind-excel-power-query\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/minicrm-wp-help.s3.amazonaws.com\/uploads\/2026\/03\/Screenshot-2026-03-05-at-15.48.52.png\",\"articleSection\":[\"Depanare \u0219i \u00centreb\u0103ri frecvente\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.minicrm.ro\/help\/sincronizarea-datelor-folosind-excel-power-query\/\",\"url\":\"https:\/\/www.minicrm.ro\/help\/sincronizarea-datelor-folosind-excel-power-query\/\",\"name\":\"Sincronizarea datelor folosind Excel Power Query - Documenta\u021bie MiniCRM\",\"isPartOf\":{\"@id\":\"https:\/\/www.minicrm.hu\/help\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.minicrm.ro\/help\/sincronizarea-datelor-folosind-excel-power-query\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.minicrm.ro\/help\/sincronizarea-datelor-folosind-excel-power-query\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/minicrm-wp-help.s3.amazonaws.com\/uploads\/2026\/03\/Screenshot-2026-03-05-at-15.48.52.png\",\"datePublished\":\"2026-03-05T13:53:32+00:00\",\"dateModified\":\"2026-03-05T15:13:02+00:00\",\"author\":{\"@id\":\"https:\/\/www.minicrm.hu\/help\/#\/schema\/person\/e4d1a3ff85c8f2789c94dc8b0cb55abd\"},\"description\":\"Po\u021bi exporta datele dintr-un filtru sincronizat cu Google Sheets (Foile de calcul Google) folosind varianta online Excel prin metoda Power Query. Prima\",\"breadcrumb\":{\"@id\":\"https:\/\/www.minicrm.ro\/help\/sincronizarea-datelor-folosind-excel-power-query\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.minicrm.ro\/help\/sincronizarea-datelor-folosind-excel-power-query\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.minicrm.ro\/help\/sincronizarea-datelor-folosind-excel-power-query\/#primaryimage\",\"url\":\"https:\/\/minicrm-wp-help.s3.amazonaws.com\/uploads\/2026\/03\/Screenshot-2026-03-05-at-15.48.52.png\",\"contentUrl\":\"https:\/\/minicrm-wp-help.s3.amazonaws.com\/uploads\/2026\/03\/Screenshot-2026-03-05-at-15.48.52.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.minicrm.ro\/help\/sincronizarea-datelor-folosind-excel-power-query\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.minicrm.hu\/help\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Sincronizarea datelor folosind Excel Power Query\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.minicrm.hu\/help\/#website\",\"url\":\"https:\/\/www.minicrm.hu\/help\/\",\"name\":\"Documenta\u021bie MiniCRM\",\"description\":\"Welcome to MiniCRM\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.minicrm.hu\/help\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.minicrm.hu\/help\/#\/schema\/person\/e4d1a3ff85c8f2789c94dc8b0cb55abd\",\"name\":\"Ioana Badea\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.minicrm.hu\/help\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ed478f791cc778385969612b8c4f45fcf3cb4c12081700c33bf99ef86a6a37b6?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ed478f791cc778385969612b8c4f45fcf3cb4c12081700c33bf99ef86a6a37b6?s=96&d=mm&r=g\",\"caption\":\"Ioana Badea\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Sincronizarea datelor folosind Excel Power Query - Documenta\u021bie MiniCRM","description":"Po\u021bi exporta datele dintr-un filtru sincronizat cu Google Sheets (Foile de calcul Google) folosind varianta online Excel prin metoda Power Query. Prima","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:\/\/www.minicrm.ro\/help\/sincronizarea-datelor-folosind-excel-power-query\/","og_locale":"en_US","og_type":"article","og_title":"Sincronizarea datelor folosind Excel Power Query - Documenta\u021bie MiniCRM","og_description":"Po\u021bi exporta datele dintr-un filtru sincronizat cu Google Sheets (Foile de calcul Google) folosind varianta online Excel prin metoda Power Query. Prima","og_url":"https:\/\/www.minicrm.ro\/help\/sincronizarea-datelor-folosind-excel-power-query\/","og_site_name":"Documenta\u021bie MiniCRM","article_published_time":"2026-03-05T13:53:32+00:00","article_modified_time":"2026-03-05T15:13:02+00:00","og_image":[{"url":"https:\/\/minicrm-wp-help.s3.amazonaws.com\/uploads\/2026\/03\/Screenshot-2026-03-05-at-15.48.52.png","width":1,"height":1,"type":"image\/png"}],"author":"Ioana Badea","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Ioana Badea","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.minicrm.ro\/help\/sincronizarea-datelor-folosind-excel-power-query\/#article","isPartOf":{"@id":"https:\/\/www.minicrm.ro\/help\/sincronizarea-datelor-folosind-excel-power-query\/"},"author":{"name":"Ioana Badea","@id":"https:\/\/www.minicrm.hu\/help\/#\/schema\/person\/e4d1a3ff85c8f2789c94dc8b0cb55abd"},"headline":"Sincronizarea datelor folosind Excel Power Query","datePublished":"2026-03-05T13:53:32+00:00","dateModified":"2026-03-05T15:13:02+00:00","mainEntityOfPage":{"@id":"https:\/\/www.minicrm.ro\/help\/sincronizarea-datelor-folosind-excel-power-query\/"},"wordCount":324,"image":{"@id":"https:\/\/www.minicrm.ro\/help\/sincronizarea-datelor-folosind-excel-power-query\/#primaryimage"},"thumbnailUrl":"https:\/\/minicrm-wp-help.s3.amazonaws.com\/uploads\/2026\/03\/Screenshot-2026-03-05-at-15.48.52.png","articleSection":["Depanare \u0219i \u00centreb\u0103ri frecvente"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.minicrm.ro\/help\/sincronizarea-datelor-folosind-excel-power-query\/","url":"https:\/\/www.minicrm.ro\/help\/sincronizarea-datelor-folosind-excel-power-query\/","name":"Sincronizarea datelor folosind Excel Power Query - Documenta\u021bie MiniCRM","isPartOf":{"@id":"https:\/\/www.minicrm.hu\/help\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.minicrm.ro\/help\/sincronizarea-datelor-folosind-excel-power-query\/#primaryimage"},"image":{"@id":"https:\/\/www.minicrm.ro\/help\/sincronizarea-datelor-folosind-excel-power-query\/#primaryimage"},"thumbnailUrl":"https:\/\/minicrm-wp-help.s3.amazonaws.com\/uploads\/2026\/03\/Screenshot-2026-03-05-at-15.48.52.png","datePublished":"2026-03-05T13:53:32+00:00","dateModified":"2026-03-05T15:13:02+00:00","author":{"@id":"https:\/\/www.minicrm.hu\/help\/#\/schema\/person\/e4d1a3ff85c8f2789c94dc8b0cb55abd"},"description":"Po\u021bi exporta datele dintr-un filtru sincronizat cu Google Sheets (Foile de calcul Google) folosind varianta online Excel prin metoda Power Query. Prima","breadcrumb":{"@id":"https:\/\/www.minicrm.ro\/help\/sincronizarea-datelor-folosind-excel-power-query\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.minicrm.ro\/help\/sincronizarea-datelor-folosind-excel-power-query\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.minicrm.ro\/help\/sincronizarea-datelor-folosind-excel-power-query\/#primaryimage","url":"https:\/\/minicrm-wp-help.s3.amazonaws.com\/uploads\/2026\/03\/Screenshot-2026-03-05-at-15.48.52.png","contentUrl":"https:\/\/minicrm-wp-help.s3.amazonaws.com\/uploads\/2026\/03\/Screenshot-2026-03-05-at-15.48.52.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.minicrm.ro\/help\/sincronizarea-datelor-folosind-excel-power-query\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.minicrm.hu\/help\/"},{"@type":"ListItem","position":2,"name":"Sincronizarea datelor folosind Excel Power Query"}]},{"@type":"WebSite","@id":"https:\/\/www.minicrm.hu\/help\/#website","url":"https:\/\/www.minicrm.hu\/help\/","name":"Documenta\u021bie MiniCRM","description":"Welcome to MiniCRM","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.minicrm.hu\/help\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.minicrm.hu\/help\/#\/schema\/person\/e4d1a3ff85c8f2789c94dc8b0cb55abd","name":"Ioana Badea","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.minicrm.hu\/help\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/ed478f791cc778385969612b8c4f45fcf3cb4c12081700c33bf99ef86a6a37b6?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ed478f791cc778385969612b8c4f45fcf3cb4c12081700c33bf99ef86a6a37b6?s=96&d=mm&r=g","caption":"Ioana Badea"}}]}},"_links":{"self":[{"href":"https:\/\/www.minicrm.hu\/help\/wp-json\/wp\/v2\/posts\/61667","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.minicrm.hu\/help\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.minicrm.hu\/help\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.minicrm.hu\/help\/wp-json\/wp\/v2\/users\/124"}],"replies":[{"embeddable":true,"href":"https:\/\/www.minicrm.hu\/help\/wp-json\/wp\/v2\/comments?post=61667"}],"version-history":[{"count":4,"href":"https:\/\/www.minicrm.hu\/help\/wp-json\/wp\/v2\/posts\/61667\/revisions"}],"predecessor-version":[{"id":61732,"href":"https:\/\/www.minicrm.hu\/help\/wp-json\/wp\/v2\/posts\/61667\/revisions\/61732"}],"wp:attachment":[{"href":"https:\/\/www.minicrm.hu\/help\/wp-json\/wp\/v2\/media?parent=61667"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.minicrm.hu\/help\/wp-json\/wp\/v2\/categories?post=61667"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.minicrm.hu\/help\/wp-json\/wp\/v2\/tags?post=61667"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}