How to Fix Corrupted CSV Files on Windows 10?

A CSV file is also known as a comma-separated values file that allows you data to be stored in a tabular format. However, sometimes these files may become corrupted. If you would like to fix this issue, then here are some directions given below:

Use Different Software to Launch the CSV File or Import and Fix on Excel

You should follow the directions given below:

  1. Launch a new workbook on Excel.
  2. After that, click on the Data section.
  3. You should choose the ‘From text’ option beneath the section of Get External Data.
  4. Then browse the damaged CSV file.
  5. You have to select the Delimiter option and then choose the Next button.
  6. Go to the Comma option and then click on the Next button.
  7. You should pick the column with numbers then select the Text button.
  8. Now, redo the instructions for each column with a number and select the OK button.

Using Unicode UTF-8 Encoding

You should follow the directions given below:

  1. Navigate to the CSV file on your system.
  2. Thereafter, click on the File option and click on the Save As option.
  3. You have to input the name of the file.
  4. Go to the menu of drop-down and choose ‘Save as File Type CSV.’
  5. You should click on the Tools option and choose the option of Web.
  6. Click on the Encoding option beneath the ‘Save this document as’ section.
  7. Now, choose the Unicode (UTF-8) option.

Using Notepad to Make a CSV File

You should follow the directions given below:

  1. Go to the file and input a text data with every section separated by a comma in Notepad.
  2. After that, separate every row via a new line.
  3. Now, save the file via a .csv extension.

Using an Excel Spreadsheet to Make a CSV File

You should follow the directions given below:

  1. Navigate to the Excel spreadsheet and input the data.
  2. Then click on the File option.
  3. You should choose the Save As option.
  4. Go to the ‘Save as Type’ option.
  5. Now, click on the CSV.

Recover via TMP File

You should follow on-screen directions given below:

  1. Navigate to wherever the Temp file folder is situated: C:\Users\AppData\Loca\lMicrosoft\Office\UnsavedFiles
  2. After that, browse the files of Excel with.TMP extension.
  3. You should click on the right by confirming the data.
  4. Now, copy, paste and store it to another location using the .CSV extension.

If you are struggling with CSV file corruption, then following the above-mentioned solutions one-by-one will help you recover the file easily.

I’m Anny. I’m a social media manager living in USA. I am a fan of technology, design, and music. I’m also interested in fitness and movies. You can attend my event with a click on the button above.

Source: How to Fix Corrupted CSV Files on Windows 10?

Comments are closed