{"id":7059,"date":"2021-03-12T18:02:41","date_gmt":"2021-03-12T18:02:41","guid":{"rendered":"https:\/\/when2work.com\/help\/mgr\/?page_id=7059"},"modified":"2021-03-12T18:05:10","modified_gmt":"2021-03-12T18:05:10","slug":"what-is-a-csv-file","status":"publish","type":"page","link":"https:\/\/when2work.com\/help\/mgr\/what-is-a-csv-file\/","title":{"rendered":"What is a CSV file? How can I create one?"},"content":{"rendered":"<p>CSV (comma separated values) files can be used to upload some data (<a href=\"https:\/\/when2work.com\/help\/mgr\/h-import-emps\/\">employees<\/a> and <a href=\"https:\/\/when2work.com\/help\/mgr\/uploading-shifts-from-file\/\" target=\"_blank\" rel=\"noopener\">shifts<\/a>) into our system.\u00a0<\/p>\n<p>The definition is &#8220;a delimited text file that uses a comma to separate values. Each line of the file is a data record. Each record consists of one or more fields, separated by commas.&#8221;<\/p>\n<p>You can save a spreadsheet in this format, ex. Excel or Google Sheets.<\/p>\n<h2>Excel:<\/h2>\n<p><strong>File<\/strong> &gt;<strong> Export<\/strong> &gt; <strong>Change File Types<\/strong> &gt; <strong>CSV<\/strong><\/p>\n<h2>Google Sheets<\/h2>\n<p><b>File <\/b>&gt;\u00a0<b>Download as\u00a0<\/b>and select file type <strong>Comma Separated Values, CSV.<\/strong> Then select <b>Open\u00a0<\/b>or\u00a0<b>Save<\/b>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>CSV (comma separated values) files can be used to upload some data (employees and shifts) into our system.\u00a0 The definition is &#8220;a delimited text file&#8230;<\/p>\n<div class=\"more-link-wrapper\"><a class=\"more-link\" href=\"https:\/\/when2work.com\/help\/mgr\/what-is-a-csv-file\/\">More<span class=\"screen-reader-text\">What is a CSV file? How can I create one?<\/span><\/a><\/div>\n","protected":false},"author":2,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":[],"_links":{"self":[{"href":"https:\/\/when2work.com\/help\/mgr\/wp-json\/wp\/v2\/pages\/7059"}],"collection":[{"href":"https:\/\/when2work.com\/help\/mgr\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/when2work.com\/help\/mgr\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/when2work.com\/help\/mgr\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/when2work.com\/help\/mgr\/wp-json\/wp\/v2\/comments?post=7059"}],"version-history":[{"count":4,"href":"https:\/\/when2work.com\/help\/mgr\/wp-json\/wp\/v2\/pages\/7059\/revisions"}],"predecessor-version":[{"id":7063,"href":"https:\/\/when2work.com\/help\/mgr\/wp-json\/wp\/v2\/pages\/7059\/revisions\/7063"}],"wp:attachment":[{"href":"https:\/\/when2work.com\/help\/mgr\/wp-json\/wp\/v2\/media?parent=7059"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}