Solved

Convert text file to excel

Posted on 2013-11-20
5
346 Views
Last Modified: 2013-11-21
Hello Guys,

Can i have a free software that can convert text file to excel.

Please let me know
0
Comment
Question by:techlabtest
5 Comments
 
LVL 34

Expert Comment

by:Dan Craciun
Comment Utility
Open/Libre Office: https://www.libreoffice.org/download

HTH,
Dan
0
 
LVL 11

Expert Comment

by:tel2
Comment Utility
Hi techlabtest,

If you have Excel, you can import it, or copy/paste it in.

If you don't, let us know.

How are the cells delimited?  By tabs, commas, or what?
0
 
LVL 2

Accepted Solution

by:
samrad1 earned 500 total points
Comment Utility
If you have Excel, you can use the "from text" button on the data tab to import it and clean it up a bit.
0
 
LVL 31

Expert Comment

by:Paul Sauvé
Comment Utility
From a text file:

Copy paragraphs to Excel - each paragraph will copy to a new cell, several paragraphs will give you a column with one cell per paragraph

If you have 'new' line breaks instead of 'new' paragraph breaks, each line will copy to a new cell, several lines will give you a column with one cell per

If you have tabs in a line, each part of the line to the left of a tab will be copied into Excel as a new cell in the same row.

So format your text to get the appropriate result BEFORE copying into Excel!
0
 
LVL 14

Expert Comment

by:steveoskh
Comment Utility
You can create a file that will open with excel by delimiting the data in a certain way.  Opening with Excel will depend on the end users settings, but generally if the file has a csv extension, i.e, sample.csv it will open in Excel.   So if your data is

CollA, "text field with comma", CollB, 3/11/2013, "more text,,,,"blank field before this"

It will open in excel with minimal dialog required by the user.

If you want to save a file in .xls or .xlsx then you need a program that will save files in this format.   You can do this with open office (first answer above) or you can also do it online in Google Docs if you have a google account (free).  Or with other online resources  http://www.editgrid.com/  or this search  http://webtrends.about.com/od/office20/tp/best-free-online-spreadsheets.htm
0

Featured Post

Get up to 2TB FREE CLOUD per backup license!

An exclusive Black Friday offer just for Expert Exchange audience! Buy any of our top-rated backup solutions & get up to 2TB free cloud per system! Perform local & cloud backup in the same step, and restore instantly—anytime, anywhere. Grab this deal now before it disappears!

Join & Write a Comment

I use more than 1 computer in my office for various reasons. Multiple keyboards and mice take up more than just extra space, they make working a little more complicated. Using one mouse and keyboard for all of my computers makes life easier. This co…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now