How do I download large files from TranStats?
Answer
TranStats downloads of airline Origin and Destination Survey and On-Time data may be larger than the number of rows allowed by older versions of Microsoft Excel
- Microsoft Access can be used to open and aggregate data. See the attached instructions for more information. Note: If you are trying to calculate RPM's, ASM's, etc., you can't aggregate or you will get a total that's too large
- You may also want to use pivot tables in Excel to aggregate the data.
Links & Files
Contact Us
NTL Reference Librarians provide services for the transportation community and general public. Specific services are:
- Basic research assistance with Bureau of Transportation Statistics (BTS) publications and data products
- Assistance with access to information resources in ROSA P
- Referrals to operating administrations within US DOT
- USDOT history and archival research services
Can't find the answer you're looking for in the FAQs? Contact us for help.