XML file to Excel, error when opening

Question

I have this file here:

<?xml?>
<table name="data">
<row et_kt="215846" et_nafn="" et_kt_maka="" et_kt_fjolsk="215846" et_kyn="X" et_hjusk_stada="1" et_faeddag="190201" et_danrdag="198612" />
<row et_kt="239287" et_nafn="" et_kt_maka="" et_kt_fjolsk="239287" et_kyn="X" et_hjusk_stada="4" et_faeddag="190401" et_danrdag="199106" />
.
.
.
</table>

Excel tell me the file is in a different format than the .xml implies. What's wrong with the format?

score 1 · Accepted Answer · edited May 23 '17 at 11:43

1

Try changing <?xml?> for <?xml version="1.0"?>.

EDIT: Check this answer for some extra information about the issue.

edited May 23 '17 at 11:43

Community

1
1

answered Jul 12 '13 at 15:35

Racso

2,310
1
18
23

Your edit: Thank you, that solved the problem! I was missing version="1.0". – KSHMR Jul 12 '13 at 15:52

Artful_dodger · Answer 2 · 2013-07-15T13:32:39.377

1

at first glance I'd say that that there is no valid xml declaration ie <?xml version="1.0" encoding="UTF-8" ?> or as it a microsoft product may be you should try <?xml version = "1.0" encoding="Windows-1252" standalone="yes"?>

edited Jul 15 '13 at 13:32

answered Jul 12 '13 at 15:54

Artful_dodger

698
2
7
26

XML file to Excel, error when opening

2 Answers2