Exporting to Excel
Up one level
Exporting to Excel
On my Mac, I've been exporting files as tab-delimited text so that I can work with them in Excel. However, this isn't working on Windows - it loses the IPA font and / or the timeline in the process. Can anyone recommend a way this will work without requiring copious amounts of editing after exporting the file?<br>
Re: Exporting to Excel
Hmm, can't reproduce the problem. It is possible to export annotations with IPA characters and open them in Excel on Windows. And after selecting a proper font in Excel all characters seem to look alright.
Have you chosen UTF-8 encoding in the 'export as' file dialog?
Han
Re: Re: Exporting to Excel
We've tried all of the different options for encoding that were given - UTF 8, UTF 16 (which is what I've been using on my Mac) and ISO-8859-1.<br>
Re: Re: Re: Exporting to Excel
Also, which font are you using?<br>
Re: Re: Re: Re: Exporting to Excel
Although it shouldn't matter for the export process, I used Arial Unicode MS. The export function is font independent, whether or not you can see the characters properly in some other application depends on the font selection in that application.
I'm puzzled by the fact that you say that sometimes the timeline is lost. What exactly does that mean? If you open the exported text file in a text editor is some of the (time) information missing?
You could send me the/a .eaf file and a description of which tiers you export and with what options, so that I can try to reproduce the problem with the same file?
Han
Re: Re: Re: Re: Re: Exporting to Excel
We have now solved the problem - my colleague was opening the file directly into Excel, which seems to lose the IPA font, but it is fine if opened in Word and then copied and pasted into Excel. She lost the timeline because she was opening the .eaf file directly into Excel.<br>
Release of ELAN 4.3.0
