extracting a table to Excel

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

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

eddylle
Posts: 23
Joined: Wed Apr 09, 2014 4:28 am

extracting a table to Excel

Postby eddylle » Sun Jul 20, 2014 11:47 am

Hi,

What is the simplest way to export a table (logit model) into an excel file? I've tried to copy/paste it but the dots do not make any sense in the copied version.

Thanks

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

Re: extracting a table to Excel

Postby EViews Gareth » Sun Jul 20, 2014 11:57 am

Could you provide more details?

eddylle
Posts: 23
Joined: Wed Apr 09, 2014 4:28 am

Re: extracting a table to Excel

Postby eddylle » Sun Jul 20, 2014 4:37 pm

I've got a logistic regression table, and I just want exactly the same table but on a .xlsx format, so export it from eviews format to excel format.

Thanks

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

Re: extracting a table to Excel

Postby EViews Gareth » Sun Jul 20, 2014 9:37 pm

Copy and paste.

eddylle
Posts: 23
Joined: Wed Apr 09, 2014 4:28 am

Re: extracting a table to Excel

Postby eddylle » Mon Jul 21, 2014 12:58 am

That's the point, I've tried it but we I do, I've got dots instead of comma in eviews, so a 35.500 (thirthy-five and a half) in eviews becomes a 35500,00 (thirthy-five thousands) in excel. As I have 15 explanatory variables, I'd like to avoid to change manually the dots for commas....

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

Re: extracting a table to Excel

Postby EViews Gareth » Mon Jul 21, 2014 7:51 am

That's a problem with the way Excel is interpreting the numbers. Try right clicking on the table and then saving it to disk as a CSV file, then opening that file up in Excel.

eddylle
Posts: 23
Joined: Wed Apr 09, 2014 4:28 am

Re: extracting a table to Excel

Postby eddylle » Mon Jul 21, 2014 7:58 am

Seems to work, Thanks!


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 1 guest