How do I import data from Eviews to Excel

For questions regarding the import, export and manipulation of data in EViews, including graphing and basic statistics.

Moderators: EViews Gareth, EViews Jason, EViews Steve, EViews Moderator

nihilit
Posts: 4
Joined: Wed Oct 08, 2008 7:16 am

How do I import data from Eviews to Excel

Postby nihilit » Wed Oct 08, 2008 7:55 am

Hi,

is it possible to open eviews file from excel. My colleagues do not need eviews but they need the data I estimated from Eviews. Is it possible to open Eviews files with Excel, without Eviews installed?

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 13307
Joined: Tue Sep 16, 2008 5:38 pm

Re: How do I import data from Eviews to Excel

Postby EViews Gareth » Wed Oct 08, 2008 8:00 am

Unfortunately Microsoft has not (yet?) given Excel the capability to read EViews files. However from within EViews you can save your data in Excel format (just choose File->Save As and then change the file type to Excel).
Follow us on Twitter @IHSEViews

nihilit
Posts: 4
Joined: Wed Oct 08, 2008 7:16 am

Re: How do I import data from Eviews to Excel

Postby nihilit » Wed Oct 08, 2008 8:37 am

Hi,

I found an add-inn for excel, which can open eviews files :D

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 13307
Joined: Tue Sep 16, 2008 5:38 pm

Re: How do I import data from Eviews to Excel

Postby EViews Gareth » Wed Oct 08, 2008 8:38 am

Really?

Could you point me in the direction of it, I'm intrigued.
Follow us on Twitter @IHSEViews

nihilit
Posts: 4
Joined: Wed Oct 08, 2008 7:16 am

Re: How do I import data from Eviews to Excel

Postby nihilit » Wed Oct 08, 2008 8:40 am

sorry, i forgot to add the link. this add-in seems to be free
http://www.web-reg.de/files/setup_wr_wf1toxls.exe

JimForest
Posts: 83
Joined: Thu Oct 16, 2008 7:53 pm
Location: MA

Re: How do I import data from Eviews to Excel

Postby JimForest » Sat Nov 29, 2008 1:32 pm

i tried using this. I installed and opened up excel. When I try to open a wf1 it still has weird characters.

marina
Posts: 1
Joined: Sat Dec 20, 2008 9:39 am

Re: How do I import data from Eviews to Excel

Postby marina » Sat Dec 20, 2008 9:50 am

I also installed and activated the add-in but it doesn't work

@ Nihilit: do you know how I can use the add-in to convert my wf1 file to xls?

or can anyone convert a wf1 file I created to xls for me? I need it desperately to finish my thesis which I have to submit before Christmas! Thanks

startz
Non-normality and collinearity are NOT problems!
Posts: 3775
Joined: Wed Sep 17, 2008 2:25 pm

Re: How do I import data from Eviews to Excel

Postby startz » Sat Dec 20, 2008 10:37 am

marina wrote:I also installed and activated the add-in but it doesn't work

@ Nihilit: do you know how I can use the add-in to convert my wf1 file to xls?

or can anyone convert a wf1 file I created to xls for me? I need it desperately to finish my thesis which I have to submit before Christmas! Thanks

As Gareth pointed out, it's easy to save your workfile in Excel format from within EViews.

nihilit
Posts: 4
Joined: Wed Oct 08, 2008 7:16 am

Re: How do I import data from Eviews to Excel

Postby nihilit » Mon Jan 05, 2009 2:43 pm

you must open it with the menu which the add-in provide. have a look at the author page
http://web-reg.googlegroups.com/web/wf1toxls.jpg

startz
Non-normality and collinearity are NOT problems!
Posts: 3775
Joined: Wed Sep 17, 2008 2:25 pm

Re: How do I import data from Eviews to Excel

Postby startz » Mon Jan 05, 2009 2:58 pm

The format for the EViews workfile is (a) pretty complicated and (b) proprietary.
It is unlikely that any Excel add-in is going to convert anything other than a very simple workfile. For some uses, that may be good enough, but most people will be far better off exporting from EViews rather than importing to Excel.


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 11 guests