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

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.
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
 
Upvote 0
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.
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,217,758
Messages
6,138,438
Members
450,137
Latest member
HANHAN

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
Back
Top