The Spreadsheet report - Creditors will list all the creditor (supplier / vendor) accounts in a spreadsheet. 

The data in this spreadsheet is the same as the Creditor listing - "List postal addresses" report (Reports → Creditors →  Listing (Reports ribbon)).

To import the creditor (supplier / vendor) accounts: 

On the Reports ribbon, select Spreadsheet reports → Creditors.

Disabled (inactive) creditor (supplier / vendor) accounts will be included in this spreadsheet report.