CiviCRM Community Forums (archive)

I see that to use the country_code I need to know the nation of my contact, in my files to import actually is missing exactly country, so I need to add column of country.
I'm not a developer, and with excel, ultraedit, notepad, notepad ++ look to be impossible
i need to see csv file in columns like in excel, but esxcel show this like a normal text file, not in columns, how I can easily add a column on many csv files?

I always do my import files in Excel.

I use all the excel tools to add columns, delete, concatenate, and do all the special excel manipulations (vlookup is your friend).
My excel workbook will often have multiple worksheets all with data in different formats and from different sources. Formulas carry the data from one worksheet to another until a final worksheet that is my final civicrm import data.

When my data is ready, I open my excel workbook, save just the civicrm import worksheet as a csv, then import the resulting csv file into CiviCRM.

With complex imports, I will often have to iterate multiple times before I have resolved all the various importing errors reported by CiviCRM. I remember one particularly large and complex import I probably ran the CiviCRM import 25 times before I had worked out all the kinks. That was back in the days when the import ran MUCH slower than it does today.

In your specific case, I would open the csv file in excel. Then I would add a column in excel for the country, enter your country information, then save as csv. Should be pretty simple.