Spreadsheet Import Columns

If you keep your training log in your own Excel spreadsheet, you can import it directly — no detour through another format. The import recognizes column headers automatically by name; this chapter lists which names those are. The chapter Import Results describes the wizard’s own workflow.

How recognition works

Each column in your spreadsheet is matched to a target — date, score, weapon and so on — by its header text. Case doesn’t matter, and neither do small differences in spacing, periods, underscores or hyphens: “Day Total”, “day_total” and “Day-Total” are all recognized.

Per-shot columns are the one exception to a fixed word list. Instead, Ring Reader recognizes numbered columns that share a common name, for example Shot 1, Shot 2, … Shot 10 or Teiler 1, Teiler 2, … Teiler 10. The numbering must start at 1 without gaps — if a shot is missing in between, the column can’t be matched.

Recognized columns per series

Field	Recognized German headers	Recognized English headers
Date	Datum, Tag	Date, Day
Discipline	Disziplin, Kennziffer, Wettbewerb	Discipline, Event
Scoring mode (decimal/whole rings)	Wertung, Wertungsart	Scoring, Scoring Mode
Type (training/match/…)	Typ, Art	Type, Kind
Series total	Summe, Ergebnis, Punkte	Total, Score, Result, Series Total
Day total	Summe Tag, Tagessumme, Tagesergebnis, Gesamt	Day Total, Grand Total
Series/target number	Scheibe, Serie, Nr, Durchgang	Series, Target, No
Notes	Bemerkung, Notiz, Notizen, Kommentar	Notes, Comment, Comments, Remark
Weapon	Waffe, Pistole	Weapon, Gun, Rifle, Pistol
Ammunition	Munition, Patronen	Ammunition, Ammo, Pellet, Pellets
Location	Ort, Stand	Location, Range, Venue

Recognized columns per shot (numbered)

Field	Recognized German prefixes	Recognized English prefixes
Ring value	Schuss, Ringe, Punkte	Shot
Teiler	Teiler	Divisor

“Ring” and the short form “S” (e.g. “S 1, S 2, …”) are recognized as a prefix regardless of language.

A prefix is only recognized once at least two numbered columns share it — a single column named “Shot” with no number doesn’t count as a series of individual shots and has to be mapped by hand.

Recognized values in the scoring-mode column

Scoring mode	Recognized German values	Recognized English values
Whole rings	Ganze Ringe, Ganzring, Ganzringwertung	Whole Rings, Whole Ring, Integer, Full Rings
Decimal scoring	Zehntel, Zehntelwertung, Dezimal	Decimal, Tenths

Recognized values in the type column

Session type	Recognized German values	Recognized English values
Training	Training, Übung, Ubung	Practice
Match	Wettkampf, WK, Rundenwettkampf	Match, Competition
Dry fire	Trocken, Trockentraining	Dry Fire, Dry
Sighting-in	Probe, Probeschuss, Einschießen, Einschiessen	Sighting, Sighter, Sighters

“Training” is recognized as a value regardless of language; “Ubung” and “Einschiessen” are the accent-free variants of “Übung” and “Einschießen”.

Columns that aren’t recognized

Not every spreadsheet uses exactly these words. If the wizard doesn’t recognize a column automatically, it still shows it — in the “Map columns” step, you pick by hand which field an unrecognized column belongs to, or mark it “Ignore”. Nothing is lost; you just type it in once yourself.

Your data stays yours

Your spreadsheet is only read during import, to detect series and shots — it is never stored on the server.

Exporting from Google Sheets

If you keep your training log in Google Sheets instead of Excel, export it like this: File → Download → Microsoft Excel (.xlsx). Upload the downloaded file to the import wizard as usual.