UXD files will not open in excel

I am trying to import a UXD file via the 'text import wizard'. The file consists of two columns of numbers I would presume in columns A and B.

In step 1 of 3 I can choose 'Delimited' or 'fixed width' file types. I 'import from row 1' and the original file format automatically appears as 'MS-DOS (PC-8)'

The preview of my file actually shows the 2 columns as they should be displayed.

In step 2 of 3 I have tried most of the different delimiters and I'm not sure whether to tick the 'treat consecutive delimiters as one'

In step 3 of 3 I set 'column data format' as text and then I finish the process.

However, my spreadsheet appears blank! I don't know what I am doing wrong?

Originally Posted by Domski

I don't suppose you can post a sample file?

Dom

I am not permitted to upload the file because of the extension.

Originally Posted by onthejazz101

I am not permitted to upload the file because of the extension.

hopefully it will be attached in this message

Originally Posted by Domski

Hi,

The file appears just to be a comma delimited text file. Easy option would be to change the file extension from .uxd to .csv and it should then open in Excel automatically. Failing that opening it as you describe and using comma as the delimiter worked fine for me.

Dom

changing the extension to .csv allows the file to open. However, using comma delimited still will not work for me. I have tried both excel 2007 and 2010.

Originally Posted by Domski

I'm using 2003 but no matter what I do the file opens without any problem.

I've attached the file I opened through the Text Import Wizard.

Dom

The file you sent me opens with no problems. Thanks

I would like to ask: My ecxel is 2003, I can not find the "text import wizard".
Where is it?

hey guys im having the same issue would someone be able to help with converting my uxd file so they can be opened on excel

i have uploaded copies of the files

Hi,

Had the same problem... and worked out that Excel 2003 allows you to import the data correctly.

It must be a bug in Excel 2010 (and 2007?)?

The data can be seen in the import screen... but once you press the Finish button nothing comes up.

Changing the extension to .csv works but does not take you through the import options... which means data having two columns will not be correctly separated.

Changing the extension to .txt works!!!

You will get all the normal import options.

This seems like a bug. Can Microsoft please fix it?

:-)