{"id":115607,"date":"2021-09-04T13:24:00","date_gmt":"2021-09-04T10:24:00","guid":{"rendered":"https:\/\/howto.mediadoma.com\/?p=115607"},"modified":"2025-03-14T14:07:08","modified_gmt":"2025-03-14T11:07:08","slug":"excel-far-stod-for-dataimport-fran-pdf-tabeller-sa-har-anvander-du-det","status":"publish","type":"post","link":"https:\/\/howto.mediadoma.com\/sv\/excel-far-stod-for-dataimport-fran-pdf-tabeller-sa-har-anvander-du-det\/","title":{"rendered":"Excel f\u00e5r st\u00f6d f\u00f6r dataimport fr\u00e5n PDF-tabeller; S\u00e5 h\u00e4r anv\u00e4nder du det"},"content":{"rendered":"<p>Microsoft Excel fick nyligen st\u00f6d f\u00f6r en ny dataimporttyp som har l\u00e4nge kommit. Office 365-prenumeranter med de senaste Office-uppdateringarna installerade kan nu importera data fr\u00e5n tabeller i PDF-filer, vilket tar bort behovet av besv\u00e4rliga mellansteg.<\/p>\n<p>Funktionen tillk\u00e4nnagavs <a href=\"https:\/\/techcommunity.microsoft.com\/t5\/excel-blog\/announcing-data-import-from-pdf-documents\/ba-p\/1569202\" target=\"_blank\" rel=\"noopener nofollow\" class=\"external external_icon\">p\u00e5 Microsoft Tech Community-bloggen<\/a> tidigare denna m\u00e5nad. F\u00f6r att b\u00f6rja anv\u00e4nda data i en PDF \u00f6ppnar du f\u00f6rst din Excel-arbetsbok och byter till fliken Data i menyfliksomr\u00e5det.<\/p>\n<p><a href=\"https:\/\/howto.mediadoma.com\/wp-content\/uploads\/2021\/03\/post-25247-604ccff234908.png\" data-rel=\"lightbox\"><img decoding=\"async\" class=\"SDStudio-light-box-enable SDStudio-editor-tools-md-imp\" src=\"https:\/\/howto.mediadoma.com\/wp-content\/uploads\/2021\/03\/post-25247-604ccff234908.png\" alt=\"Excel f\u00e5r st\u00f6d f\u00f6r dataimport fr\u00e5n PDF-tabeller; S\u00e5 h\u00e4r anv\u00e4nder du det\" ><\/a><\/p>\n<p>Klicka p\u00e5 knappen &#8221;H\u00e4mta data&#8221; till v\u00e4nster om menyfliksomr\u00e5det och v\u00e4lj sedan kategorin &#8221;Fr\u00e5n fil&#8221;. V\u00e4lj sedan &#8221;Fr\u00e5n PDF&#8221; och v\u00e4lj din PDF-fil i filh\u00e4mtaren som kommer att visas.<\/p>\n<p>N\u00e4r du har hittat filen visas ett f\u00f6nster som visar alla tabeller i ditt PDF-dokument. Anv\u00e4nd prompten f\u00f6r att v\u00e4lja de tabeller du vill importera. Du kan v\u00e4lja att importera tabeller individuellt eller som flera val.<\/p>\n<p><a href=\"https:\/\/howto.mediadoma.com\/wp-content\/uploads\/2021\/03\/post-25247-604ccff4178f0.png\" data-rel=\"lightbox\"><img decoding=\"async\" class=\"SDStudio-light-box-enable SDStudio-editor-tools-md-imp\" src=\"https:\/\/howto.mediadoma.com\/wp-content\/uploads\/2021\/03\/post-25247-604ccff4178f0.png\" alt=\"Excel f\u00e5r st\u00f6d f\u00f6r dataimport fr\u00e5n PDF-tabeller; S\u00e5 h\u00e4r anv\u00e4nder du det\" ><\/a><\/p>\n<p>N\u00e4r du \u00e4r klar trycker du p\u00e5 &#8221;Ladda&#8221; f\u00f6r att l\u00e4gga till data i ditt Excel-kalkylblad. Data kan ocks\u00e5 anpassas f\u00f6re import med Power Query Editor (klicka p\u00e5 &#8221;Transform Data&#8221; -knappen i Navigator-f\u00f6nstret). Du hittar mer information om funktionen i <a href=\"https:\/\/docs.microsoft.com\/powerquery-m\/pdf-tables\" target=\"_blank\" rel=\"noopener nofollow\" class=\"external external_icon\">Pdf.Tables Power Query-dokumentationen<\/a>.<\/p>\n<p><div id=\"PostUnique_PostSource\" style=\"padding-top: 50px\">Inspelningsk\u00e4lla:  <a target=\"_blank\" rel=\"noopener nofollow\" href=\"\/\/www.onmsft.com\" class=\"external external_icon\">www.onmsft.com<\/a><\/div><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Microsoft Excel fick nyligen st\u00f6d f\u00f6r en ny dataimporttyp som har l\u00e4nge kommit. Office 365-prenumeranter med de senaste Office-uppdateringarna<\/p>\n","protected":false},"author":1,"featured_media":88889,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_wp_rev_ctl_limit":""},"categories":[1072],"tags":[3063],"class_list":["post-115607","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-hur","tag-affiai-sv"],"_links":{"self":[{"href":"https:\/\/howto.mediadoma.com\/sv\/wp-json\/wp\/v2\/posts\/115607","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/howto.mediadoma.com\/sv\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/howto.mediadoma.com\/sv\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/howto.mediadoma.com\/sv\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/howto.mediadoma.com\/sv\/wp-json\/wp\/v2\/comments?post=115607"}],"version-history":[{"count":1,"href":"https:\/\/howto.mediadoma.com\/sv\/wp-json\/wp\/v2\/posts\/115607\/revisions"}],"predecessor-version":[{"id":309004,"href":"https:\/\/howto.mediadoma.com\/sv\/wp-json\/wp\/v2\/posts\/115607\/revisions\/309004"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/howto.mediadoma.com\/sv\/wp-json\/wp\/v2\/media\/88889"}],"wp:attachment":[{"href":"https:\/\/howto.mediadoma.com\/sv\/wp-json\/wp\/v2\/media?parent=115607"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/howto.mediadoma.com\/sv\/wp-json\/wp\/v2\/categories?post=115607"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/howto.mediadoma.com\/sv\/wp-json\/wp\/v2\/tags?post=115607"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}