I have created a civicrm custom dropdown field in Drupal 7. I have a excel spreadsheet contains some data in three columns. To which i need to import into civicrm and then the first column should be display in the custom dropdown field.
So, i have two opinions at this stage
1) I can create a custom table for Civicrm and then import the values from spreadsheet. OR
2) I can create taxonomies terms having 3 fields in Drupal.
After, that it should show it's values in the civicrm's custom dropdown field.
But i couldn't able to find out the correct way to implement any of the approaches. Please suggest me the steps to implement either of those approaches or any new approach which will be quite easy to implement.