How do I use the Foreign Trade DropBox (FTD)?
The FTD DropBox is a web page you can use to download files you've requested from the Foreign Trade Division (FTD). These files contain data on U.S. imports or exports.
My FTD DropBox file is displayed as text in my browser window. What do I do?
This depends on what kind of file you have. There are two basic types of data files you'll download from this site: a Report Format or an ASCII Delimited File.
This file is formatted so that you can import it into a spreadsheet or database. Double quotes (") encase the text and either spaces or commas (,) separate each column. For instructions on importing it into a spreadsheet, see the question "Trade Data - Comma Delimited Files (CSV)."
My file has numbers and text separated by commas. What do I do?
This file is an ASCII delimited and is formatted so that you can import it into a spreadsheet or database. Double quotes (") encase the text and either spaces or commas (,) separate each column. For instructions on importing it into a spreadsheet, see the question "Trade Data - Comma Delimited Files (CSV)."
Reformat: When I open my REPORT FORMAT file in a word processor, the columns are not straight. How do I straighten these columns?
You'll need to reformat your report. The report format files are designed to be displayed landscape (8.5" down and 11" across) as opposed to portrait (11" down and 8.5" across). Note that most word processors automatically display files portrait, but if displayed portrait, the lines of your report will wrap incorrectly.
To correct the alignment, try the following steps:
Note that the above instructions will vary between computer platforms and applications. However, reformatting should not be too difficult to accomplish.
How do I print the right-hand columns of my report?
The report format reports in the FTD DropBox have a great deal of data on each line. Depending on your browser settings, the text may go off the right side of the page. Your best bet is to save the file to your hard drive ("File", "Save As...") and open it in a word processor. Once you do this, you'll have to reformat the file.
When I print my report format file from my browser it does not break at the top of the pages. Why not?
The report format file in the FTD DropBox are plain text files with page breaks at the top of each page. Web browsers, however, do not recognize those page breaks when you print them. Your best bet is to save the file to your hard drive ("File", "Save As...") and open it in a word processor. If the page appears as it was in your web browser, print it. Otherwise, reformat the file.
When I hit the "Retrieve this file" button while downloading my file from the FTD DropBox, the screen says "Too Many Unsuccessful Attempts." What do I do?
This means that you have entered three or more incorrect file names during your current session. Please do the following: