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

Convert text file to excel

Hello Guys,

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

Please let me know
0
techlabtest
Asked:
techlabtest
1 Solution
 
Dan CraciunIT ConsultantCommented:
Open/Libre Office: https://www.libreoffice.org/download

HTH,
Dan
0
 
tel2Commented:
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
 
samrad1Commented:
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
 
Paul SauvéRetiredCommented:
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
 
steveoskhCommented:
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
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.

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