{"id":4216,"date":"2018-08-14T10:55:51","date_gmt":"2018-08-14T10:55:51","guid":{"rendered":"https:\/\/www.isumsoft.com\/it\/?p=4216"},"modified":"2019-11-28T03:37:05","modified_gmt":"2019-11-28T03:37:05","slug":"how-to-fix-messy-codes-for-csv-file-in-excel-2016","status":"publish","type":"post","link":"https:\/\/www.isumsoft.com\/it\/how-to-fix-messy-codes-for-csv-file-in-excel-2016\/","title":{"rendered":"How to Fix Messy Codes for CSV File in Excel 2016"},"content":{"rendered":"

For some office workers, Excel is a kind of statistical software that is used a lot. Supposing you open a CSV file with Excel, and it turns out that there are messy codes in the CSV file. You have also tried to reopen the file several times, but the result is the same. What should you do? I think a lot of people have had such a problem when opening CSV files by excel, and that includes me. Never mind, you just do the following steps and you’ll know how to fix the problem of messy codes in Excel CSV file<\/a>.<\/p>\n

Tips:<\/strong> When you open an Excel file, Microsoft Excel attempts to automatically find the appropriate encoding. However, the CSV file usually does not have this information because they are just plain text. Therefore, you need to help Excel select the correct encoding to open the CSV file.<\/p>\n

How to Fix the Problem of Messy Codes in Excel CSV File?<\/h2>\n

There are a variety of reasons for the messy code appears in Excel. But I can be sure that the CSV file appears the problem of messy codes is mainly caused by file encoding. Therefore, if you want to solve the problem of messy codes in Excel CSV file, you can start by changing the file. Please follow the solution below.<\/p>\n

Step 1: When a document in CSV format opened by Excel, you can see messy codes in it.<\/p>\n

\"appear<\/p>\n

Step 2: Close the CSV file, and open it by choosing Notepad.<\/p>\n

\"open<\/p>\n

Step 3: When the CSV file with messy codes is opened via Notepad, it’s also a bunch of messy codes.<\/p>\n

\"a<\/p>\n

Step 4: You can go to File<\/strong> > Save As<\/strong> options.<\/p>\n

\"save<\/p>\n

Step 5: Change the original file name (Excel file.csv<\/strong>) into Excel file 1234.csv<\/strong>. Choose UTF-8<\/strong> as correct encoding and save the file.<\/p>\n

\"choose<\/p>\n

Step 6: After saving the file, open it with Excel. As you can see, the document displays normally.<\/p>\n

\"normal<\/p>\n","protected":false},"excerpt":{"rendered":"

For some office workers, Excel is a kind of statistical software that is used a lot. Supposing you open a CSV file with Excel, and it turns out that there are messy codes in the CSV file. You… <\/p>\n","protected":false},"author":2,"featured_media":5691,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[37],"tags":[212],"class_list":["post-4216","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-office","tag-fix-messy-codes-in-excel"],"yoast_head":"\nHow to Fix Messy Codes for CSV File in Excel 2016<\/title>\n<meta name=\"description\" content=\"When you get into a situation where messy codes appear in the CSV file, what should you do? Never mind, this post offers steps to fix the issue.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.isumsoft.com\/it\/how-to-fix-messy-codes-for-csv-file-in-excel-2016\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Fix Messy Codes for CSV File in Excel 2016\" \/>\n<meta property=\"og:description\" content=\"When you get into a situation where messy codes appear in the CSV file, what should you do? Never mind, this post offers steps to fix the issue.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.isumsoft.com\/it\/how-to-fix-messy-codes-for-csv-file-in-excel-2016\/\" \/>\n<meta property=\"og:site_name\" content=\"iSumsoft\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/isumsofthome\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-08-14T10:55:51+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-11-28T03:37:05+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/fix-excel-csv-messy-code.png\" \/>\n\t<meta property=\"og:image:width\" content=\"606\" \/>\n\t<meta property=\"og:image:height\" content=\"360\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Darren\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@iSumsoft\" \/>\n<meta name=\"twitter:site\" content=\"@iSumsoft\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Darren\" \/>\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:\\\/\\\/www.isumsoft.com\\\/it\\\/how-to-fix-messy-codes-for-csv-file-in-excel-2016\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/how-to-fix-messy-codes-for-csv-file-in-excel-2016\\\/\"},\"author\":{\"name\":\"Darren\",\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/#\\\/schema\\\/person\\\/53553bf339aeb82b9c6a240f3b262798\"},\"headline\":\"How to Fix Messy Codes for CSV File in Excel 2016\",\"datePublished\":\"2018-08-14T10:55:51+00:00\",\"dateModified\":\"2019-11-28T03:37:05+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/how-to-fix-messy-codes-for-csv-file-in-excel-2016\\\/\"},\"wordCount\":329,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/how-to-fix-messy-codes-for-csv-file-in-excel-2016\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/wp-content\\\/uploads\\\/2018\\\/08\\\/fix-excel-csv-messy-code.png\",\"keywords\":[\"fix messy codes in excel\"],\"articleSection\":[\"Office\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/how-to-fix-messy-codes-for-csv-file-in-excel-2016\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/how-to-fix-messy-codes-for-csv-file-in-excel-2016\\\/\",\"url\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/how-to-fix-messy-codes-for-csv-file-in-excel-2016\\\/\",\"name\":\"How to Fix Messy Codes for CSV File in Excel 2016\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/how-to-fix-messy-codes-for-csv-file-in-excel-2016\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/how-to-fix-messy-codes-for-csv-file-in-excel-2016\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/wp-content\\\/uploads\\\/2018\\\/08\\\/fix-excel-csv-messy-code.png\",\"datePublished\":\"2018-08-14T10:55:51+00:00\",\"dateModified\":\"2019-11-28T03:37:05+00:00\",\"description\":\"When you get into a situation where messy codes appear in the CSV file, what should you do? Never mind, this post offers steps to fix the issue.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/how-to-fix-messy-codes-for-csv-file-in-excel-2016\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/how-to-fix-messy-codes-for-csv-file-in-excel-2016\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/how-to-fix-messy-codes-for-csv-file-in-excel-2016\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/wp-content\\\/uploads\\\/2018\\\/08\\\/fix-excel-csv-messy-code.png\",\"contentUrl\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/wp-content\\\/uploads\\\/2018\\\/08\\\/fix-excel-csv-messy-code.png\",\"width\":606,\"height\":360,\"caption\":\"Fix Excel CSV Messy Code\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/how-to-fix-messy-codes-for-csv-file-in-excel-2016\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Fix Messy Codes for CSV File in Excel 2016\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/#website\",\"url\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/\",\"name\":\"iSumsoft\",\"description\":\"Tell You More about IT World\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/#organization\",\"name\":\"iSumsoft Studio\",\"url\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/wp-content\\\/uploads\\\/2019\\\/11\\\/favicon.ico\",\"contentUrl\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/wp-content\\\/uploads\\\/2019\\\/11\\\/favicon.ico\",\"width\":16,\"height\":16,\"caption\":\"iSumsoft Studio\"},\"image\":{\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/isumsofthome\\\/\",\"https:\\\/\\\/x.com\\\/iSumsoft\",\"https:\\\/\\\/www.youtube.com\\\/channel\\\/UCL9RaYqRcQ0f0buIzXiaNDw\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/#\\\/schema\\\/person\\\/53553bf339aeb82b9c6a240f3b262798\",\"name\":\"Darren\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/wp-content\\\/wphb-cache\\\/gravatar\\\/e5e\\\/e5eca2e7a3c501250b3030d7070548bbx96.jpg\",\"url\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/wp-content\\\/wphb-cache\\\/gravatar\\\/e5e\\\/e5eca2e7a3c501250b3030d7070548bbx96.jpg\",\"contentUrl\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/wp-content\\\/wphb-cache\\\/gravatar\\\/e5e\\\/e5eca2e7a3c501250b3030d7070548bbx96.jpg\",\"caption\":\"Darren\"},\"url\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/author\\\/darren-king\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Fix Messy Codes for CSV File in Excel 2016","description":"When you get into a situation where messy codes appear in the CSV file, what should you do? Never mind, this post offers steps to fix the issue.","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:\/\/www.isumsoft.com\/it\/how-to-fix-messy-codes-for-csv-file-in-excel-2016\/","og_locale":"en_US","og_type":"article","og_title":"How to Fix Messy Codes for CSV File in Excel 2016","og_description":"When you get into a situation where messy codes appear in the CSV file, what should you do? Never mind, this post offers steps to fix the issue.","og_url":"https:\/\/www.isumsoft.com\/it\/how-to-fix-messy-codes-for-csv-file-in-excel-2016\/","og_site_name":"iSumsoft","article_publisher":"https:\/\/www.facebook.com\/isumsofthome\/","article_published_time":"2018-08-14T10:55:51+00:00","article_modified_time":"2019-11-28T03:37:05+00:00","og_image":[{"width":606,"height":360,"url":"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/fix-excel-csv-messy-code.png","type":"image\/png"}],"author":"Darren","twitter_card":"summary_large_image","twitter_creator":"@iSumsoft","twitter_site":"@iSumsoft","twitter_misc":{"Written by":"Darren","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.isumsoft.com\/it\/how-to-fix-messy-codes-for-csv-file-in-excel-2016\/#article","isPartOf":{"@id":"https:\/\/www.isumsoft.com\/it\/how-to-fix-messy-codes-for-csv-file-in-excel-2016\/"},"author":{"name":"Darren","@id":"https:\/\/www.isumsoft.com\/it\/#\/schema\/person\/53553bf339aeb82b9c6a240f3b262798"},"headline":"How to Fix Messy Codes for CSV File in Excel 2016","datePublished":"2018-08-14T10:55:51+00:00","dateModified":"2019-11-28T03:37:05+00:00","mainEntityOfPage":{"@id":"https:\/\/www.isumsoft.com\/it\/how-to-fix-messy-codes-for-csv-file-in-excel-2016\/"},"wordCount":329,"commentCount":0,"publisher":{"@id":"https:\/\/www.isumsoft.com\/it\/#organization"},"image":{"@id":"https:\/\/www.isumsoft.com\/it\/how-to-fix-messy-codes-for-csv-file-in-excel-2016\/#primaryimage"},"thumbnailUrl":"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/fix-excel-csv-messy-code.png","keywords":["fix messy codes in excel"],"articleSection":["Office"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.isumsoft.com\/it\/how-to-fix-messy-codes-for-csv-file-in-excel-2016\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.isumsoft.com\/it\/how-to-fix-messy-codes-for-csv-file-in-excel-2016\/","url":"https:\/\/www.isumsoft.com\/it\/how-to-fix-messy-codes-for-csv-file-in-excel-2016\/","name":"How to Fix Messy Codes for CSV File in Excel 2016","isPartOf":{"@id":"https:\/\/www.isumsoft.com\/it\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.isumsoft.com\/it\/how-to-fix-messy-codes-for-csv-file-in-excel-2016\/#primaryimage"},"image":{"@id":"https:\/\/www.isumsoft.com\/it\/how-to-fix-messy-codes-for-csv-file-in-excel-2016\/#primaryimage"},"thumbnailUrl":"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/fix-excel-csv-messy-code.png","datePublished":"2018-08-14T10:55:51+00:00","dateModified":"2019-11-28T03:37:05+00:00","description":"When you get into a situation where messy codes appear in the CSV file, what should you do? Never mind, this post offers steps to fix the issue.","breadcrumb":{"@id":"https:\/\/www.isumsoft.com\/it\/how-to-fix-messy-codes-for-csv-file-in-excel-2016\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.isumsoft.com\/it\/how-to-fix-messy-codes-for-csv-file-in-excel-2016\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.isumsoft.com\/it\/how-to-fix-messy-codes-for-csv-file-in-excel-2016\/#primaryimage","url":"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/fix-excel-csv-messy-code.png","contentUrl":"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/08\/fix-excel-csv-messy-code.png","width":606,"height":360,"caption":"Fix Excel CSV Messy Code"},{"@type":"BreadcrumbList","@id":"https:\/\/www.isumsoft.com\/it\/how-to-fix-messy-codes-for-csv-file-in-excel-2016\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.isumsoft.com\/it\/"},{"@type":"ListItem","position":2,"name":"How to Fix Messy Codes for CSV File in Excel 2016"}]},{"@type":"WebSite","@id":"https:\/\/www.isumsoft.com\/it\/#website","url":"https:\/\/www.isumsoft.com\/it\/","name":"iSumsoft","description":"Tell You More about IT World","publisher":{"@id":"https:\/\/www.isumsoft.com\/it\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.isumsoft.com\/it\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.isumsoft.com\/it\/#organization","name":"iSumsoft Studio","url":"https:\/\/www.isumsoft.com\/it\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.isumsoft.com\/it\/#\/schema\/logo\/image\/","url":"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2019\/11\/favicon.ico","contentUrl":"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2019\/11\/favicon.ico","width":16,"height":16,"caption":"iSumsoft Studio"},"image":{"@id":"https:\/\/www.isumsoft.com\/it\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/isumsofthome\/","https:\/\/x.com\/iSumsoft","https:\/\/www.youtube.com\/channel\/UCL9RaYqRcQ0f0buIzXiaNDw"]},{"@type":"Person","@id":"https:\/\/www.isumsoft.com\/it\/#\/schema\/person\/53553bf339aeb82b9c6a240f3b262798","name":"Darren","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.isumsoft.com\/it\/wp-content\/wphb-cache\/gravatar\/e5e\/e5eca2e7a3c501250b3030d7070548bbx96.jpg","url":"https:\/\/www.isumsoft.com\/it\/wp-content\/wphb-cache\/gravatar\/e5e\/e5eca2e7a3c501250b3030d7070548bbx96.jpg","contentUrl":"https:\/\/www.isumsoft.com\/it\/wp-content\/wphb-cache\/gravatar\/e5e\/e5eca2e7a3c501250b3030d7070548bbx96.jpg","caption":"Darren"},"url":"https:\/\/www.isumsoft.com\/it\/author\/darren-king\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/www.isumsoft.com\/it\/wp-json\/wp\/v2\/posts\/4216","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.isumsoft.com\/it\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.isumsoft.com\/it\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.isumsoft.com\/it\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.isumsoft.com\/it\/wp-json\/wp\/v2\/comments?post=4216"}],"version-history":[{"count":0,"href":"https:\/\/www.isumsoft.com\/it\/wp-json\/wp\/v2\/posts\/4216\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.isumsoft.com\/it\/wp-json\/wp\/v2\/media\/5691"}],"wp:attachment":[{"href":"https:\/\/www.isumsoft.com\/it\/wp-json\/wp\/v2\/media?parent=4216"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.isumsoft.com\/it\/wp-json\/wp\/v2\/categories?post=4216"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.isumsoft.com\/it\/wp-json\/wp\/v2\/tags?post=4216"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}