Downloaded excel document not formatting with information under headers

Question

Hello, I have an excel document that when I am downloaded it has the header section and then underneath the information is running across the screen instead of down the screen under the headers. Have attached an image for example. Is there a way to have the information so it runs down under the headers instead of across the excel file?

jkpieterse · Answer

How exactly was this data pulled into Excel?

smitha43 · Answer

It was a document that was downloaded from a website.

jkpieterse · Answer

What is the file extension of that document? https://www.howtogeek.com/205086/beginner-how-to-make-windows-show-file-extensions/

smitha43 · Answer

It is a .CSV document

jkpieterse · Answer

In that case, try this:- Open Excel- Open an empty workbook (control+N)- Click on the Data tab and click "From text/CSV"- Select your file and click "Transform Data"

Forum Discussion

Downloaded excel document not formatting with information under headers

8 Replies

Resources