{"id":5894,"date":"2018-07-26T08:23:37","date_gmt":"2018-07-26T08:23:37","guid":{"rendered":"https:\/\/www.isunshare.com\/blog\/?p=5894"},"modified":"2021-11-19T09:23:54","modified_gmt":"2021-11-19T09:23:54","slug":"how-to-fix-gibberish-output-in-csv-file-when-opened-by-excel","status":"publish","type":"post","link":"https:\/\/www.isunshare.com\/blog\/how-to-fix-gibberish-output-in-csv-file-when-opened-by-excel\/","title":{"rendered":"How to Fix Gibberish Output in csv File When Opened by Excel"},"content":{"rendered":"<div class=\"ads-google\"><ins class=\"adsbygoogle\" style=\"display: block; text-align: center;\" data-ad-layout=\"in-article\" data-ad-format=\"fluid\" data-ad-client=\"ca-pub-3976761739610001\" data-ad-slot=\"8881155354\"><\/ins><br \/>\n<script>\n     (adsbygoogle = window.adsbygoogle || []).push({});\n<\/script><\/div>\n<p>&#8220;My problem started when I downloaded a csv file from Zoomerang to Excel. When I tried opening it with Excel, it said it was unrecognizable format but opened as gibberish. I&#8217;ve tried several times to redownload and reopen the file. Yet the result is the same. Any suggestions?&#8221; This is a commonly asked question on some forums and I guess many people have met the problem of <strong><a href=\"https:\/\/www.isunshare.com\/blog\/how-to-fix-gibberish-output-in-csv-file-when-opened-by-excel\">gibberish output in csv file when opened by excel<\/a><\/strong>. Keep reading this post and you will know how to fix this problem.<br \/>\nWhen opening any file, Microsoft Excel is trying to find the proper encoding automatically. However, csv files usually have no such information as they are just plain text. Therefore you need to help Excel choose the correct encoding to open the csv file. Here are the steps for you to follow:<\/p>\n<p><strong>Step 1.<\/strong> Create a new Excel file and open it.<\/p>\n<p><strong>Step 2.<\/strong> Go to the <strong>Data<\/strong> tab and choose <strong>From Text<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2018\/07\/data-from-text.png\"><img loading=\"lazy\" decoding=\"async\" width=\"811\" height=\"492\" class=\"alignnone size-full wp-image-5899\" src=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2018\/07\/data-from-text.png\" alt=\"data from text\" srcset=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2018\/07\/data-from-text.png 811w, https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2018\/07\/data-from-text-300x182.png 300w, https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2018\/07\/data-from-text-768x466.png 768w\" sizes=\"auto, (max-width: 811px) 100vw, 811px\" \/><\/a><\/p>\n<p><strong>Step 3.<\/strong> Import the gibberish csv file.<\/p>\n<p><a href=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2018\/07\/import-text-file.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"935\" height=\"530\" class=\"alignnone size-full wp-image-5968\" src=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2018\/07\/import-text-file.jpg\" alt=\"import text file\" srcset=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2018\/07\/import-text-file.jpg 935w, https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2018\/07\/import-text-file-300x170.jpg 300w, https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2018\/07\/import-text-file-768x435.jpg 768w\" sizes=\"auto, (max-width: 935px) 100vw, 935px\" \/><\/a><\/p>\n<p><strong>Step 4.<\/strong> In <strong>file origin<\/strong>, select the encoding of data inside this file if you know. If you don&#8217;t know its encoding, then you should try the options in <strong>file origin<\/strong> one by one, as UTF-8(65001) works on different operating systems and has support for all languages, I highly recommend that you try it first. You can preview the results in the bottom of the dialogue box. After you get the right one, click <strong>Next<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2018\/07\/choose-file-origin.png\"><img decoding=\"async\" class=\"alignnone size-full wp-image-5964\" src=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2018\/07\/choose-file-origin-768x652.webp\" alt=\"choose file origin\" \/><\/a><\/p>\n<p><a href=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2018\/07\/choose-the-correct-file-origin.png\"><img decoding=\"async\" class=\"alignnone size-full wp-image-5965\" src=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2018\/07\/choose-the-correct-file-origin-768x678.webp\" alt=\"choose the correct file origin\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong>Step 5.<\/strong> In the pop-up dialogue box, choose <strong>Comma<\/strong> in <strong>Delimiter<\/strong>. And then click <strong>Next<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2018\/07\/select-comma.png\"><img decoding=\"async\" class=\"alignnone size-full wp-image-5969\" src=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2018\/07\/select-comma-768x664.webp\" alt=\"select comma\" \/><\/a><\/p>\n<p><strong>Step 6.<\/strong> Click <strong>Finish<\/strong> in the coming up dialogue box.<\/p>\n<p><a href=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2018\/07\/click-finish.png\"><img loading=\"lazy\" decoding=\"async\" width=\"765\" height=\"745\" class=\"alignnone size-full wp-image-5966\" src=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2018\/07\/click-finish.png\" alt=\"click finish\" srcset=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2018\/07\/click-finish.png 765w, https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2018\/07\/click-finish-300x292.png 300w\" sizes=\"auto, (max-width: 765px) 100vw, 765px\" \/><\/a><\/p>\n<p><strong>Step 7.<\/strong> Click <strong>OK<\/strong> in <strong>Import Data<\/strong>. And you will see the normal csv contents in the Excel sheet.<\/p>\n<p><a href=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2018\/07\/click-ok.png\"><img loading=\"lazy\" decoding=\"async\" width=\"715\" height=\"622\" class=\"alignnone size-full wp-image-5967\" src=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2018\/07\/click-ok.png\" alt=\"click ok\" srcset=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2018\/07\/click-ok.png 715w, https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2018\/07\/click-ok-300x261.png 300w\" sizes=\"auto, (max-width: 715px) 100vw, 715px\" \/><\/a><\/p>\n<p><a href=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2018\/07\/normal-contents.png\"><img loading=\"lazy\" decoding=\"async\" width=\"615\" height=\"522\" class=\"alignnone size-full wp-image-5901\" src=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2018\/07\/normal-contents.png\" alt=\"normal contents\" srcset=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2018\/07\/normal-contents.png 615w, https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2018\/07\/normal-contents-300x255.png 300w\" sizes=\"auto, (max-width: 615px) 100vw, 615px\" \/><\/a><\/p>\n<h3>You may also be interested in:<\/h3>\n<ul>\n<li><a href=\"https:\/\/www.isunshare.com\/blog\/four-steps-to-create-a-dynamic-dashboard-in-excel-2010\/\">Four Steps to Create a Dynamic Dashboard in Excel 2010<\/a><\/li>\n<li><a href=\"https:\/\/www.isunshare.com\/excel-password\/forgot-excel-2010-2013-workbook-password.html\">Forgot Excel Workbook 2010\/2013\/2016 Password<\/a><\/li>\n<li><a href=\"https:\/\/www.isunshare.com\/excel-password\/unprotect-excel-sheet-workbook-spreadsheet-worksheet-without-password.html\">How to Unprotect Excel Sheet\/Worksheet\/Workbook without Password<\/a><\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<div class=\"ads-google\"><ins class=\"adsbygoogle\" style=\"display: block; text-align: center;\" data-ad-layout=\"in-article\" data-ad-format=\"fluid\" data-ad-client=\"ca-pub-3976761739610001\" data-ad-slot=\"5625464292\"><\/ins><br \/>\n<script>\n     (adsbygoogle = window.adsbygoogle || []).push({});\n<\/script><\/div>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;My problem started when I downloaded a csv file from Zoomerang to Excel. When I tried opening it&#8230;<\/p>\n","protected":false},"author":4,"featured_media":5965,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[214,19],"tags":[],"class_list":["post-5894","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-computer","category-office-documents"],"_links":{"self":[{"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/posts\/5894","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/comments?post=5894"}],"version-history":[{"count":5,"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/posts\/5894\/revisions"}],"predecessor-version":[{"id":125329,"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/posts\/5894\/revisions\/125329"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/media\/5965"}],"wp:attachment":[{"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/media?parent=5894"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/categories?post=5894"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/tags?post=5894"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}