In this article I'll explain how to import of .prn files into an existing sheet in Excel.
If you've ever tried to open a text file, you have probably used the Text import wizard.
First select the sheet where your data needs to appear. Note that the following steps differ for the various Excel versions.
1, Start Excel.
2, View all readable text files.
3, Navigate to and select the .PRN document you want to convert.
4, So far we've selected what to import. Now it is time to define what settings we need for the import. This section applies to all Excel versions as of Excel XP (and maybe even older). The screenshots shown here may look slightly different from yours, but the principle is the same.
5, Click the Open button. Step 1 of the Text Import Wizard (define data type) opens up, and select the "Fixed width" radio button in Text Import Wizard Dialog.
Step 1 of the Text Import Wizard (define data type)
6, Click Next button, it will show Step 2 of the Text Import Wizard (define field widths)
Step 2 of the Text Import Wizard (define field widths)
7,Click Next button, it will show Step 3 of the wizard (Define column formats)
Step 3 of the wizard, Define column formats
8. You can click the "Advanced" button to set up details like the decimal and thousands separators (note I switched them here):
The Advanced text Import Settings dialog
9, After you finished defining all columns, click the Finish button, so there you go, all done!
Importing PRN into Excel can be a labor-intensive process if you're going through the same steps over and over again. Fortunately, there is a software Fast PRN to Excel Converter can automatically and quickly batch convert prn to excel files, you can save yourself quite some work and at the same time improve consistency.