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. 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
  • Access videos and tutorials provided by Microsoft 
  • You may also want to use pivot tables in Excel to aggregate the data. 

(Note: The above private-sector site is not maintained by USDOT or any other US Government office. We take no responsibility for the content or accuracy of any non-USDOT web page, and offer the above link strictly as a courtesy, should you be interested.)

  • Last Updated Nov 08, 2022
  • Views 161
  • Answered By Victoria Milam

FAQ Actions

Was this helpful? 0 1

Contact Us

NTL Reference Librarians provide services for the transportation community and general public.  Specific services are:

Can't find the answer you're looking for in the FAQs? Contact us for help.