General discussion

Locked

text to Excel

By john.a.wills ·
How does one convert columns in a text file to columns in an Excel file? I know there is a text to column feature in the Data drop-down of Excel, but how to get material into Excel to which to apply that feature escapes me.

This conversation is currently closed to new comments.

7 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by Tony Hopkinson In reply to text to Excel

Just do File open and chnage the type of document from xls to .txt, .csv etc.
Note Excel will expect the columns to be delimited (separated) usually by tabs or commas. I think there is way of changing which characters are used.
You can also have a bit of fun with numbers and dates as well. If it puts it all in the first column, it didn't 'see' the columns.

Collapse -

by john.a.wills In reply to

I might have worked things out from this, but dryflies' answer gives all necessary detail and is immediately applicable.

Collapse -

by dryflies In reply to text to Excel

when you open a .txt or .csv file with excel, it launches the text import wizard autyomatically. you will have to choose whether the columns are fixed width or delimited and also if delimited, what the delimiting character is. You will also have the oportunity to see what your different choices do to the data in a preview window. one of the steps allows you to not import certain columns of data and to define what type of data is in each column (text, number, phone, etc.).

Have fun, it is a great tool.

Collapse -

by john.a.wills In reply to

Poster rated this answer.

Collapse -

by Oz_Media In reply to text to Excel

From Excel, FILE>IMPORT (choose text delimited or csv. depending on what the original file is saved as) MAP each column in the wizard, it usually figures most of it out and will give you a preview, then just choose whether you want column headers included or not.

Collapse -

by john.a.wills In reply to

There is no "Import" in my "File" downhang.

Collapse -

by john.a.wills In reply to text to Excel

This question was closed by the author

Back to Software Forum
7 total posts (Page 1 of 1)  

Related Discussions

Related Forums