Opening a .PRN file in Microsoft Excel 2007

November 24, 2010 at 09:06:21
Specs: Windows 7
I'm using Micorsoft 2007 and trying to open a file with a .PRN extension. This is a comma-delimited file and created several years ago from our legacy system. In the past, I would open the files using the Wizard and I would open it as a comma-delimited file in Excel. The file today only opens in Wordpad of Notepad. I must have it open in Microsoft EXCEL 2007. Any ideas?

See More: Opening a .PRN file in Microsoft Excel 2007

November 24, 2010 at 09:15:23
That is not a comma deliminated file but a print file. You could go copy filename lpt1 to print it.

You may want to associate the prn extension with excel or do a right mouse click and open with choosing excel.

Moderator please move to Office forum where you may get a better answer

Answers are only as good as the information you provide.
How to properly post a question:

Report •

November 24, 2010 at 14:35:23
.PRN is interpreted as blank delimited columns. Start excel and import thr file as space delimited. I hate the ribbon interface of Office 2007, but I am sure the command exist as there is in Excel 2003 under Data menu.

Report •

December 9, 2010 at 09:59:42
save the .prn file to your desktop. Before opening, change the extension to .xls. The file can be delimited in Excel.
In Windows 7, I have .prn associated with Excel, but it still does not open immediately. I have to change the extension first to .xls & then it open.
So far this is the only way Ive been able to open this file in Windows 7.

Report •
Related Solutions

Ask Question