Download the .csv file that contains your Los Angeles data here.
Oh wait, that file is going to exceed Excel’s limit of 1,048,576 rows. Let’s split it up instead. We’ll call the two files los_angeles_1.csv and los_angeles_2.csv. The former contains all the records for Los Angeles that were in Sheet 6 of your original IPUMS Excel doc. (129,783 rows.) The latter contains all the records for Los Angeles that were in Sheet 7. (960,000.)