Converting .txt file to excel

[SEO Lady]

Oh please can someone help me convert a huge .txt file to Excel?

If you can show me here, fine I'll try and do it myself, I have just Googled it and a bit lost, or otherwise DM me, thanks

 

[MikeJ]

Open it in Notepad, or in Word if it's too big.

Select all.

Copy

Open excel

Paste. (you may need to paste special, then as text if you've gone via word)

 

[Magsite]

Can't you open it in wordpad, save as whatever.csv then open it in excel?

 

[SEO Lady]

Open it in Notepad, or in Word if it's too big.

Select all.

Copy

Open excel

Paste. (you may need to paste special, then as text if you've gone via word)

I never ever thought it would be as simple as that! Thank you so much

 

[spreadsheetsdirect]

You just need to open it in Excel and the text wizard will open up allowing you to set the columns. might need a bit of playing around with delimiters to get it right though.