• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 231
  • Last Modified:

How can I import text file in to Excel 2013

I am only able to export into a txt file, I really need to be able to export to excel and have proper spacing so I can analyze the data I have thousands of rows of data.

Here is what the date looks like:

Trx Type TS No. Date Employee ID Project Number Cost Category ID Pay Code U of M Unit Cost Quantity Total Costs Accr. Revenues Billing Rate % Markup Overhead Amount Overhead % Total Overhead Contract Number Export Date
Standard TS000000021 4/16/2013 10006 DSINTPOLARQUICK INTERNAL LABOR Hour HOUR $29.23 10.88 $413.43 $0.00 $0.00 0.00% $0.00 30.00% $95.41 DSINTPOLAR 9/19/2013
Standard TS000000021 4/17/2013 10006 DSINTPOLARQUICK INTERNAL LABOR Hour HOUR $29.23 9.27 $352.25 $0.00 $0.00 0.00% $0.00 30.00% $81.29 DSINTPOLAR 9/19/2013
  • 4
1 Solution
SeanSystem EngineerCommented:
You can import data from a text file into an existing worksheet as an external data range.

    Click the cell where you want to put the data from the text file.
    On the Data tab, in the Get External Data group, click From Text.

    In the Address bar, locate and double-click the text file that you want to import.

Follow the instructions in the Text Import Wizard.
manelson05Author Commented:
IM doing that and I get 14k rows.
Everything goes into one column even the column headings.

I am wanting it to all map out so I can then analyze the data.

Any suggestions?
manelson05Author Commented:
Please see the format I am trying to achieve, this is from our system.
manelson05Author Commented:
Here is the file
manelson05Author Commented:
I am able to export as .csv but it all goes in one column.
Any help or if I need to map fields would be appreciated.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now