I downloaded a dataset from kaggle.
kaggle data:
but all the data is in one column in excel.
data in excel:
I need this data for my project. how can I get this data separated?
-
When you open the file in a basic text editor, like Notepad, do you see commas or other delimiters? Have you retrieved a new copy of the data to see if there was an error in the original report?– music2myearCommented Nov 17, 2022 at 18:11
-
Looks like the file is already tab separated, which is what Excel uses internally when you copy and paste. So the easiest is to just open it in the default Notepad app, select all, copy and then paste in Excel– BdRCommented Nov 30, 2022 at 23:35
Add a comment
|
2 Answers
Your Data is not CSV (Comma Separated Values) rather it is TSV (Tab Separated Values) that is why you see everything in 1 Column.
There are various ways to handle TSV in MS Excel , including while loading or after loading.
Here , I will give a Solution based on your Screen Shot.
Go to your WorkSheet & Select Column A. Select "Data" on the Menu & then "Text to Columns"
Then Choose "Delimited" & then Select Delimiter "Tab".
Make suitable changes to the Column types , then finally click "finish".
Now you should have got the multiple Columns you wanted.
Save the file in CSV UTF-8 format in Excel-Save As.
-
This may not work , because MS Excel is Currently seeing a Single column & it will save that Single column in "save as" & when the new Document gets reopened , it will still have that Single Column.– PremCommented Nov 17, 2022 at 10:30