{"id":188153,"date":"2019-07-26T09:55:14","date_gmt":"2019-07-26T09:55:14","guid":{"rendered":"https:\/\/webkul.com\/blog\/?p=188153"},"modified":"2024-10-29T11:15:09","modified_gmt":"2024-10-29T11:15:09","slug":"use-of-csv-files-for-bulk-upload","status":"publish","type":"post","link":"https:\/\/webkul.com\/blog\/use-of-csv-files-for-bulk-upload\/","title":{"rendered":"Use of CSV files for Bulk Upload"},"content":{"rendered":"\n<p>The e-Commerce business industry trends keep on increasing at a higher pace and so as the will to develop an online multi-seller marketplace. <\/p>\n\n\n\n<p>As we know converting a store into a fully-fledged marketplace requires to put a ton of effort. <\/p>\n\n\n\n<p>From the very prior step of <span style=\"text-decoration: underline;\">adding sellers in bulk<\/span> to <span style=\"text-decoration: underline;\">allow sellers to bulk upload products<\/span>, every step requires the things to work in a systematic manner. <\/p>\n\n\n\n<p>Now, to minimize the effort, you can use CSV files to perform these bulk tasks.<\/p>\n\n\n\n<p>Through this guide, we will walk through the general guidelines of Use of CSV files in bulk uploads. <\/p>\n\n\n\n<h4 class=\"wp-block-heading\">What CSV exactly is?<\/h4>\n\n\n\n<p>CSV stands for &#8220;<strong>Comma-separated Value<\/strong>&#8221; file is a basic file format that helps the user to save data in a tabular form. <\/p>\n\n\n\n<p>CSV stores tabular data in a plain text with a comma separator. Each line of tabular data will be a record &amp; each record consist of multiple fields separated by commas. <\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" width=\"1288\" height=\"532\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2019\/07\/25071004\/Screenshot-8-3.png\" alt=\"Screenshot-8-3\" class=\"wp-image-188587\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2019\/07\/25071004\/Screenshot-8-3.png 1288w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2019\/07\/25071004\/Screenshot-8-3.png 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2019\/07\/25071004\/Screenshot-8-3.png 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2019\/07\/25071004\/Screenshot-8-3.png 768w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2019\/07\/25071004\/Screenshot-8-3.png 1200w\" sizes=\"(max-width: 1288px) 100vw, 1288px\" loading=\"lazy\" \/><\/figure>\n\n\n\n<p>So, if you own a <a aria-label=\"marketplace with Shopify (opens in a new tab)\" href=\"https:\/\/webkul.com\/blog\/shopify-multivendor-marketplace-new-theme-launched\/\" target=\"_blank\" rel=\"noreferrer noopener\">marketplace with Shopify<\/a>, You might have experienced a massive use of CSV files for uploading products in bulk, adding sellers, export &amp; import of store data, etc. <\/p>\n\n\n\n<p>Before using the CSV files for bulk tasks, you must understand the CSV formats &amp; have a good practice of using it.<\/p>\n\n\n\n<p>So, let&#8217;s proceed to learn how to use CSV file on a multi-seller marketplace &amp; in case you sell products on auction.<\/p>\n\n\n\n<p><a rel=\"noreferrer noopener\" aria-label=\"Learn to Convert Your Store into a Marketplace (opens in a new tab)\" href=\"https:\/\/marketplace.webkul.com\/add-ons\/shopify\/\" target=\"_blank\">Learn to Convert Your Store into a Marketplace<\/a>!<\/p>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">How Useful a CSV file is?<\/h2>\n\n\n\n<p>CSV files are widely used in data migration from one platform to another. <\/p>\n\n\n\n<p>With the use of CSV files, you can easily transfer all your existing customer&#8217;s accounts as well as product &amp; order details via CSV file in a go. <\/p>\n\n\n\n<p>This is why a large number of companies prefer to use the CSV files to import or export a high volume of data.<\/p>\n\n\n\n<p>The Multi-vendor Marketplace users prefer to use the CSV files to perform the following actions:-<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p>-Use CSV files to import-export product details.<br>-Import-Export App labels for translation.<br>-Add products in bulk via CSV upload.<br>-Add sellers via CSV. <br>-Allow sellers to add products in bulk via CSV.<\/p>\n<\/blockquote>\n\n\n\n<p>As CSV files are widely used for your eCommerce store, you need to find a manageable way to use the CSV file perfectly on your Shopify store. <\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p><strong><a aria-label=\"Shopify (opens in a new tab)\" href=\"https:\/\/shopify.com\/free-trial?ref=webkul\" target=\"_blank\" rel=\"noreferrer noopener\">Shopify<\/a> believes that Google Spreadsheets work perfectly with the CSV files. <\/strong><\/p>\n<\/blockquote>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" width=\"1252\" height=\"487\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2019\/07\/25070235\/Screenshot-7-3.png\" alt=\"Google Spreadsheet\" class=\"wp-image-188585\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2019\/07\/25070235\/Screenshot-7-3.png 1252w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2019\/07\/25070235\/Screenshot-7-3.png 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2019\/07\/25070235\/Screenshot-7-3.png 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2019\/07\/25070235\/Screenshot-7-3.png 768w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2019\/07\/25070235\/Screenshot-7-3.png 1200w\" sizes=\"(max-width: 1252px) 100vw, 1252px\" loading=\"lazy\" \/><figcaption class=\"wp-element-caption\">Google Spreadsheet<\/figcaption><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><\/h2>\n\n\n\n<div class=\"wk-index-wrap\"><h3 class=\"index-title\">How to Use Google Spreadsheet in creating a CSV file?<\/h3><\/div><div class=\"margin-bottom-50\">\n<p>It&#8217;s always painless to use a spreadsheet program to edit a CSV file. <\/p>\n\n\n\n<p>This is the reason the Multi-vendor Marketplace app provides sample CSV files for <strong>bulk product upload<\/strong>, <strong>add seller via CSV<\/strong>, etc. <\/p>\n\n\n\n<p>You can easily download the sample CSV in the app &amp; edit it using Google Spreadsheet.<\/p>\n\n\n\n<p>For this, let&#8217;s walk through the steps to understand the complete process of how to use Google Spreadsheets:<\/p>\n\n\n\n<p>Sign in\/Log in to <a href=\"https:\/\/docs.google.com\/spreadsheets\/\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"Google Account (opens in a new tab)\">Google Account<\/a>.<\/p>\n\n\n\n<p>In the side menus, You will get the option to <strong>select the Google Sheet<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" width=\"1273\" height=\"487\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2019\/07\/25110531\/AwesomeScreenshot-Google-Sheets-2019-07-25-16-07-40.png\" alt=\"Google sheets\" class=\"wp-image-188682\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2019\/07\/25110531\/AwesomeScreenshot-Google-Sheets-2019-07-25-16-07-40.png 1273w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2019\/07\/25110531\/AwesomeScreenshot-Google-Sheets-2019-07-25-16-07-40.png 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2019\/07\/25110531\/AwesomeScreenshot-Google-Sheets-2019-07-25-16-07-40.png 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2019\/07\/25110531\/AwesomeScreenshot-Google-Sheets-2019-07-25-16-07-40.png 768w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2019\/07\/25110531\/AwesomeScreenshot-Google-Sheets-2019-07-25-16-07-40.png 1200w\" sizes=\"(max-width: 1273px) 100vw, 1273px\" loading=\"lazy\" \/><\/figure>\n\n\n\n<p><strong>Select a blank sheet<\/strong> to get started.<\/p>\n\n\n\n<p>Now, the best option is to<strong> import the CSV file into the Google Spreadsheet<\/strong>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>IMPORT CSV FILES TO GOOGLE SHEET<\/strong><\/h2>\n\n\n\n<p>For this, you need to click the <strong>File<\/strong> menu where you will get the <strong>Import<\/strong> Option.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" width=\"1286\" height=\"512\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2019\/07\/25111227\/Screenshot1-5.png\" alt=\"Import CSV\" class=\"wp-image-188686\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2019\/07\/25111227\/Screenshot1-5.png 1286w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2019\/07\/25111227\/Screenshot1-5.png 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2019\/07\/25111227\/Screenshot1-5.png 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2019\/07\/25111227\/Screenshot1-5.png 768w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2019\/07\/25111227\/Screenshot1-5.png 1200w\" sizes=\"(max-width: 1286px) 100vw, 1286px\" loading=\"lazy\" \/><\/figure>\n\n\n\n<p>Clicking the Import button, a pop-up appears and you will get the option to <strong>upload the CSV file<\/strong>. You can upload the sample CSV file over there that you have downloaded from the app. <\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" width=\"1286\" height=\"640\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2019\/07\/25111608\/AwesomeScreenshot-Untitled-spreadsheet-Google-Sheets-2019-07-25-16-07-75.png\" alt=\"CSV file Upload\" class=\"wp-image-188690\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2019\/07\/25111608\/AwesomeScreenshot-Untitled-spreadsheet-Google-Sheets-2019-07-25-16-07-75.png 1286w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2019\/07\/25111608\/AwesomeScreenshot-Untitled-spreadsheet-Google-Sheets-2019-07-25-16-07-75.png 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2019\/07\/25111608\/AwesomeScreenshot-Untitled-spreadsheet-Google-Sheets-2019-07-25-16-07-75.png 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2019\/07\/25111608\/AwesomeScreenshot-Untitled-spreadsheet-Google-Sheets-2019-07-25-16-07-75.png 768w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2019\/07\/25111608\/AwesomeScreenshot-Untitled-spreadsheet-Google-Sheets-2019-07-25-16-07-75.png 1200w\" sizes=\"(max-width: 1286px) 100vw, 1286px\" loading=\"lazy\" \/><\/figure>\n\n\n\n<p>Once the CSV file gets uploaded, you can proceed to <strong>import the CSV file data<\/strong> &amp; then an option to <strong>Open the imported CSV file<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" width=\"1286\" height=\"640\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2019\/07\/25112512\/AwesomeScreenshot-Untitled-spreadsheet-Google-Sheets-2019-07-25-16-07-06.png\" alt=\"Open Now\" class=\"wp-image-188700\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2019\/07\/25112512\/AwesomeScreenshot-Untitled-spreadsheet-Google-Sheets-2019-07-25-16-07-06.png 1286w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2019\/07\/25112512\/AwesomeScreenshot-Untitled-spreadsheet-Google-Sheets-2019-07-25-16-07-06.png 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2019\/07\/25112512\/AwesomeScreenshot-Untitled-spreadsheet-Google-Sheets-2019-07-25-16-07-06.png 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2019\/07\/25112512\/AwesomeScreenshot-Untitled-spreadsheet-Google-Sheets-2019-07-25-16-07-06.png 768w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2019\/07\/25112512\/AwesomeScreenshot-Untitled-spreadsheet-Google-Sheets-2019-07-25-16-07-06.png 1200w\" sizes=\"(max-width: 1286px) 100vw, 1286px\" loading=\"lazy\" \/><\/figure>\n\n\n\n<p>Once you click the<strong> Open now<\/strong> button, you will get the imported file. You can now <strong>edit<\/strong> or <strong>update<\/strong> the file data as per the requirement. <\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" width=\"1286\" height=\"640\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2019\/07\/25113419\/AwesomeScreenshot-seller-products-Google-Sheets-2019-07-25-16-07-76.png\" alt=\"Imported sheet\" class=\"wp-image-188709\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2019\/07\/25113419\/AwesomeScreenshot-seller-products-Google-Sheets-2019-07-25-16-07-76.png 1286w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2019\/07\/25113419\/AwesomeScreenshot-seller-products-Google-Sheets-2019-07-25-16-07-76.png 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2019\/07\/25113419\/AwesomeScreenshot-seller-products-Google-Sheets-2019-07-25-16-07-76.png 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2019\/07\/25113419\/AwesomeScreenshot-seller-products-Google-Sheets-2019-07-25-16-07-76.png 768w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2019\/07\/25113419\/AwesomeScreenshot-seller-products-Google-Sheets-2019-07-25-16-07-76.png 1200w\" sizes=\"(max-width: 1286px) 100vw, 1286px\" loading=\"lazy\" \/><\/figure>\n\n\n\n<p>Once you are done with the changes, you can export the current file by download it as .csv (Comma Separated files). <\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p>Make sure that the <strong>CSV file includes UTF 8 encoding<\/strong>\u00a0to avoid the unwanted generation of special characters in the CSV file.<\/p>\n<\/blockquote>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>EXPORT CSV FILE FROM GOOGLE SHEET<\/strong><\/h2>\n\n\n\n<p>All You need to do is just follow the below-given simple steps:-<\/p>\n\n\n\n<p>On the same spreadsheet page, go to the <strong>File<\/strong> menu &amp; select the <strong>Download<\/strong> option from the drop-down menu. <\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" width=\"1233\" height=\"560\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2019\/07\/25121310\/Screenshot2-6.png\" alt=\"Screenshot2-6\" class=\"wp-image-188744\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2019\/07\/25121310\/Screenshot2-6.png 1233w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2019\/07\/25121310\/Screenshot2-6.png 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2019\/07\/25121310\/Screenshot2-6.png 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2019\/07\/25121310\/Screenshot2-6.png 768w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2019\/07\/25121310\/Screenshot2-6.png 1200w\" sizes=\"(max-width: 1233px) 100vw, 1233px\" loading=\"lazy\" \/><\/figure>\n\n\n\n<p>Click the <strong>Comma-separated values<\/strong> option to export the CSV file to your system. <\/p>\n\n\n\n<p>Done! Go ahead &amp; get the file from the Downloads!<\/p>\n\n\n\n<p>This is the best use of CSV files.<\/p>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Set Field Values while editing CSV file Columns<\/h2>\n\n\n\n<p>Shopify lets you sell physical as well as digital products online. So, you have to be more careful while editing certain fields in the CSV file. <\/p>\n\n\n\n<p>For <strong>Variant requires Shipping<\/strong>:- You need to set the column field to TRUE if the variant is a physical product else set it to FALSE.<\/p>\n\n\n\n<p>For <strong>Variant Taxable<\/strong>:- Set it to TRUE if the variant includes tax else FALSE.<\/p>\n\n\n\n<p>Now, For <strong>Variant Grams<\/strong>:- Enter a value if the <strong>Variant requires Shipping<\/strong> is set to TRUE.<br>Set it to 0 if the <strong>Variant requires Shipping<\/strong> is set to FALSE.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><\/h2>\n\n\n\n<div class=\"wk-index-wrap\"><h3 class=\"index-title\">Conclusion<\/h3><\/div><div class=\"margin-bottom-50\">\n<p>In order to perform bulk tasks, the Google spreadsheet is highly recommended to make edits in the CSV files. You can simply import the file, edit it as per the need &amp; export the CSV files.<\/p>\n\n\n\n<p>Text editors can also be used to edit CSV files but prefer to use it in case you get formatting errors in the CSV files. <\/p>\n\n\n\n<p>Thus, the probability of getting CSV errors will be comparatively less if you opt for the Google Spreadsheet program.<\/p>\n<\/div>\n\n\n\n<p><a rel=\"noreferrer noopener\" aria-label=\"Do Avoid the Mistakes (opens in a new tab)\" href=\"https:\/\/webkul.com\/blog\/multi-vendor-marketplace-for-shopify-guide-to-upload-products-via-csv\/\" target=\"_blank\"><strong>Do Avoid the Mistakes<\/strong><\/a> while Uploading CSV to Multi-vendor Marketplace App!<\/p>\n\n\n\n<p>Feel Free to <strong><a href=\"https:\/\/webkul.uvdesk.com\/en\/customer\/create-ticket\/\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"connect (opens in a new tab)\">connect<\/a><\/strong> in case of any query.<\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>The e-Commerce business industry trends keep on increasing at a higher pace and so as the will to develop an online multi-seller marketplace. As we know converting a store into a fully-fledged marketplace requires to put a ton of effort. From the very prior step of adding sellers in bulk to allow sellers to bulk <a href=\"https:\/\/webkul.com\/blog\/use-of-csv-files-for-bulk-upload\/\">[&#8230;]<\/a><\/p>\n","protected":false},"author":183,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[15592,3569,4236,841],"tags":[9385,9393,9390,9391,837,9384,9387,9313,9392,9383,9321,9310,9318,9386,9388,9314,9317,9389,8659,8730],"class_list":["post-188153","post","type-post","status-publish","format-standard","hentry","category-knowledge-base-webkul-product-auction","category-multivendor-shopify-2","category-multivendor-marketplace","category-shopify","tag-csv","tag-csv-for-shopify","tag-csv-shopify","tag-csv-to-shopify","tag-shopify","tag-shopify-csv","tag-shopify-csv-file","tag-shopify-csv-file-explained","tag-shopify-csv-files","tag-shopify-csv-guide","tag-shopify-csv-import","tag-shopify-csv-product-import","tag-shopify-csv-products","tag-shopify-import","tag-shopify-import-csv","tag-shopify-import-csv-help","tag-shopify-import-products","tag-shopify-product-csv-file","tag-shopify-store","tag-shopify-tutorial"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Use of CSV Files for Bulk Upload | Use Google Spreadsheets<\/title>\n<meta name=\"description\" content=\"In this Guide to use CSV file in the bulk tasks, you will get to know the simplest way to import or export CSV files using Google Spreadsheet\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/webkul.com\/blog\/use-of-csv-files-for-bulk-upload\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Use of CSV Files for Bulk Upload | Use Google Spreadsheets\" \/>\n<meta property=\"og:description\" content=\"In this Guide to use CSV file in the bulk tasks, you will get to know the simplest way to import or export CSV files using Google Spreadsheet\" \/>\n<meta property=\"og:url\" content=\"https:\/\/webkul.com\/blog\/use-of-csv-files-for-bulk-upload\/\" \/>\n<meta property=\"og:site_name\" content=\"Webkul Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/webkul\/\" \/>\n<meta property=\"article:published_time\" content=\"2019-07-26T09:55:14+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-10-29T11:15:09+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/webkul.com\/blog\/wp-content\/uploads\/2019\/07\/Screenshot-8-3.png\" \/>\n<meta name=\"author\" content=\"Supriya Srivastava\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@webkul\" \/>\n<meta name=\"twitter:site\" content=\"@webkul\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Supriya Srivastava\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. 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:\/\/webkul.com\/blog\/use-of-csv-files-for-bulk-upload\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/webkul.com\/blog\/use-of-csv-files-for-bulk-upload\/\"},\"author\":{\"name\":\"Supriya Srivastava\",\"@id\":\"https:\/\/webkul.com\/blog\/#\/schema\/person\/82e882f9d26265c50d20efca6f27f973\"},\"headline\":\"Use of CSV files for Bulk Upload\",\"datePublished\":\"2019-07-26T09:55:14+00:00\",\"dateModified\":\"2024-10-29T11:15:09+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/webkul.com\/blog\/use-of-csv-files-for-bulk-upload\/\"},\"wordCount\":950,\"commentCount\":2,\"publisher\":{\"@id\":\"https:\/\/webkul.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/webkul.com\/blog\/use-of-csv-files-for-bulk-upload\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/webkul.com\/blog\/wp-content\/uploads\/2019\/07\/Screenshot-8-3.png\",\"keywords\":[\"csv\",\"csv for shopify\",\"csv shopify\",\"csv to shopify\",\"shopify\",\"shopify csv\",\"shopify csv file\",\"shopify csv file explained\",\"shopify csv files\",\"shopify csv guide\",\"shopify csv import\",\"shopify csv product import\",\"shopify csv products\",\"shopify import\",\"shopify import csv\",\"shopify import csv help\",\"shopify import products\",\"shopify product csv file\",\"shopify store\",\"shopify tutorial\"],\"articleSection\":[\"Knowledge base webkul product auction\",\"multivendor\",\"Multivendor Marketplace\",\"Shopify\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/webkul.com\/blog\/use-of-csv-files-for-bulk-upload\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/webkul.com\/blog\/use-of-csv-files-for-bulk-upload\/\",\"url\":\"https:\/\/webkul.com\/blog\/use-of-csv-files-for-bulk-upload\/\",\"name\":\"Use of CSV Files for Bulk Upload | Use Google Spreadsheets\",\"isPartOf\":{\"@id\":\"https:\/\/webkul.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/webkul.com\/blog\/use-of-csv-files-for-bulk-upload\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/webkul.com\/blog\/use-of-csv-files-for-bulk-upload\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/webkul.com\/blog\/wp-content\/uploads\/2019\/07\/Screenshot-8-3.png\",\"datePublished\":\"2019-07-26T09:55:14+00:00\",\"dateModified\":\"2024-10-29T11:15:09+00:00\",\"description\":\"In this Guide to use CSV file in the bulk tasks, you will get to know the simplest way to import or export CSV files using Google Spreadsheet\",\"breadcrumb\":{\"@id\":\"https:\/\/webkul.com\/blog\/use-of-csv-files-for-bulk-upload\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/webkul.com\/blog\/use-of-csv-files-for-bulk-upload\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/webkul.com\/blog\/use-of-csv-files-for-bulk-upload\/#primaryimage\",\"url\":\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2019\/07\/25071004\/Screenshot-8-3.png\",\"contentUrl\":\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2019\/07\/25071004\/Screenshot-8-3.png\",\"width\":1288,\"height\":532,\"caption\":\"Screenshot-8-3\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/webkul.com\/blog\/use-of-csv-files-for-bulk-upload\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/webkul.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Use of CSV files for Bulk Upload\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/webkul.com\/blog\/#website\",\"url\":\"https:\/\/webkul.com\/blog\/\",\"name\":\"Webkul Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/webkul.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/webkul.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/webkul.com\/blog\/#organization\",\"name\":\"WebKul Software Private Limited\",\"url\":\"https:\/\/webkul.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/webkul.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/08\/webkul-logo-accent-sq.png\",\"contentUrl\":\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/08\/webkul-logo-accent-sq.png\",\"width\":380,\"height\":380,\"caption\":\"WebKul Software Private Limited\"},\"image\":{\"@id\":\"https:\/\/webkul.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/webkul\/\",\"https:\/\/x.com\/webkul\",\"https:\/\/www.instagram.com\/webkul\/\",\"https:\/\/www.linkedin.com\/company\/webkul\",\"https:\/\/www.youtube.com\/user\/webkul\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/webkul.com\/blog\/#\/schema\/person\/82e882f9d26265c50d20efca6f27f973\",\"name\":\"Supriya Srivastava\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/webkul.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/01a0336285ee18d95bdb526260e11e31f9329f011ca4e492c66b84651cb36281?s=96&d=https%3A%2F%2Fcdnblog.webkul.com%2Fblog%2Fwp-content%2Fuploads%2F2019%2F10%2Feva.png&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/01a0336285ee18d95bdb526260e11e31f9329f011ca4e492c66b84651cb36281?s=96&d=https%3A%2F%2Fcdnblog.webkul.com%2Fblog%2Fwp-content%2Fuploads%2F2019%2F10%2Feva.png&r=g\",\"caption\":\"Supriya Srivastava\"},\"url\":\"https:\/\/webkul.com\/blog\/author\/supriya-srivastava691\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Use of CSV Files for Bulk Upload | Use Google Spreadsheets","description":"In this Guide to use CSV file in the bulk tasks, you will get to know the simplest way to import or export CSV files using Google Spreadsheet","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:\/\/webkul.com\/blog\/use-of-csv-files-for-bulk-upload\/","og_locale":"en_US","og_type":"article","og_title":"Use of CSV Files for Bulk Upload | Use Google Spreadsheets","og_description":"In this Guide to use CSV file in the bulk tasks, you will get to know the simplest way to import or export CSV files using Google Spreadsheet","og_url":"https:\/\/webkul.com\/blog\/use-of-csv-files-for-bulk-upload\/","og_site_name":"Webkul Blog","article_publisher":"https:\/\/www.facebook.com\/webkul\/","article_published_time":"2019-07-26T09:55:14+00:00","article_modified_time":"2024-10-29T11:15:09+00:00","og_image":[{"url":"https:\/\/webkul.com\/blog\/wp-content\/uploads\/2019\/07\/Screenshot-8-3.png","type":"","width":"","height":""}],"author":"Supriya Srivastava","twitter_card":"summary_large_image","twitter_creator":"@webkul","twitter_site":"@webkul","twitter_misc":{"Written by":"Supriya Srivastava","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/webkul.com\/blog\/use-of-csv-files-for-bulk-upload\/#article","isPartOf":{"@id":"https:\/\/webkul.com\/blog\/use-of-csv-files-for-bulk-upload\/"},"author":{"name":"Supriya Srivastava","@id":"https:\/\/webkul.com\/blog\/#\/schema\/person\/82e882f9d26265c50d20efca6f27f973"},"headline":"Use of CSV files for Bulk Upload","datePublished":"2019-07-26T09:55:14+00:00","dateModified":"2024-10-29T11:15:09+00:00","mainEntityOfPage":{"@id":"https:\/\/webkul.com\/blog\/use-of-csv-files-for-bulk-upload\/"},"wordCount":950,"commentCount":2,"publisher":{"@id":"https:\/\/webkul.com\/blog\/#organization"},"image":{"@id":"https:\/\/webkul.com\/blog\/use-of-csv-files-for-bulk-upload\/#primaryimage"},"thumbnailUrl":"https:\/\/webkul.com\/blog\/wp-content\/uploads\/2019\/07\/Screenshot-8-3.png","keywords":["csv","csv for shopify","csv shopify","csv to shopify","shopify","shopify csv","shopify csv file","shopify csv file explained","shopify csv files","shopify csv guide","shopify csv import","shopify csv product import","shopify csv products","shopify import","shopify import csv","shopify import csv help","shopify import products","shopify product csv file","shopify store","shopify tutorial"],"articleSection":["Knowledge base webkul product auction","multivendor","Multivendor Marketplace","Shopify"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/webkul.com\/blog\/use-of-csv-files-for-bulk-upload\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/webkul.com\/blog\/use-of-csv-files-for-bulk-upload\/","url":"https:\/\/webkul.com\/blog\/use-of-csv-files-for-bulk-upload\/","name":"Use of CSV Files for Bulk Upload | Use Google Spreadsheets","isPartOf":{"@id":"https:\/\/webkul.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/webkul.com\/blog\/use-of-csv-files-for-bulk-upload\/#primaryimage"},"image":{"@id":"https:\/\/webkul.com\/blog\/use-of-csv-files-for-bulk-upload\/#primaryimage"},"thumbnailUrl":"https:\/\/webkul.com\/blog\/wp-content\/uploads\/2019\/07\/Screenshot-8-3.png","datePublished":"2019-07-26T09:55:14+00:00","dateModified":"2024-10-29T11:15:09+00:00","description":"In this Guide to use CSV file in the bulk tasks, you will get to know the simplest way to import or export CSV files using Google Spreadsheet","breadcrumb":{"@id":"https:\/\/webkul.com\/blog\/use-of-csv-files-for-bulk-upload\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/webkul.com\/blog\/use-of-csv-files-for-bulk-upload\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/webkul.com\/blog\/use-of-csv-files-for-bulk-upload\/#primaryimage","url":"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2019\/07\/25071004\/Screenshot-8-3.png","contentUrl":"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2019\/07\/25071004\/Screenshot-8-3.png","width":1288,"height":532,"caption":"Screenshot-8-3"},{"@type":"BreadcrumbList","@id":"https:\/\/webkul.com\/blog\/use-of-csv-files-for-bulk-upload\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/webkul.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Use of CSV files for Bulk Upload"}]},{"@type":"WebSite","@id":"https:\/\/webkul.com\/blog\/#website","url":"https:\/\/webkul.com\/blog\/","name":"Webkul Blog","description":"","publisher":{"@id":"https:\/\/webkul.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/webkul.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/webkul.com\/blog\/#organization","name":"WebKul Software Private Limited","url":"https:\/\/webkul.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/webkul.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/08\/webkul-logo-accent-sq.png","contentUrl":"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/08\/webkul-logo-accent-sq.png","width":380,"height":380,"caption":"WebKul Software Private Limited"},"image":{"@id":"https:\/\/webkul.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/webkul\/","https:\/\/x.com\/webkul","https:\/\/www.instagram.com\/webkul\/","https:\/\/www.linkedin.com\/company\/webkul","https:\/\/www.youtube.com\/user\/webkul\/"]},{"@type":"Person","@id":"https:\/\/webkul.com\/blog\/#\/schema\/person\/82e882f9d26265c50d20efca6f27f973","name":"Supriya Srivastava","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/webkul.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/01a0336285ee18d95bdb526260e11e31f9329f011ca4e492c66b84651cb36281?s=96&d=https%3A%2F%2Fcdnblog.webkul.com%2Fblog%2Fwp-content%2Fuploads%2F2019%2F10%2Feva.png&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/01a0336285ee18d95bdb526260e11e31f9329f011ca4e492c66b84651cb36281?s=96&d=https%3A%2F%2Fcdnblog.webkul.com%2Fblog%2Fwp-content%2Fuploads%2F2019%2F10%2Feva.png&r=g","caption":"Supriya Srivastava"},"url":"https:\/\/webkul.com\/blog\/author\/supriya-srivastava691\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/posts\/188153","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/users\/183"}],"replies":[{"embeddable":true,"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/comments?post=188153"}],"version-history":[{"count":19,"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/posts\/188153\/revisions"}],"predecessor-version":[{"id":472349,"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/posts\/188153\/revisions\/472349"}],"wp:attachment":[{"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/media?parent=188153"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/categories?post=188153"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/tags?post=188153"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}