manelson05
asked on
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
PA-Export-01.xlsx
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
PA-Export-01.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Please see the format I am trying to achieve, this is from our system.
ASKER
Here is the file
sys-export.PNG
sys-export.PNG
ASKER
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.
Any help or if I need to map fields would be appreciated.
ASKER
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?