Discussion Locked

text to Excel

0 helpful
7 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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.

7 replies

by tony hopkinson

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.

by john.a.wills

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

by dryflies

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.

by oz_media

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.

This discussion is closed to new replies.