WinTD will allow you to import a finished cross table from a text file or spreadsheet. This can be useful if you want to create a US Chess or FIDE rating report, or do some other type of post-tournament processing.

 

WinTD does the import one section at a time. You need to create the section(s) first, using standard means. Make sure that the import file has the correct format (as described below). Then use the Section>Import Cross Table… function. Make sure you choose the correct file type.

 

Import File Format

There should be one line per player, and the data must already be parsed into fields. If you're doing a "Copy and Paste" from a web site, this will usually paste into a spreadsheet in something reasonably close to the correct format. If, however, the downloaded file is "preformatted" text, you'll have to use your spreadsheet's parsing operation to separate the text into columns. (This is done with Text to Columns on the Data menu in Excel).

 

The first row in the file should include the column labels. For many of the fields, WinTD is looking for a specific field title, or it could permit one of a few alternatives. If the file has a field with a title not given below, WinTD will skip it. If it's important that the field be processed, change the field title on the input file. For instance, if the player number field has a blank title on your file, you'll need to alter the file to show one of the four alternatives below.

 

Fields that are specific to importing a cross table are:

 

 

Game Information

 

The content for the round fields must be Wnnn for wins, Dnnn for draws and Lnnn for losses, where nnn is the opponent's number. (Spaces are permitted between the result code and the player number). Byes and forfeits should have B for a full point bye, H for a half point bye, N or U or blank for an unplayed game or zero point bye, F for a forfeit loss, X for a forfeit win and Z for a forfeit "draw", though W, L and D without an opponent number can be used for unplayed games as well. In all of these, spaces or dashes can be included in the code, so -B- or B alone can be used for a full point bye. For played games, you can include the color as a postfix, so W180b would be W vs 180 playing Black.

 

Example (Partial)

 

# Name                 USCF ID  USCF Rd 1 Rd 2 Rd 3 Rd 4 Rd 5 Rd 6 Rd 7 Rd 8 Rd 9

1 Smirin, Ilya         12544869 2794 W--- D192 W11  W8   D7   W20  W2   D4   D3

2 Onischuk, Alexander  12625186 2746 W188 W72  W21  W28  W38  D4   L1   D9   W16

3 Akobian, Varuzhan    12740522 2570 W95  W62  D5   D6   W184 W21  D27  W38  D1

4 Finegold, Benjamin   11264417 2639 W51  D91  W131 W41  W37  D2   W19  D1   D6

 

How WinTD Imports the Information

 

A cross table includes quite a bit less information than would be available in a full tournament file. For instance, the colors are usually absent and board assignments for games are missing. Because of this, the imported file should only be used for limited types of post-tournament processing which don't require the greater detail. Don't try to import half a tournament intending to switch to WinTD unless you're willing to spend a considerable amount of time correcting the color assignments in the existing games. Note also that WinTD will import each game twice. If player 1 beats player 8 in round 3, WinTD will create one game record for the W8 for player 1, and another for the L1 for player 8. (WinTD does this so the import can be done one player at a time without complicated cross checking).

Copyright © 2026 Thomas Doan