{"id":178597,"date":"2024-03-28T09:21:00","date_gmt":"2024-03-28T08:21:00","guid":{"rendered":"https:\/\/datascientest.com\/en\/?p=178597"},"modified":"2024-02-14T19:14:21","modified_gmt":"2024-02-14T18:14:21","slug":"csv-document-how-do-i-import-a-csv-into-power-bi","status":"publish","type":"post","link":"https:\/\/datascientest.com\/en\/csv-document-how-do-i-import-a-csv-into-power-bi","title":{"rendered":"CSV.Document: How do I import a CSV into Power BI?"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"178597\" class=\"elementor elementor-178597\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-19a1a1c e-flex e-con-boxed e-con\" data-id=\"19a1a1c\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-7267014 elementor-widget elementor-widget-heading\" data-id=\"7267014\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-heading-title{padding:0;margin:0;line-height:1}.elementor-widget-heading .elementor-heading-title[class*=elementor-size-]>a{color:inherit;font-size:inherit;line-height:inherit}.elementor-widget-heading .elementor-heading-title.elementor-size-small{font-size:15px}.elementor-widget-heading .elementor-heading-title.elementor-size-medium{font-size:19px}.elementor-widget-heading .elementor-heading-title.elementor-size-large{font-size:29px}.elementor-widget-heading .elementor-heading-title.elementor-size-xl{font-size:39px}.elementor-widget-heading .elementor-heading-title.elementor-size-xxl{font-size:59px}<\/style><h2 class=\"elementor-heading-title elementor-size-default\">CSV.Document is a feature of Power Query on Microsoft Excel and Power BI, making it easy to load CSV files in table format. Find out everything you need to know about how it works, its usefulness and its benefits!<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-16c1092 e-flex e-con-boxed e-con\" data-id=\"16c1092\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-4e4dc23 elementor-widget elementor-widget-text-editor\" data-id=\"4e4dc23\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-text-editor.elementor-drop-cap-view-stacked .elementor-drop-cap{background-color:#69727d;color:#fff}.elementor-widget-text-editor.elementor-drop-cap-view-framed .elementor-drop-cap{color:#69727d;border:3px solid;background-color:transparent}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap{margin-top:8px}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap-letter{width:1em;height:1em}.elementor-widget-text-editor .elementor-drop-cap{float:left;text-align:center;line-height:1;font-size:50px}.elementor-widget-text-editor .elementor-drop-cap-letter{display:inline-block}<\/style>\t\t\t\t<p>Invented even before the personal computer, the CSV (Comma-Separated Values) format is regarded as the standard for exchanging data between different applications and systems.<\/p><p>CSV files are easy to read and edit. However, handling them can be tedious when working with large volumes of data. In the age of Big Data, this limitation is problematic.<\/p><p>With Microsoft Excel and Power BI, the CSV.document function in Power Query&#8217;s M language is an invaluable aid. It enables users to load CSV files simply and efficiently.<\/p><p>\u00a0<\/p><p>\ud83d\udca1Related articles:<\/p><table dir=\"ltr\" border=\"1\" cellspacing=\"0\" cellpadding=\"0\" data-sheets-root=\"1\"><colgroup><col width=\"656\" \/><\/colgroup><tbody><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;Power BI waterfall chart: Overview and use cases&quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/en\/power-bi-waterfall-chart-overview-and-use-cases\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/en\/power-bi-waterfall-chart-overview-and-use-cases\" target=\"_blank\" rel=\"noopener\">Power BI waterfall chart: Overview and use cases<\/a><\/td><\/tr><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;Our Guide to Power BI KPI - Definition and Purpose&quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/en\/our-guide-to-power-bi-kpi-definition-and-purpose\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/en\/our-guide-to-power-bi-kpi-definition-and-purpose\" target=\"_blank\" rel=\"noopener\">Our Guide to Power BI KPI &#8211; Definition and Purpose<\/a><\/td><\/tr><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;The use of Power BI in Start-Ups&quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/en\/the-use-of-power-bi-in-start-ups\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/en\/the-use-of-power-bi-in-start-ups\" target=\"_blank\" rel=\"noopener\">The use of Power BI in Start-Ups<\/a><\/td><\/tr><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;Power BI Python: Harnessing the Synergy of tools Data Science&quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/en\/power-bi-python-harnessing-the-synergy-of-tools-data-science\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/en\/power-bi-python-harnessing-the-synergy-of-tools-data-science\" target=\"_blank\" rel=\"noopener\">Power BI Python: Harnessing the Synergy of tools Data Science<\/a><\/td><\/tr><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;Power Query Date Format: How to change it on Excel and Power BI&quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/en\/power-query-date-format-how-to-change-it-on-excel-and-power-bi\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/en\/power-query-date-format-how-to-change-it-on-excel-and-power-bi\" target=\"_blank\" rel=\"noopener\">Power Query Date Format: How to change it on Excel and Power BI<\/a><\/td><\/tr><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;Power BI Direct Query vs Import: Which to choose?&quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/en\/power-bi-direct-query-vs-import-which-to-choose\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/en\/power-bi-direct-query-vs-import-which-to-choose\" target=\"_blank\" rel=\"noopener\">Power BI Direct Query vs Import: Which to choose?<\/a><\/td><\/tr><\/tbody><\/table>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-9dbbdc1 e-flex e-con-boxed e-con\" data-id=\"9dbbdc1\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-824ee27 elementor-widget elementor-widget-heading\" data-id=\"824ee27\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">What is a CSV?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-12db221 elementor-widget elementor-widget-text-editor\" data-id=\"12db221\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>A<strong> CSV is a text file containing data<\/strong> structured in the form of a table. Within this file, each line represents a row in the table.<\/p><p>Each field in a line is separated by a comma, hence the name &#8220;Comma-Separated Values&#8221;.<\/p><p>A file can be opened or modified with any text editor, including Notepad. The strength of this format is that it can be read by a large number of applications and systems.<\/p><p>This makes it easy to use this type of file for <strong>data exchange<\/strong>. However, with the massive increase in the volume of data, the task becomes more complicated.<\/p><p>CSV files containing a lot of data are very large, and can take a very long time to load. The<a href=\"https:\/\/datascientest.com\/en\/power-query-what-is-it-whats-it-for\"> Power Query engine avoids this inconvenience.<\/a><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-04be15c e-flex e-con-boxed e-con\" data-id=\"04be15c\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-702218f elementor-widget elementor-widget-heading\" data-id=\"702218f\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">What is Power Query?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c0bea09 elementor-widget elementor-widget-text-editor\" data-id=\"c0bea09\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>The <a href=\"https:\/\/datascientest.com\/en\/power-query-date-format-how-to-change-it-on-excel-and-power-bi\">Power Query data transformation<\/a> and preparation engine enables users to load, transform and merge data from multiple sources in Microsoft Excel, Power BI and <a href=\"https:\/\/datascientest.com\/en\/power-virtual-agents-everything-you-need-to-know-about-the-chatbot-creation-tool\">other Power Platform products.<\/a><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-37e20b0 elementor-widget elementor-widget-image\" data-id=\"37e20b0\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-image{text-align:center}.elementor-widget-image a{display:inline-block}.elementor-widget-image a img[src$=\".svg\"]{width:48px}.elementor-widget-image img{vertical-align:middle;display:inline-block}<\/style>\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/03\/Illu_BLOG_power_platform_power_platform.jpg\" title=\"\" alt=\"\" loading=\"lazy\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e7fd6e2 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"e7fd6e2\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/en\/power-bi-training\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Learn how to use Power Query<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-015473a elementor-widget elementor-widget-text-editor\" data-id=\"015473a\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Its intuitive graphical interface lets you filter, sort and manipulate data without any programming knowledge.<\/p><p>Data is retrieved from a variety of sources,<a href=\"https:\/\/datascientest.com\/en\/sql-learn-all-about-the-programming-language-for-databases\"> including SQL databases,<\/a> web pages, XML files and CSV files.<\/p><p>It is then stored in a table, which the user can interact with. The data can be filtered and sorted, or modified as required.<\/p><p>Power Query&#8217;s M programming language is used to transform or manipulate data in Power Platform tools such as Excel and Power BI. It can be used to create queries to import, clean and transform data.<\/p><p>To load the contents of a <strong>CSV file into Microsoft Excel or Power BI<\/strong> in the form of a table with Power Query, use the CSV.Documents function in the M language.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-476fc3c e-flex e-con-boxed e-con\" data-id=\"476fc3c\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-c9d7880 elementor-widget elementor-widget-heading\" data-id=\"c9d7880\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">How do I use CSV.Document on Power Query?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f34d5af elementor-widget elementor-widget-text-editor\" data-id=\"f34d5af\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>The<strong> Csv.Document function<\/strong> is used to import and transform data stored in a CSV file stored locally or on a remote server, and then transform it into a structured table for analysis and display.<\/p><p>Its syntax is as follows:<\/p><p>= Csv.Document(file, optional options)<\/p><p>The &#8216;file&#8217; parameter indicates the location of the<strong> CSV file<\/strong> to be imported. The &#8216;options&#8217; parameter is used to specify additional options for reading the file.<\/p><p>These include the field separation character, character encoding or the absence of column headers. By default, the &#8216;Delimiter&#8217; is a comma, but it is possible to use a different delimiter.<\/p><p>The &#8220;Encoding&#8221; option designates the character encoding to be used to read the<strong> CSV file<\/strong>. By default, Power Query automatically detects the correct encoding by analysing the file.<\/p><p>Once the data has been imported, other Power Query functions can be used to transform the data, such as Split Column, Group By or Filter Rows. Here&#8217;s an example:<\/p><p>let<\/p><p>Source = Csv.Document(File.Contents(&#8220;C:\\monfichier.csv&#8221;),[Delimiter=&#8221;,&#8221;, Columns=5, Encoding=1252, QuoteStyle=QuoteStyle.None]),<\/p><p>#&#8221;First row header&#8221; = Table.PromoteHeaders(Source),<\/p><p>in<\/p><p>#First header row<\/p><p>In this case, <strong>CSV.Document is used to load a CSV file<\/strong> stored on the computer&#8217;s hard disk with a comma delimiter and 5 columns. The File.Contents function is used to specify the location of the CSV file, and Table.PromoteHeaders is used to promote the first row of the CSV file as column headers in the resulting Power Query table.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a7e85ca elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"a7e85ca\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/en\/power-bi-training\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Start a Power BI training with DataScientest<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-0238f05 e-flex e-con-boxed e-con\" data-id=\"0238f05\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-3ea845b elementor-widget elementor-widget-heading\" data-id=\"3ea845b\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Advantages of CSV.Document over Power Query<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1237a01 elementor-widget elementor-widget-text-editor\" data-id=\"1237a01\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Using a <strong>CSV.Document with Power Query<\/strong> offers a number of advantages. It simplifies the import of CSV files into Excel, while enabling data transformations to be carried out.<\/p><p>This saves invaluable time, since it is no longer necessary to enter data manually. The import process is also automated. What&#8217;s more, importing data in the form of a structured table makes it easier to handle and analyse.<\/p><p>What&#8217;s more, <strong>Power Query<\/strong> can be configured to automatically update data whenever a CSV file is modified. This eliminates the risk of human error and ensures that the data is always up to date.<\/p><p>Power Query&#8217;s compatibility with many other sources also means that you can work with different types of data from a centralised interface.<\/p><p>Finally, by integrating data from different sources into a<strong> single CSV file,<\/strong> a single table can be generated for easy analysis.<\/p><p>\u00a0<\/p><p>\ud83d\udca1Related articles:<\/p><table dir=\"ltr\" border=\"1\" cellspacing=\"0\" cellpadding=\"0\" data-sheets-root=\"1\"><colgroup><col width=\"656\" \/><\/colgroup><tbody><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;Power BI: Microsoft's Business Intelligence solution&quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/en\/power-bi-microsofts-business-intelligence-solution\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/en\/power-bi-microsofts-business-intelligence-solution\" target=\"_blank\" rel=\"noopener\">Power BI: Microsoft&#8217;s Business Intelligence solution<\/a><\/td><\/tr><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;DAX Power BI: all about the query programming language&quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/en\/dax-power-bi-all-about-the-query-programming-language\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/en\/dax-power-bi-all-about-the-query-programming-language\" target=\"_blank\" rel=\"noopener\">DAX Power BI: all about the query programming language<\/a><\/td><\/tr><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;Dataflow Power BI: everything you need to know about the self-service ETL tool&quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/en\/dataflow-power-bi-everything-you-need-to-know-about-the-self-service-etl-tool\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/en\/dataflow-power-bi-everything-you-need-to-know-about-the-self-service-etl-tool\" target=\"_blank\" rel=\"noopener\">Dataflow Power BI: everything you need to know about the self-service ETL tool<\/a><\/td><\/tr><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;Power BI Direct Query: All you need to know about this data query method &quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/en\/power-bi-direct-query-all-you-need-to-know-about-this-data-query-method\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/en\/power-bi-direct-query-all-you-need-to-know-about-this-data-query-method\" target=\"_blank\" rel=\"noopener\">Power BI Direct Query: All you need to know about this data query method <\/a><\/td><\/tr><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;Power BI license: What does it cost? &quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/en\/power-bi-license-how-much-does-the-microsoft-solution-cost\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/en\/power-bi-license-how-much-does-the-microsoft-solution-cost\" target=\"_blank\" rel=\"noopener\">Power BI license: What does it cost? <\/a><\/td><\/tr><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;Power BI vs. Tableau: Two tools &quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/en\/power-bi-vs-tableau\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/en\/power-bi-vs-tableau\" target=\"_blank\" rel=\"noopener\">Power BI vs. Tableau: Two tools <\/a><\/td><\/tr><\/tbody><\/table>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-ca5c99b e-flex e-con-boxed e-con\" data-id=\"ca5c99b\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-6114e41 elementor-widget elementor-widget-heading\" data-id=\"6114e41\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Conclusion: CSV.Document, a simple method for importing into Excel<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4d10bed elementor-widget elementor-widget-text-editor\" data-id=\"4d10bed\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>In conclusion, CSV.Document <a href=\"https:\/\/datascientest.com\/en\/formulas-in-power-query-formulas-the-best-of-them\">Power Query<\/a> is a very useful feature for importing large CSV files in table form into Excel or Power BI rather than copying the data manually.<\/p><p>To learn how to master Power BI and all its subtleties, you can choose DataScientest. Our Power BI training course gives you complete mastery of the software in just 38 hours spread over 5 days.<\/p><p>The first part of the course takes 3 days and covers<a href=\"https:\/\/datascientest.com\/en\/power-query-m-switch-how-does-it-work\"> Power Query,<\/a> the Dax language and the <a href=\"https:\/\/datascientest.com\/en\/dataviz-definition-objectives-and-uses\">basics of dataviz.<\/a> The second part lasts 2 days, and allows you to learn how to use the tool in greater depth, while discovering advanced concepts such as incremental updating and DataFlows.<\/p><p>You can take the whole course, or just one of the two parts, depending on your level and needs. At the end of the course, you can sit the<strong> Power BI Data Analyst Associate certification exam.<\/strong><\/p><p>This programme can be completed entirely by distance learning via the web, and our organisation is <strong>eligible for funding options.<\/strong> Discover DataScientest!<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b915632 elementor-widget elementor-widget-image\" data-id=\"b915632\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/03\/formations-datascientest.jpg\" title=\"\" alt=\"\" loading=\"lazy\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f2ef000 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"f2ef000\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/en\/power-bi-training\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Discover our Power BI training<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-6c0a5f2 e-flex e-con-boxed e-con\" data-id=\"6c0a5f2\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-c930647 elementor-widget elementor-widget-html\" data-id=\"c930647\" data-element_type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<script type=\"application\/ld+json\">\n{\n  \"@context\": \"https:\/\/schema.org\",\n  \"@type\": \"FAQPage\",\n  \"mainEntity\": [{\n    \"@type\": \"Question\",\n    \"name\": \"What is a CSV?\",\n    \"acceptedAnswer\": {\n      \"@type\": \"Answer\",\n      \"text\": \"A CSV is a text file containing data structured in the form of a table. Within this file, each line represents a row in the table.  Each field in a row is separated by a comma, which is where the name Comma-Separated Values comes from. A file can be opened or modified with any text editor, including Notepad. So the great thing about this format is that it can be read by a large number of applications and systems.\"\n    }\n  },{\n    \"@type\": \"Question\",\n    \"name\": \"What is Power Query?\",\n    \"acceptedAnswer\": {\n      \"@type\": \"Answer\",\n      \"text\": \"The Power Query data transformation and preparation engine allows users to load, transform and merge data from multiple sources across Microsoft Excel, Power BI and other Power Platform products.\"\n    }\n  },{\n    \"@type\": \"Question\",\n    \"name\": \"How do I use CSV.Document on Power Query?\",\n    \"acceptedAnswer\": {\n      \"@type\": \"Answer\",\n      \"text\": \"The Csv.Document function allows you to import and transform data stored in a CSV file stored locally or on a remote server, then transform it into a structured table for analysis and visualisation.\"\n    }\n  }]\n}\n<\/script>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>CSV.Document is a feature of Power Query on Microsoft Excel and Power BI, making it easy to load CSV files in table format. Find out everything you need to know about how it works, its usefulness and its benefits! Invented even before the personal computer, the CSV (Comma-Separated Values) format is regarded as the standard [&hellip;]<\/p>\n","protected":false},"author":67,"featured_media":178610,"comment_status":"open","ping_status":"open","sticky":false,"template":"elementor_theme","format":"standard","meta":{"content-type":"","inline_featured_image":false},"categories":[2420,46],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v21.7) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>CSV.Document: How do I import a CSV into Power BI?<\/title>\n<meta name=\"description\" content=\"CSV.Document is a feature of Power Query on Microsoft Excel and Power BI, making it easy to load CSV files in table format. Find out everything you need\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/datascientest.com\/en\/csv-document-how-do-i-import-a-csv-into-power-bi\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"CSV.Document: How do I import a CSV into Power BI?\" \/>\n<meta property=\"og:description\" content=\"CSV.Document is a feature of Power Query on Microsoft Excel and Power BI, making it easy to load CSV files in table format. Find out everything you need\" \/>\n<meta property=\"og:url\" content=\"https:\/\/datascientest.com\/en\/csv-document-how-do-i-import-a-csv-into-power-bi\" \/>\n<meta property=\"og:site_name\" content=\"Data Science Courses | DataScientest\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataScientestEN\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-28T08:21:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-02-14T18:14:21+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/datascientest.com\/en\/files\/2024\/02\/csv-power-bi.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1024\" \/>\n\t<meta property=\"og:image:height\" content=\"512\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Melanie\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataScientest__\" \/>\n<meta name=\"twitter:site\" content=\"@DataScientest__\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Melanie\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/datascientest.com\/en\/csv-document-how-do-i-import-a-csv-into-power-bi#article\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/en\/csv-document-how-do-i-import-a-csv-into-power-bi\"},\"author\":{\"name\":\"Melanie\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d\"},\"headline\":\"CSV.Document: How do I import a CSV into Power BI?\",\"datePublished\":\"2024-03-28T08:21:00+00:00\",\"dateModified\":\"2024-02-14T18:14:21+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/datascientest.com\/en\/csv-document-how-do-i-import-a-csv-into-power-bi\"},\"wordCount\":1140,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/datascientest.com\/en\/#organization\"},\"articleSection\":[\"Business Intelligence\",\"Non class\u00e9\"],\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/datascientest.com\/en\/csv-document-how-do-i-import-a-csv-into-power-bi#respond\"]}],\"copyrightYear\":\"2024\",\"copyrightHolder\":{\"@id\":\"https:\/\/datascientest.com\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/datascientest.com\/en\/csv-document-how-do-i-import-a-csv-into-power-bi\",\"url\":\"https:\/\/datascientest.com\/en\/csv-document-how-do-i-import-a-csv-into-power-bi\",\"name\":\"CSV.Document: How do I import a CSV into Power BI?\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/en\/#website\"},\"datePublished\":\"2024-03-28T08:21:00+00:00\",\"dateModified\":\"2024-02-14T18:14:21+00:00\",\"description\":\"CSV.Document is a feature of Power Query on Microsoft Excel and Power BI, making it easy to load CSV files in table format. Find out everything you need\",\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/datascientest.com\/en\/csv-document-how-do-i-import-a-csv-into-power-bi\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/datascientest.com\/en\/#website\",\"url\":\"https:\/\/datascientest.com\/en\/\",\"name\":\"Data Science Courses | DataScientest\",\"description\":\"Leader in Data Science Courses\",\"publisher\":{\"@id\":\"https:\/\/datascientest.com\/en\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/datascientest.com\/en\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/datascientest.com\/en\/#organization\",\"name\":\"DataScientest\",\"url\":\"https:\/\/datascientest.com\/en\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png\",\"contentUrl\":\"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png\",\"width\":301,\"height\":301,\"caption\":\"DataScientest\"},\"image\":{\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/DataScientestEN\",\"https:\/\/twitter.com\/DataScientest__\",\"https:\/\/www.linkedin.com\/school\/datascientest\/mycompany\/\",\"https:\/\/www.tiktok.com\/@datascientest\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d\",\"name\":\"Melanie\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g\",\"caption\":\"Melanie\"},\"url\":\"https:\/\/datascientest.com\/en\/author\/melaniekrause\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"CSV.Document: How do I import a CSV into Power BI?","description":"CSV.Document is a feature of Power Query on Microsoft Excel and Power BI, making it easy to load CSV files in table format. Find out everything you need","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:\/\/datascientest.com\/en\/csv-document-how-do-i-import-a-csv-into-power-bi","og_locale":"en_GB","og_type":"article","og_title":"CSV.Document: How do I import a CSV into Power BI?","og_description":"CSV.Document is a feature of Power Query on Microsoft Excel and Power BI, making it easy to load CSV files in table format. Find out everything you need","og_url":"https:\/\/datascientest.com\/en\/csv-document-how-do-i-import-a-csv-into-power-bi","og_site_name":"Data Science Courses | DataScientest","article_publisher":"https:\/\/www.facebook.com\/DataScientestEN","article_published_time":"2024-03-28T08:21:00+00:00","article_modified_time":"2024-02-14T18:14:21+00:00","og_image":[{"width":1024,"height":512,"url":"https:\/\/datascientest.com\/en\/files\/2024\/02\/csv-power-bi.png","type":"image\/png"}],"author":"Melanie","twitter_card":"summary_large_image","twitter_creator":"@DataScientest__","twitter_site":"@DataScientest__","twitter_misc":{"Written by":"Melanie","Estimated reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/datascientest.com\/en\/csv-document-how-do-i-import-a-csv-into-power-bi#article","isPartOf":{"@id":"https:\/\/datascientest.com\/en\/csv-document-how-do-i-import-a-csv-into-power-bi"},"author":{"name":"Melanie","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d"},"headline":"CSV.Document: How do I import a CSV into Power BI?","datePublished":"2024-03-28T08:21:00+00:00","dateModified":"2024-02-14T18:14:21+00:00","mainEntityOfPage":{"@id":"https:\/\/datascientest.com\/en\/csv-document-how-do-i-import-a-csv-into-power-bi"},"wordCount":1140,"commentCount":0,"publisher":{"@id":"https:\/\/datascientest.com\/en\/#organization"},"articleSection":["Business Intelligence","Non class\u00e9"],"inLanguage":"en-GB","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/datascientest.com\/en\/csv-document-how-do-i-import-a-csv-into-power-bi#respond"]}],"copyrightYear":"2024","copyrightHolder":{"@id":"https:\/\/datascientest.com\/#organization"}},{"@type":"WebPage","@id":"https:\/\/datascientest.com\/en\/csv-document-how-do-i-import-a-csv-into-power-bi","url":"https:\/\/datascientest.com\/en\/csv-document-how-do-i-import-a-csv-into-power-bi","name":"CSV.Document: How do I import a CSV into Power BI?","isPartOf":{"@id":"https:\/\/datascientest.com\/en\/#website"},"datePublished":"2024-03-28T08:21:00+00:00","dateModified":"2024-02-14T18:14:21+00:00","description":"CSV.Document is a feature of Power Query on Microsoft Excel and Power BI, making it easy to load CSV files in table format. Find out everything you need","inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/datascientest.com\/en\/csv-document-how-do-i-import-a-csv-into-power-bi"]}]},{"@type":"WebSite","@id":"https:\/\/datascientest.com\/en\/#website","url":"https:\/\/datascientest.com\/en\/","name":"Data Science Courses | DataScientest","description":"Leader in Data Science Courses","publisher":{"@id":"https:\/\/datascientest.com\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/datascientest.com\/en\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/datascientest.com\/en\/#organization","name":"DataScientest","url":"https:\/\/datascientest.com\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/","url":"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png","contentUrl":"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png","width":301,"height":301,"caption":"DataScientest"},"image":{"@id":"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataScientestEN","https:\/\/twitter.com\/DataScientest__","https:\/\/www.linkedin.com\/school\/datascientest\/mycompany\/","https:\/\/www.tiktok.com\/@datascientest"]},{"@type":"Person","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d","name":"Melanie","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g","caption":"Melanie"},"url":"https:\/\/datascientest.com\/en\/author\/melaniekrause"}]}},"_links":{"self":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts\/178597"}],"collection":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/users\/67"}],"replies":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/comments?post=178597"}],"version-history":[{"count":0,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts\/178597\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/media\/178610"}],"wp:attachment":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/media?parent=178597"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/categories?post=178597"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/tags?post=178597"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}