Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Paulyeo11
Impactful Individual
Impactful Individual

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

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
Daviejoe
Memorable Member
Memorable Member

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!




Paulyeo11
Impactful Individual
Impactful Individual

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

 

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!




Paulyeo11
Impactful Individual
Impactful Individual

Hi Sir

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

Paul

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!




themistoklis
Community Champion
Community Champion

@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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.