This feature in TSM makes the importing of data from excel, OpenOffice, text files and other files extremely easy.


Lets run through an example. In the screenshot below you can see a set of a data that contains many columns. As long as we have a Selection, Odds and Result column we can use the data. When importing data we can only import Decimal Odds.


Highlight all the data and copy it to the computer clipboard. In Excel this can be done by selecting the data and then either right click on the mouse and press copy or simply press Ctrl & C.



In TSM press 'Paste Data into TSM'. The Import Wizard screen will appear if there is any data.  You can now start the process of arranging your data.




When pasting the data from Excel we need to use the default delimiter of TAB. This has the result of putting the data in the columns as shown above.


Now press the 'Next' Button.



You can see on this screen we MUST tell TSM which columns contain the data we need. Notice also how the Start Import of data from Row Number is set to 2. This means that we miss out the first row containing headers.


Once happy press 'Next'.



TSM validates the data for you. In the example above there are no errors. You can either append the data to the current data you have or replace the data. Once complete press the 'Finish' Button.


If there are missing rows or missing odds or missing bet selections or even missing results TSM will create fake data for you and let you know in the Errors Found Text Box. You can manually edit any changes made directly on this screen.


There is a limit to the amount of data you can paste in. If you find your unable to paste all your data in one go you may need to split it up into smaller parts.

Once you press Finish you are taken back to main screen with the data now added.