cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Post Prodigy
Post Prodigy

when i open CSV file , all data not in the cell , and look very messy

Hi All

 

Why when i open some look very neat ?

 

Paulyeo11_0-1602750619442.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

Perhaps it was the way you extracted the CSV?

 

Can you look to see if you can extract it as a CSV delimited file?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

6 REPLIES 6
Highlighted
Resident Rockstar
Resident Rockstar

@Paulyeo11 

 

Select Column A, go to 'Data' section on menu bar, click on text to columns button then follow the steps (choose the right delimiter)

 

Or you can open a blank spreadsheet --> 'Data' Section on Menu bar --> From Text/CSV button --> Follow rest of steps

Highlighted
Super User I
Super User I

Hi @Paulyeo11 

 

I'm not entirely sure what the issue is here.

 

Are the rows that you refer to as 'neat' perhaps just shorter in terms of words/characters?

 

Is this causing any issues that you need to solve?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Highlighted

Hi davi

Usually when i open a CSV file , it look like below , but now mine look very messy. and i cannot delete the row for create sample file for testing.

Paulyeo11_0-1602751546028.png

 

Highlighted

Perhaps it was the way you extracted the CSV?

 

Can you look to see if you can extract it as a CSV delimited file?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

Highlighted

Hi Sir

I like your answer , will ask my IT to regenerate agin for me.

Paul

Highlighted

Let me know how you get on.

 

It just seems that the file does not have any delimiters which would allow Power BI to split out into columns.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors