{"id":9058,"date":"2022-02-19T18:04:14","date_gmt":"2022-02-19T18:04:14","guid":{"rendered":"https:\/\/officetuts.net\/excel\/?p=9058"},"modified":"2024-03-28T13:40:07","modified_gmt":"2024-03-28T13:40:07","slug":"save-excel-sheet-as-a-csv-file-with-utf-8-encoding","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/examples\/save-excel-sheet-as-a-csv-file-with-utf-8-encoding\/","title":{"rendered":"Save Excel Sheet as a CSV file with UTF-8 encoding"},"content":{"rendered":"\n
Save-Excel-Sheet-as-a-CSV-file-with-UTF-8-Encoding<\/a>Download File<\/a><\/div>\n\n\n\n

In Excel, you can save a spreadsheet as a CSV file directly from the Excel menu. Saving it in Excel 2016, 2019, 2021, and 365 is different from the 2013 and older versions, as they don\u2019t offer such an option from the menu.<\/p>\n\n\n\n

Excel sheet to CSV conversion<\/h2>\n\n\n\n

If you are saving a CSV file, you need to know that you can only save a single Excel sheet to a CSV file; the rest of them are going to be discarded. There is no formatting in the CSV file<\/a>, so all tables, color fills, etc. will also be removed.<\/p>\n\n\n\n

This is the example we are going to use – a single sheet with a few names on it.<\/p>\n\n\n\n

\"Table,<\/figure>\n\n\n\n

Excel 2016 and newer<\/h2>\n\n\n\n
    \n
  1. Navigate to File >> Save As<\/strong><\/li>\n\n\n\n
  2. Click Browse<\/strong> and select a place, where you want to save a file<\/li>\n\n\n\n
  3. From the Save as type<\/strong> dropdown list and choose: CSV UTF-8 (Comma delimited)(*.csv)<\/strong><\/li>\n\n\n\n
  4. Click Save<\/strong><\/li>\n<\/ol>\n\n\n\n
    \"Graphical<\/figure>\n\n\n\n

    If you open a file with the notepad, it consists of text separated by delimiters (commas). In the bottom-right corner, there is information about encoding: UTF-8<\/strong>.<\/p>\n\n\n\n

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

    You can also find information about encoding when you click File >> Save As<\/strong> in a notepad.<\/p>\n\n\n\n

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

    Excel 2013 and older<\/h2>\n\n\n\n

    The older versions of Excel don\u2019t have the option to save the file with UTF-8<\/strong> encoding. But it doesn\u2019t mean you can\u2019t do it. You can, just not inside Excel.<\/p>\n\n\n\n

    These are the steps to save the Excel sheet as CSV<\/a> and change the encoding to UTF-8<\/strong>.<\/p>\n\n\n\n

      \n
    1. Save a sheet as the standard CSV file<\/a><\/li>\n\n\n\n
    2. Right-click the file and open it with a notepad<\/li>\n\n\n\n
    3. Click File >> Save As<\/strong><\/li>\n\n\n\n
    4. Choose the UTF-8<\/strong> encoding<\/li>\n\n\n\n
    5. Click Save<\/strong><\/li>\n<\/ol>\n\n\n\n
      \"Graphical<\/figure>\n","protected":false},"excerpt":{"rendered":"

      In Excel, you can save a spreadsheet as a CSV file directly from the Excel menu. Saving it in Excel 2016, 2019, 2021,…<\/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":"\nSave Excel Sheet as a CSV file with UTF-8 encoding<\/title>\n<meta name=\"description\" content=\"Learn how to save Excel sheet as a CSV file with UTF-8 encoding in Excel 2016 and newer versions. Download sample file and follow step by step instructions.\" \/>\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\/save-excel-sheet-as-a-csv-file-with-utf-8-encoding\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Save Excel Sheet as a CSV file with UTF-8 encoding\" \/>\n<meta property=\"og:description\" content=\"Learn how to save Excel sheet as a CSV file with UTF-8 encoding in Excel 2016 and newer versions. Download sample file and follow step by step instructions.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/officetuts.net\/excel\/examples\/save-excel-sheet-as-a-csv-file-with-utf-8-encoding\/\" \/>\n<meta property=\"article:published_time\" content=\"2022-02-19T18:04:14+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-28T13:40:07+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/02\/table-excel-description-automatically-generated-3.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=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/save-excel-sheet-as-a-csv-file-with-utf-8-encoding\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/save-excel-sheet-as-a-csv-file-with-utf-8-encoding\/\"},\"author\":{\"name\":\"Tomasz Decker\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"headline\":\"Save Excel Sheet as a CSV file with UTF-8 encoding\",\"datePublished\":\"2022-02-19T18:04:14+00:00\",\"dateModified\":\"2024-03-28T13:40:07+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/save-excel-sheet-as-a-csv-file-with-utf-8-encoding\/\"},\"wordCount\":293,\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/save-excel-sheet-as-a-csv-file-with-utf-8-encoding\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/02\/table-excel-description-automatically-generated-3.png\",\"keywords\":[\"file\",\"pinterest\"],\"articleSection\":[\"examples\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/save-excel-sheet-as-a-csv-file-with-utf-8-encoding\/\",\"url\":\"https:\/\/officetuts.net\/excel\/examples\/save-excel-sheet-as-a-csv-file-with-utf-8-encoding\/\",\"name\":\"Save Excel Sheet as a CSV file with UTF-8 encoding\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/save-excel-sheet-as-a-csv-file-with-utf-8-encoding\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/save-excel-sheet-as-a-csv-file-with-utf-8-encoding\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/02\/table-excel-description-automatically-generated-3.png\",\"datePublished\":\"2022-02-19T18:04:14+00:00\",\"dateModified\":\"2024-03-28T13:40:07+00:00\",\"description\":\"Learn how to save Excel sheet as a CSV file with UTF-8 encoding in Excel 2016 and newer versions. Download sample file and follow step by step instructions.\",\"breadcrumb\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/save-excel-sheet-as-a-csv-file-with-utf-8-encoding\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/officetuts.net\/excel\/examples\/save-excel-sheet-as-a-csv-file-with-utf-8-encoding\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/save-excel-sheet-as-a-csv-file-with-utf-8-encoding\/#primaryimage\",\"url\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/02\/table-excel-description-automatically-generated-3.png\",\"contentUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/02\/table-excel-description-automatically-generated-3.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/save-excel-sheet-as-a-csv-file-with-utf-8-encoding\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/officetuts.net\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Save Excel Sheet as a CSV file with UTF-8 encoding\"}]},{\"@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":"Save Excel Sheet as a CSV file with UTF-8 encoding","description":"Learn how to save Excel sheet as a CSV file with UTF-8 encoding in Excel 2016 and newer versions. Download sample file and follow step by step instructions.","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\/save-excel-sheet-as-a-csv-file-with-utf-8-encoding\/","og_locale":"en_US","og_type":"article","og_title":"Save Excel Sheet as a CSV file with UTF-8 encoding","og_description":"Learn how to save Excel sheet as a CSV file with UTF-8 encoding in Excel 2016 and newer versions. Download sample file and follow step by step instructions.","og_url":"https:\/\/officetuts.net\/excel\/examples\/save-excel-sheet-as-a-csv-file-with-utf-8-encoding\/","article_published_time":"2022-02-19T18:04:14+00:00","article_modified_time":"2024-03-28T13:40:07+00:00","og_image":[{"url":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/02\/table-excel-description-automatically-generated-3.png"}],"author":"Tomasz Decker","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Tomasz Decker","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/officetuts.net\/excel\/examples\/save-excel-sheet-as-a-csv-file-with-utf-8-encoding\/#article","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/examples\/save-excel-sheet-as-a-csv-file-with-utf-8-encoding\/"},"author":{"name":"Tomasz Decker","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"headline":"Save Excel Sheet as a CSV file with UTF-8 encoding","datePublished":"2022-02-19T18:04:14+00:00","dateModified":"2024-03-28T13:40:07+00:00","mainEntityOfPage":{"@id":"https:\/\/officetuts.net\/excel\/examples\/save-excel-sheet-as-a-csv-file-with-utf-8-encoding\/"},"wordCount":293,"publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"image":{"@id":"https:\/\/officetuts.net\/excel\/examples\/save-excel-sheet-as-a-csv-file-with-utf-8-encoding\/#primaryimage"},"thumbnailUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/02\/table-excel-description-automatically-generated-3.png","keywords":["file","pinterest"],"articleSection":["examples"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/officetuts.net\/excel\/examples\/save-excel-sheet-as-a-csv-file-with-utf-8-encoding\/","url":"https:\/\/officetuts.net\/excel\/examples\/save-excel-sheet-as-a-csv-file-with-utf-8-encoding\/","name":"Save Excel Sheet as a CSV file with UTF-8 encoding","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/officetuts.net\/excel\/examples\/save-excel-sheet-as-a-csv-file-with-utf-8-encoding\/#primaryimage"},"image":{"@id":"https:\/\/officetuts.net\/excel\/examples\/save-excel-sheet-as-a-csv-file-with-utf-8-encoding\/#primaryimage"},"thumbnailUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/02\/table-excel-description-automatically-generated-3.png","datePublished":"2022-02-19T18:04:14+00:00","dateModified":"2024-03-28T13:40:07+00:00","description":"Learn how to save Excel sheet as a CSV file with UTF-8 encoding in Excel 2016 and newer versions. Download sample file and follow step by step instructions.","breadcrumb":{"@id":"https:\/\/officetuts.net\/excel\/examples\/save-excel-sheet-as-a-csv-file-with-utf-8-encoding\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/officetuts.net\/excel\/examples\/save-excel-sheet-as-a-csv-file-with-utf-8-encoding\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/examples\/save-excel-sheet-as-a-csv-file-with-utf-8-encoding\/#primaryimage","url":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/02\/table-excel-description-automatically-generated-3.png","contentUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/02\/table-excel-description-automatically-generated-3.png"},{"@type":"BreadcrumbList","@id":"https:\/\/officetuts.net\/excel\/examples\/save-excel-sheet-as-a-csv-file-with-utf-8-encoding\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/officetuts.net\/excel\/"},{"@type":"ListItem","position":2,"name":"Save Excel Sheet as a CSV file with UTF-8 encoding"}]},{"@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\/9058"}],"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=9058"}],"version-history":[{"count":8,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/9058\/revisions"}],"predecessor-version":[{"id":14306,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/9058\/revisions\/14306"}],"wp:attachment":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/media?parent=9058"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/categories?post=9058"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/tags?post=9058"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}