Convert ASCII file to an excel spreadsheet

Nxgagnie

New Member
Joined
Jun 2, 2006
Messages
13
I have a fixed text ASCII file that I need converted to an excel spreadsheet. Is this something I can do myself? Or is there a program or software I can download to do this?

The file is a zipcode file I purchased from the USPS.

Thanks for any help you can give!!
 

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

SydneyGeek

MrExcel MVP
Joined
Aug 5, 2003
Messages
12,251
Try, from Excel, opening the file. You will be asked to browse to the file: select the data type (Text files) or All files, locate the file, and click Open.
A wizard will launch, letting you select whether the file is delimited (select this if it has tabs, commas or other separators), or fixed width.
Click OK. If you selected Delimited, you will see the options. click (or enter) the one that your file uses, click OK, and you're done. Otherwise, you will see divider lines running down a sample of your data. Delete the ones that don't apply by double-clicking. Move the other lines until they are in the right place (click and drag). If any dividers are missing, double-click where they should be.
Click OK and finish the wizard.

You have to PAY for that in US? It's free in Oz! :biggrin:

Denis
 

Nxgagnie

New Member
Joined
Jun 2, 2006
Messages
13
You are too kind! On the USPS website they tell you that software has to be written or purchased to open the file. They make it sound very complicted. But, it sounds like I should be able to open it and get the data myself.
 

SydneyGeek

MrExcel MVP
Joined
Aug 5, 2003
Messages
12,251
Just to check, try opening the file in Notepad. Right-click, Open With... and pick Notepad. That will tell you what delimeters (if any) are used.

If it's commas, change the extension to .csv and double-click. Excel will open it directly.

Denis
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,168,127
Messages
5,857,528
Members
431,883
Latest member
Hien

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top