Do you know how to import a large txt file into excel?

Ha, so we meet again ;)
I'll try to leave the long/lat data out to make it a bit smaller, but this kind of data really gets handled easier in a database table than in Excel.

Excel has limited number of columns and rows in sheet. The limits are different in different MS Office versions. Even if somebody with Excel 2013 (limited to 1,048,576 rows by 16,384 columns) can import your data (I didn't check number of rows in your file), you will not be able to use it in older versions.
If you want to make computations on such big file, use another software, MS Access for example.

Excel 2010 also only 1,048,576  of the 2,172,789. It's no problem to read it into Access, if you don't have that maybe SQL Express is an option?

what version of excel do you have?  if you have 2010  or 2013 then we can use the powerpivot add-in that can import more than the limit of the excel.
confirm the version of excel you have

I have excel 2010. I don't have Access

I imported your data using the Text Wizard (Data tab -> Get External Data -> From Text).

In fact, only the last line of the US.txt file is not imported into the page!

Paul,

how could you import that whereas the rows are in millions? it is beyond the limit of excel max rows.

I'm using MS Office 2010 Home & Student edition - Win 7 Home Premium. Using the Text Wizard i imported 1048576 rows!

Not millions, a bit over a million (2 ** 20 = 1048576)!

I can get that too but not anything over that. When I open a new spreadsheet and use that process, telling it to download at
that number row or even starting at 1,000,000 for some reason I just get a fragment of the remaining 1 million+ rows.

Paul,

the data which mabehr uploaded txt file has 2,172,788 rows  which is beyond the limit of 1048576

Mabehr

here is the solution for you.

albeit powerpivot could be also an option, but i have improted the txt into excel into the 4 worksheets.

i used freeware http://csved.sjfrancke.nl/ software portable to split the txt file into the 4 pieces and then i imported them in Excel.

Now, to use all four sheets as your lookup table, you can combine lookup tables in Index-Match with adding iferror function.

i tried to attached the combined file, but EE has a limit of 50MB so could not be uploaded in this forum. but using that freware soft you can do it by yourself.

Remains a question how handy a huge sheet like that is and what the performance of lookup is. Without Access I'd still go for free SQL server and create a link from Excel to the database.

Rene, how would you do the above?

Give me a bit and I'll see if I can come with a solution for you

I thought you wanted the Zip codes - this file contains schools, hotels, restaurants etc.

I do want zip codes. I was told that this site contained a listing of zip codes for every city and state in the us:
http://download.geonames.org/export/dump/ and specifically the US.zip file.

Finally! Glad we got that figured out. Thanks ReneD. I'll use this.

My next question will be a related one after I finish with what I was trying to do with my previous question.

Thanks, again. :)