up vote 2 down vote favorite
share [g+] share [fb]

How can I convert a excel file (.xls extension) with point climatic data into .cxt file which is a free format text file. My intention is to calculate evopotranspiration using ETo software. But when importing climatic data, the file with extention .cxt is required. I hope someone can help me to convert excel to .cxt file.

Thanks all

link|improve this question
2  
@user3063, what happens if you rename the .xls to .cxt manually in Windows Explorer? Can ETo software see or open the .cxt file? – Anonymous May 24 '11 at 12:39
@ user3063 -- Good suggestion. That would be the first thing I would try. Copy the file and change the extension. – Anonymous May 24 '11 at 14:52
Could you provide more information on the cxt-format, maybe an example? I googled it a bit didn't find anything that seemed to be a free format text file. – Riyaah May 24 '11 at 16:21
I found some information about the .cxt format in this PDF – Siim K May 26 '11 at 11:32
Siim K's PDF provides a lot of information about the calculations but little about the file formats. There appear to be three extensions: CXT, DSC and DAT. All are text files which are either tab delimited or fixed length. If the worksheets are in just the right format, Excel export might work. Otherwise this is a VBA task. – Tony Dallimore Dec 22 '11 at 16:56
feedback

migrated from gis.stackexchange.com May 24 '11 at 14:59

This question came from our site for cartographers, geographers and GIS professionals.

2 Answers

up vote 0 down vote

Per the documentation the .cxt file format is not supported by MicroSoft Excel. You will have to look for an add-in or external file converter.

link|improve this answer
feedback
up vote 0 down vote

Since .cxt is just space delimited with the order of the columns pre-determined you could to Save As...>.prn file. .prn files are space delimited/fixed width. Then you can change the extension in Windows Explorer.

If you need to do this action a lot it can all be automated of course.

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard