How to Export Excel 2010 to fixed width text file

This tutorial will demonstrate how to export data from Excel to a fixed width text file

In this tutorial you are going to learn how to export excel to fixed width text file so it is easily viewable even by people who don't have access to Excel.

Step # 1 -- Selecting Save As

Generally when you export an Excel file to text it will not keep the widths that you have defined in excel. In the spreadsheet here you can see that the "Share" column is larger than the other two and this is a width that we want to "fix" in the exported file. Click on the "File" button in the top left corner of the screen, from here click on the "Save As" option.

Step # 2 -- Saving as a .prn File

The "Save As" window will appear. You don't want to save as a regular text file but instead as a "*.prn" file. Click on the "Save as type" drop down list and click on the "Formatted Text (Space Delimited)" option. Click "Save". Click "Yes" in the dialog box that appears. That is essentially how to export excel to fixed width text file.

Step # 3 -- Selecting Save As

Now, to make sure that the column space has been exported into the text file, you are going to need to open it. Navigate to where you saved the file and open the document with Notepad. Here you can see that the spacing has been kept the same as in the original spreadsheet.

[AlanTraxler]

This saved me some time today. Thanks for making a quick, easy to follow guide!

[TebogoMotlhale]

the video took LONGER to watch than if it simply showed a single Stand Still frame with text/writing = File > Save As > .prn LOL, nice Angelic voice in the video thou :) :)

[ultspider]

Nowhere did you show how I could set the width.

[samo]

The narrator can't be a real person, correct? It's a computer-generated voice I think.