xls to dat

Hello,

I have an Excel file which I get from an ftp site. I'm trying to moving it to a .dat file, so I can later process it. The problem is that the .dat file is full a garbage. Is there a way yo clean all the garbage from the .data file and just leave the original data.

Thanks!

Alex
LVL 23
paquicubaAsked:
Who is Participating?
 
njovinConnect With a Mentor Commented:
I'm not sure I follow what you mean by .DAT file.  Are you just trying to get the excel data out to plain text?  If so you should probably save it as TXT or CSV and then rename it to .DAT
0
 
woolmilkporcConnect With a Mentor Commented:
If you don't have MS Excel available to save the Excel tables as text or CSV you need a converter, e.g. this (payable) one -
http://www.ozgrid.com/Services/convert-excel-text-txt.htm
Search the web, maybe there are free converters out there.
wmp
0
 
paquicubaAuthor Commented:
Thanks!
I installed xls2csv --it's working like a charm!
0
All Courses

From novice to tech pro — start learning today.