{"id":3297,"date":"2018-11-10T09:57:04","date_gmt":"2018-11-10T09:57:04","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=3297"},"modified":"2024-03-26T11:28:47","modified_gmt":"2024-03-26T11:28:47","slug":"convert-xlsx-file-to-csv","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/examples\/convert-xlsx-file-to-csv\/","title":{"rendered":"Convert XLSX File to CSV in Excel"},"content":{"rendered":"\n
Convert-XLSX-File-to-CSV<\/a>Download File<\/a><\/div>\n\n\n\n

The CSV (Comma separated file) is a great way to store data. You can open CSV files in a simple editor because they are stored as text. This format is used in many applications as an alternative way to exporting and importing data.<\/p>\n\n\n\n

How to convert XLSX file to CSV<\/h2>\n\n\n\n
    \n
  1. Copy the following example into the Excel sheet (cell A1<\/strong>).<\/li>\n<\/ol>\n\n\n\n
    First name<\/td>Last name<\/td>Sex<\/td>Age<\/td>State<\/td><\/tr>
    Emma<\/td>Smith<\/td>female<\/td>75<\/td>California<\/td><\/tr>
    Logan<\/td>Johnson<\/td>male<\/td>36<\/td>California<\/td><\/tr>
    Olivia<\/td>Williams<\/td>female<\/td>2<\/td>Texas<\/td><\/tr>
    James<\/td>Jones<\/td>male<\/td>75<\/td>California<\/td><\/tr>
    Noah<\/td>Brown<\/td>male<\/td>56<\/td>Texas<\/td><\/tr>
    Ava<\/td>Davis<\/td>female<\/td>68<\/td>Texas<\/td><\/tr>
    Sophia<\/td>Miller<\/td>female<\/td>41<\/td>Texas<\/td><\/tr>
    Mia<\/td>Wilson<\/td>female<\/td>14<\/td>California<\/td><\/tr>
    Liam<\/td>Moore<\/td>male<\/td>3<\/td>Texas<\/td><\/tr>
    Amelia<\/td>Taylor<\/td>female<\/td>42<\/td>Texas<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
      \n
    1. Go to File >> Save As >> Browse<\/strong> and choose CSV (Comma delimited) (*.csv) and save the file.<\/li>\n<\/ol>\n\n\n\n

      There are a few options when it comes to CSV format.<\/p>\n\n\n\n

      CSV (Comma delimited)<\/strong> – This format works with Windows systems.<\/p>\n\n\n\n

      CSV (Macintosh)<\/strong> – Use this format if you planning to use your file on the Macintosh computer.<\/p>\n\n\n\n

      CSV (MS-DOS)<\/strong> \u2013 This format is used for the older MS-DOS operating system.<\/p>\n\n\n\n

      \"\"<\/figure>\n\n\n\n
        \n
      1. If you have multiple sheets<\/a> in your workbook, Excel will ask you whether you want to the active one. You can\u2019t save multiple sheets at once. Click OK<\/strong>.<\/li>\n<\/ol>\n\n\n\n
        \"\"<\/figure>\n\n\n\n
          \n
        1. After this warning, the new one appears, informing you about potential data loss (eg. formatting). In our case, it\u2019s won\u2019t be a problem, so click Yes<\/strong>.<\/li>\n<\/ol>\n\n\n\n
          \"\"<\/figure>\n\n\n\n

          Opening file<\/h2>\n\n\n\n

          If you open your file in Excel, it will look like a normal xlsx file. Excel will automatically recognize delimiters and display data inside cells.<\/p>\n\n\n\n

          \"\"<\/figure>\n\n\n\n

          Try to open your file in a text editor, like notepad, and you have the following data.<\/p>\n\n\n\n

          \"\"<\/figure>\n\n\n\n

          As you can see, the text is separated by commas. It\u2019s ok, as long as there are no commas inside your text, otherwise, you are going to get messed up results. In such a case, you need to change the delimiter.<\/p>\n\n\n\n

          Choosing delimiter<\/h2>\n\n\n\n

          You can\u2019t set the delimiter when you save the CSV file<\/a>. If you want to choose a different delimiter than the default<\/a> one, you must perform the following steps.<\/p>\n\n\n\n

            \n
          1. In Windows Search Box, type Control Panel and click the icon.<\/li>\n\n\n\n
          2. Choose Clock and Region.<\/li>\n<\/ol>\n\n\n\n
            \"\"<\/figure>\n\n\n\n
              \n
            1. In the next window, choose Region.<\/li>\n<\/ol>\n\n\n\n
              \"\"<\/figure>\n\n\n\n
                \n
              1. From the Region window, click Additional Settings.<\/li>\n<\/ol>\n\n\n\n
                \"\"<\/figure>\n\n\n\n
                  \n
                1. In the new window, there is a position called List separator<\/strong>. Change it to a semicolon and save your excel file<\/a> as CSV. Now the data is separated by a semicolon.<\/li>\n<\/ol>\n\n\n\n
                  \"\"<\/figure>\n","protected":false},"excerpt":{"rendered":"

                  The CSV (Comma separated file) is a great way to store data. You can open CSV files in a simple editor because they…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[21],"tags":[170,190],"yoast_head":"\nConvert XLSX File to CSV in Excel<\/title>\n<meta name=\"description\" content=\"Learn how to convert XLSX file to CSV with this step-by-step guide. CSV files are great for storing data and easy to open in any simple text editor.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/officetuts.net\/excel\/examples\/convert-xlsx-file-to-csv\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Convert XLSX File to CSV in Excel\" \/>\n<meta property=\"og:description\" content=\"Learn how to convert XLSX file to CSV with this step-by-step guide. CSV files are great for storing data and easy to open in any simple text editor.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/officetuts.net\/excel\/examples\/convert-xlsx-file-to-csv\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-11-10T09:57:04+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-26T11:28:47+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/11\/csv-format.png\" \/>\n<meta name=\"author\" content=\"Tomasz Decker\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Tomasz Decker\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/convert-xlsx-file-to-csv\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/convert-xlsx-file-to-csv\/\"},\"author\":{\"name\":\"Tomasz Decker\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"headline\":\"Convert XLSX File to CSV in Excel\",\"datePublished\":\"2018-11-10T09:57:04+00:00\",\"dateModified\":\"2024-03-26T11:28:47+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/convert-xlsx-file-to-csv\/\"},\"wordCount\":421,\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/convert-xlsx-file-to-csv\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/11\/csv-format.png\",\"keywords\":[\"file\",\"pinterest\"],\"articleSection\":[\"examples\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/convert-xlsx-file-to-csv\/\",\"url\":\"https:\/\/officetuts.net\/excel\/examples\/convert-xlsx-file-to-csv\/\",\"name\":\"Convert XLSX File to CSV in Excel\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/convert-xlsx-file-to-csv\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/convert-xlsx-file-to-csv\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/11\/csv-format.png\",\"datePublished\":\"2018-11-10T09:57:04+00:00\",\"dateModified\":\"2024-03-26T11:28:47+00:00\",\"description\":\"Learn how to convert XLSX file to CSV with this step-by-step guide. CSV files are great for storing data and easy to open in any simple text editor.\",\"breadcrumb\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/convert-xlsx-file-to-csv\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/officetuts.net\/excel\/examples\/convert-xlsx-file-to-csv\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/convert-xlsx-file-to-csv\/#primaryimage\",\"url\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/11\/csv-format.png\",\"contentUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/11\/csv-format.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/convert-xlsx-file-to-csv\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/officetuts.net\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Convert XLSX File to CSV in Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/officetuts.net\/excel\/#website\",\"url\":\"https:\/\/officetuts.net\/excel\/\",\"name\":\"\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/officetuts.net\/excel\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\",\"name\":\"Tomasz Decker\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"caption\":\"Tomasz Decker\"},\"logo\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\"},\"description\":\"Spreadsheet and Python enthusiast.\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Convert XLSX File to CSV in Excel","description":"Learn how to convert XLSX file to CSV with this step-by-step guide. CSV files are great for storing data and easy to open in any simple text editor.","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:\/\/officetuts.net\/excel\/examples\/convert-xlsx-file-to-csv\/","og_locale":"en_US","og_type":"article","og_title":"Convert XLSX File to CSV in Excel","og_description":"Learn how to convert XLSX file to CSV with this step-by-step guide. CSV files are great for storing data and easy to open in any simple text editor.","og_url":"https:\/\/officetuts.net\/excel\/examples\/convert-xlsx-file-to-csv\/","article_published_time":"2018-11-10T09:57:04+00:00","article_modified_time":"2024-03-26T11:28:47+00:00","og_image":[{"url":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/11\/csv-format.png"}],"author":"Tomasz Decker","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Tomasz Decker","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/officetuts.net\/excel\/examples\/convert-xlsx-file-to-csv\/#article","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/examples\/convert-xlsx-file-to-csv\/"},"author":{"name":"Tomasz Decker","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"headline":"Convert XLSX File to CSV in Excel","datePublished":"2018-11-10T09:57:04+00:00","dateModified":"2024-03-26T11:28:47+00:00","mainEntityOfPage":{"@id":"https:\/\/officetuts.net\/excel\/examples\/convert-xlsx-file-to-csv\/"},"wordCount":421,"publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"image":{"@id":"https:\/\/officetuts.net\/excel\/examples\/convert-xlsx-file-to-csv\/#primaryimage"},"thumbnailUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/11\/csv-format.png","keywords":["file","pinterest"],"articleSection":["examples"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/officetuts.net\/excel\/examples\/convert-xlsx-file-to-csv\/","url":"https:\/\/officetuts.net\/excel\/examples\/convert-xlsx-file-to-csv\/","name":"Convert XLSX File to CSV in Excel","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/officetuts.net\/excel\/examples\/convert-xlsx-file-to-csv\/#primaryimage"},"image":{"@id":"https:\/\/officetuts.net\/excel\/examples\/convert-xlsx-file-to-csv\/#primaryimage"},"thumbnailUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/11\/csv-format.png","datePublished":"2018-11-10T09:57:04+00:00","dateModified":"2024-03-26T11:28:47+00:00","description":"Learn how to convert XLSX file to CSV with this step-by-step guide. CSV files are great for storing data and easy to open in any simple text editor.","breadcrumb":{"@id":"https:\/\/officetuts.net\/excel\/examples\/convert-xlsx-file-to-csv\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/officetuts.net\/excel\/examples\/convert-xlsx-file-to-csv\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/examples\/convert-xlsx-file-to-csv\/#primaryimage","url":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/11\/csv-format.png","contentUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/11\/csv-format.png"},{"@type":"BreadcrumbList","@id":"https:\/\/officetuts.net\/excel\/examples\/convert-xlsx-file-to-csv\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/officetuts.net\/excel\/"},{"@type":"ListItem","position":2,"name":"Convert XLSX File to CSV in Excel"}]},{"@type":"WebSite","@id":"https:\/\/officetuts.net\/excel\/#website","url":"https:\/\/officetuts.net\/excel\/","name":"","description":"","publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/officetuts.net\/excel\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42","name":"Tomasz Decker","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","caption":"Tomasz Decker"},"logo":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/"},"description":"Spreadsheet and Python enthusiast."}]}},"_links":{"self":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/3297"}],"collection":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/comments?post=3297"}],"version-history":[{"count":8,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/3297\/revisions"}],"predecessor-version":[{"id":15736,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/3297\/revisions\/15736"}],"wp:attachment":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/media?parent=3297"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/categories?post=3297"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/tags?post=3297"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}