Extract Trade Partner Data

You can extract data from the Tradeflow database to a MS-Excel (XLSX) format file, an Extended Markup Language (XML) format file, or CSV format file.

For tips on successfully extracting data, see the FAQ on optimizing your searches for extraction.

To open the extract in a new window, see the FAQ on changing your browser settings.

To extract trade partner data:

1    Click Find Trade Partner from the left navigation panel.

2    Search for the records you want to screen. Make sure the search results show only the Trade Partners you want to screen. Narrow your search until you have only the Trade Partner records you want to screen.

3    Click Extract; the Extract Trade Partner window will pop up.

Figure 1: Extract Trade Partner Pop-up Window

4    Select the extract format. With names and with codes refers to whether you want the field values spelled out or left as codes. For example, country of origin is CA or Canada.

• If you choose MS-Excel (XLSX), only the columns shown on the screen will appear in the file.  If you choose XML, all available data on the product will be shown. You can add more columns to be displayed in the MS-Excel (XLSX) file by configuring your search fields. See Configure Search for more information.

5    Select the delivery method for extraction. You can select from either Display in new window or Email to....

6    Click Extract. Your search results will be extracted.