{"id":2285,"date":"2024-01-03T17:50:15","date_gmt":"2024-01-03T15:50:15","guid":{"rendered":"https:\/\/bitimpulse.com\/?post_type=manual&#038;p=2285"},"modified":"2025-01-10T15:42:20","modified_gmt":"2025-01-10T13:42:20","slug":"microsoft-excel-workbook-csv-file-yak-dzherelo-danyh","status":"publish","type":"manual","link":"https:\/\/bitimpulse.com\/en\/manual\/microsoft-excel-workbook-csv-file-yak-dzherelo-danyh\/","title":{"rendered":"Microsoft Excel workbook\/ CSV file as a data source"},"content":{"rendered":"<p>Move to the \u201cData Sources\u201d tab:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/7_1.png\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-2286\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/7_1.png\" alt=\"\" width=\"988\" height=\"756\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/7_1.png 988w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/7_1-450x344.png 450w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/7_1-300x230.png 300w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/7_1-768x588.png 768w\" sizes=\"(max-width: 988px) 100vw, 988px\" \/><\/a><\/p>\n<p>In the form that appears, select the \u201cMicrosoft Excel workbook\u201d \/ \u201cCSV\u201d file data source:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/7_2-1.png\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-8998\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/7_2-1.png\" alt=\"\" width=\"790\" height=\"545\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/7_2-1.png 790w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/7_2-1-450x310.png 450w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/7_2-1-300x207.png 300w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/7_2-1-768x530.png 768w\" sizes=\"(max-width: 790px) 100vw, 790px\" \/><\/a><\/p>\n<p>As the next step, specify the file location:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/7_3-1.png\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-8999\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/7_3-1.png\" alt=\"\" width=\"790\" height=\"545\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/7_3-1.png 790w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/7_3-1-450x310.png 450w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/7_3-1-300x207.png 300w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/7_3-1-768x530.png 768w\" sizes=\"(max-width: 790px) 100vw, 790px\" \/><\/a><\/p>\n<p>Now specify the import parameters used to retrieve the data from the file:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/7_4.png\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-2289\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/7_4.png\" alt=\"\" width=\"799\" height=\"552\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/7_4.png 799w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/7_4-450x311.png 450w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/7_4-300x207.png 300w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/7_4-768x531.png 768w\" sizes=\"(max-width: 799px) 100vw, 799px\" \/><\/a><\/p>\n<p>The following parameters are available:<\/p>\n<ul>\n<li>Use values of the first row as field names \u2013 specifies whether or not to use the values \u200b\u200bof the first row as field names. If you disable this option, the field names will be generated automatically;<\/li>\n<li>Skip empty rows \u2013 whether or not to include empty rows into the resulting data source;<\/li>\n<li>Skip hidden rows &#8211; whether or not to ignore hidden lines when importing data to the data source;<\/li>\n<li>Skip hidden columns &#8211; whether or not to ignore hidden columns when importing data to the data source.<\/li>\n<\/ul>\n<p>Select the needed parameters and click \u00abNext\u00bb. A form appears, in which you can select a worksheet containing the required data, a table:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/7_5.png\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-2290\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/7_5.png\" alt=\"\" width=\"795\" height=\"550\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/7_5.png 795w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/7_5-450x311.png 450w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/7_5-300x208.png 300w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/7_5-768x531.png 768w\" sizes=\"(max-width: 795px) 100vw, 795px\" \/><\/a><\/p>\n<p>During the last step you can select the columns to include them in the data source and specify their settings. In the \u201cName\u201d column, you can specify a column name, and using \u201cType\u201d &#8211; specify its type:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/7_6.png\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-2291\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/7_6.png\" alt=\"\" width=\"796\" height=\"550\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/7_6.png 796w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/7_6-450x311.png 450w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/7_6-300x207.png 300w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/7_6-768x531.png 768w\" sizes=\"(max-width: 796px) 100vw, 796px\" \/><\/a><\/p>\n<p>After clicking the \u00abFinish\u00bb button, the data source is created and its fields are displayed in the data source browser:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/7_7.png\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-2292\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/7_7.png\" alt=\"\" width=\"617\" height=\"695\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/7_7.png 617w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/7_7-399x450.png 399w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/7_7-266x300.png 266w\" sizes=\"(max-width: 617px) 100vw, 617px\" \/><\/a><\/p>","protected":false},"featured_media":0,"parent":0,"menu_order":17,"template":"","manuals":[16],"class_list":["post-2285","manual","type-manual","status-publish","hentry","manuals-bat-admin"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/manual\/2285","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/manual"}],"about":[{"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/types\/manual"}],"wp:attachment":[{"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/media?parent=2285"}],"wp:term":[{"taxonomy":"manuals","embeddable":true,"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/manuals?post=2285"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}