Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

share|improve this question

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

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

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. – Erika 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

I'm sure you fixed this problem, but I'd like to leave this note for future users.

1 - Download EditPad Lite (free text editor - http://www.editpadlite.com/),

2 - copy the data from excel to the editor,

3 - save the file, in the "save as type" select "Unspecified file type (.)",

4 - go to the folder and change manually the extension to .CXT,

5 - Open the ETo calculator and import the file.

Hope this helps.

share|improve this answer
1  
Welcome to SuperUser! Thanks for posting this solution, to help out anyone else who might come looking. – hBy2Py Jun 5 '15 at 15:32

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.

share|improve this answer

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.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.