How to Convert Text File Data to MS Excel Format
by ContributorMicrosoft Excel is a popular spreadsheet program that is incorporated into the Microsoft Office suite. Excel provides tools to calculate and plot data organized in columns and rows within a worksheet (spreadsheet). You often may have a set of tabulated data in the plain text format file. The Excel data import wizard allows you easily to convert text file data into a spreadsheet.
Step 1
Open Microsoft Excel using the desktop icon or from the "Start" menu.
Step 2
Choose the program menu "Data" and click "From text" in the field "Get External Data."
Step 3
Browse your computer to find the relevant text file.
Step 4
Double-click on the file to open the Excel Text Import Wizard. Click "Next." You will see a preview of your file data divided into columns.
Step 5
Double-click on the break line between two columns to merge them if necessary.
Step 6
Click on the break line between two columns and drag it to adjust the column width if necessary.
Click "Next" and then "Finish." Your data will appear in the Excel spreadsheet.
Items you will need
- Microsoft Office 2007
- "Excel 2007: The Missing Manual;" Matthew MacDonald; 2006
- Microsoft: Import or export text files in Excel
- number background image by kuhar from Fotolia.com