How to clean up a .CSV file by splitting data into columns?

Thomas just downloaded a list from Bittrex showing him his latest trades on the platform. It is a CSV file. But, as he opens the file it is a complete mess. All the data is stored in one single column, making it impossible to read and get the overview he wanted to get.

Thomas doesn’t like the CSV file, and wonders if there is an easy way to make sure that the data is divided into different columns. Or is CSV a completely useless format? Since so many people use it, there has got to be a way to create order in the mess.

How can Thomas create order in this messy CSV file?
How can Thomas create order in this messy CSV file?

Thomas finds a way to fix the mess in the CSV file

After looking around and trying different methods, Thomas has found one he is satisfied with and that he likes. It is quite easy. Want to find out how Thomas cleans up the mess in the CSV file? Take a look at the video beneath, or read the further instructions beneath the video.

  • First of all, Thomas creates a brand new Microsoft Excel file.
  • He then clicks the Data text in the Menu and chooses From Text.
  • He finds the CSV file he is interested in and opens it.
  • Now he has to set the import settings.
  • The data in the CSV file is mostly separated by comma or semi-colon. Find out which is used in your file, and set this to be the divider in the import settings.
  • He then sets text-qualifier to NONE.
  • After this, he clicks Finish and OK, and the data from the CSV file has been beautifully imported to his excel file.

If you had trouble following the steps above, watch the video to see it step-by-step!

Hopefully, you will be able to enjoy the data from your CSV file just like Thomas is at the moment.

Should you have trouble or maybe a question, please write a comment, and Thomas will do his uttermost to help you out!

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.