test and train data set

should i make two data sets if i want to use algorithms ..and if i want to make dataset on my own should i create a single excel file or two excel files having one of them as training dataset and the other one as test data set and what difference should i keep in training dataset and the test dataset if these are two different files