EXCEL ISSUE Need A Hand Here, please!

Hi there

Do anyone faced this problem before?

When i want to download the keywords excel sheet from Ubersuggest, the sheet came messed up

it should have a different section like this:



A B C D E
Keyword | Search Volume | CPC || Paid Difficulty | SEO Difficulty
kw1 | 100 | 1 | 26 |
kw2 | 300 | 3 | 34 |
kw3 | 567 | 4 | 36 |
kw4 | 45 | 0 | 22 |
kw5 | 678 | 0 | 45 |
kw6 | 1300 | 0 | 60 |
kw7 | 346 | 0 | 56 |


But it turns out as you can see in this image!

All those sections should be separate, but they are under ONE section




How i can separate those into different sections? the niche is an example

I don't know why the format is broken?

Your excel program probably tried to take tab separated values (tsv) while you have a comma separated file (csv). Change the delimiter to comma instead of tab and it shud be fine.

HoNeYBiRD said:

https://support.microsoft.com/en-us/office/split-text-into-different-columns-with-the-convert-text-to-columns-wizard-30b14928-5550-41f5-97ca-7a3e9c363ed7​

Learn how to take the text in one or more cells, and split it out across multiple cells by using Excel functions. This is called parsing, and is the opposite of concatenate. Watch more in this video.

support.microsoft.com

Click to expand...

YOU DID ME A BIIIIG FUCKING FAVOR MAN,


after i didn't find a solution, I've wasted copying and pasting each kw on a new excel sheet, REALLY APPRECIATED MA MAN

Gogol said:

Your excel program probably tried to take tab separated values (tsv) while you have a comma separated file (csv). Change the delimiter to comma instead of tab and it shud be fine.

Click to expand...

That's what i did following the above video, thanks guys for the help, appreciate it