Language

Deltafolio · Import

Move your records into Deltafolio, step by step

Start with a blank template, add your records, check the file, and decide when to bring them into Deltafolio. Follow the steps in order; you do not need to know how data files work.

This is for an athlete with no saved performances in Deltafolio. You can prepare the file before creating an account. Import cannot add to existing records.

Follow these steps

  1. Check that Import is available

    Use this guide before you add any Performance in Deltafolio. Your account needs a complete athlete profile and no saved performances.

    You are ready when: You have no saved performances, and your own records are ready to enter.

  2. Download one blank template

    Choose English or Japanese column headings—whichever you prefer to read. Either file works with either Deltafolio display language. Keep every heading exactly as downloaded.

    ENperformance_datedisciplineJA日付種目
    The two downloads change column headings only. The values you type follow the same rules.
    Download English header templateDownload Japanese header template

    The template has headings only. It is not ready to Import until you add at least one complete record.

    You are ready when: A file named deltafolio-performance-template-en.csv or -ja.csv is on your device.

  3. Open it in desktop Excel

    Open the downloaded file in Microsoft Excel. Select the whole sheet using the top-left corner, then choose Home → Number Format → Text before typing, so dates and numbers stay as you entered them.

    You are ready when: You see the headings across the first row and a blank second row for your first record.

  4. Enter records from row 2 onward

    Keep row 1's headings unchanged. Start your first record in row 2, then put the next record in row 3, the next in row 4, and so on—one Performance per row. The example below shows a made-up 100m result: enter its date, event, result, unit, and 0 in both count columns; leave other cells blank if they do not apply. Enter every record you want to import before moving on to Save.

    A2EN: performance_dateJA: 日付2026-09-29
    C2EN: disciplineJA: 種目100m
    D2EN: result_valueJA: 記録12.34
    E2EN: result_unitJA: 記録単位seconds
    S2EN: evidence_countJA: 記録資料件数0
    U2EN: field_attempt_countJA: 試技件数0
    The first record in row 2 is a made-up example. Add later records on new rows. English and Japanese templates have different headings, but the values are the same.

    If your event needs a condition or timing method, find its meaning below and type the exact code in the matching column. The table shows which event each condition belongs to.

    Event condition (if your event needs one)

    EN: event_specification / JA: 種目条件

    Scroll the table sideways to see every column.

    EventMeaningEnter this code
    60m Hurdles0.914 m · 5 hurdles · start 13.72 m / interval 9.14 mh60-0p914-9p14
    60m Hurdles0.991 m · 5 hurdles · start 13.72 m / interval 9.14 mh60-0p991-9p14
    60m Hurdles1.067 m · 5 hurdles · start 13.72 m / interval 9.14 mh60-1p067-9p14
    60m Hurdles0.762 m · 5 hurdles · start 13 m / interval 8.5 mh60-0p762-8p5
    60m Hurdles0.838 m · 5 hurdles · start 13 m / interval 8.5 mh60-0p838-8p5
    100m Hurdles0.838 m · 10 hurdles · start 13 m / interval 8.5 mh100-0p838-8p5
    100m Hurdles0.762 m · 10 hurdles · start 13 m / interval 8.5 mh100-0p762-8p5
    100m Hurdles0.762 m · 10 hurdles · start 13 m / interval 8.0 mh100-0p762-8p0
    110m Hurdles1.067 m · 10 hurdles · start 13.72 m / interval 9.14 mh110-1p067-9p14
    110m Hurdles0.991 m · 10 hurdles · start 13.72 m / interval 9.14 mh110-0p991-9p14
    110m Hurdles0.914 m · 10 hurdles · start 13.72 m / interval 9.14 mh110-0p914-9p14
    400m Hurdles0.914 m · 10 hurdles · start 45 m / interval 35 mh400-0p914-35
    400m Hurdles0.838 m · 10 hurdles · start 45 m / interval 35 mh400-0p838-35
    400m Hurdles0.762 m · 10 hurdles · start 45 m / interval 35 mh400-0p762-35
    3000m Steeplechase0.914 m · 28 barriers + 7 water jumpssc3000-0p914
    3000m Steeplechase0.838 m · 28 barriers + 7 water jumpssc3000-0p838
    3000m Steeplechase0.762 m · 28 barriers + 7 water jumpssc3000-0p762
    Half Marathon Race WalkRoad courseroad
    Half Marathon Race Walk400 m tracktrack-400m
    Marathon Race WalkRoad courseroad
    Marathon Race Walk400 m tracktrack-400m
    Shot PutCurrent 2.721 kgshot-2p721kg
    Shot PutCurrent 3 kgshot-3kg
    Shot PutCurrent 4 kgshot-4kg
    Shot PutCurrent 5 kgshot-5kg
    Shot PutCurrent 6 kgshot-6kg
    Shot PutCurrent 7.260 kgshot-7p260kg
    Discus ThrowCurrent 1 kgdiscus-1kg
    Discus ThrowCurrent 1.5 kgdiscus-1p5kg
    Discus ThrowCurrent 1.75 kgdiscus-1p75kg
    Discus ThrowCurrent 2 kgdiscus-2kg
    Hammer ThrowCurrent 3 kghammer-3kg
    Hammer ThrowCurrent 4 kghammer-4kg
    Hammer ThrowCurrent 5 kghammer-5kg
    Hammer ThrowCurrent 6 kghammer-6kg
    Hammer ThrowCurrent 7.260 kghammer-7p260kg
    Javelin ThrowCurrent 500 gjavelin-500g
    Javelin ThrowCurrent 600 gjavelin-600g
    Javelin ThrowCurrent 700 gjavelin-700g
    Javelin ThrowCurrent 800 gjavelin-800g
    Pentathlon Short TrackWA current scoring · Men senior · TR53.1 · H 1.067 m / SP 7.260 kgpentathlon-st-men-senior
    Pentathlon Short TrackWA current scoring · Men U20 · TR53.1 · H 0.991 m / SP 6 kgpentathlon-st-men-u20
    Pentathlon Short TrackWA current scoring · Men U18 · TR53.1 · H 0.914 m / SP 5 kgpentathlon-st-men-u18
    Pentathlon Short TrackWA current scoring · Women senior / U20 · TR53.3 · H 0.838 m / SP 4 kgpentathlon-st-women
    Pentathlon Short TrackWA current scoring · Women U18 · TR53.3 · H 0.762 m / SP 3 kgpentathlon-st-women-u18
    HeptathlonWA current scoring · Women senior / U20 · TR39 · H 0.838 m / SP 4 kg / JT 600 gheptathlon-women
    HeptathlonWA current scoring · Women U18 · TR39 · H 0.762 m / SP 3 kg / JT 500 gheptathlon-women-u18
    Heptathlon Short TrackWA current scoring · Men senior · TR53.2 · H 1.067 m / SP 7.260 kgheptathlon-st-men-senior
    Heptathlon Short TrackWA current scoring · Men U20 · TR53.2 · H 0.991 m / SP 6 kgheptathlon-st-men-u20
    Heptathlon Short TrackWA current scoring · Men U18 · TR53.2 · H 0.914 m / SP 5 kgheptathlon-st-men-u18
    DecathlonWA current scoring · Men senior · TR39 · H 1.067 m / SP 7.260 kg / JT 800 g / DT 2 kgdecathlon-men-senior
    DecathlonWA current scoring · Men U20 · TR39 · H 0.991 m / SP 6 kg / JT 800 g / DT 1.75 kgdecathlon-men-u20
    DecathlonWA current scoring · Men U18 · TR39 · H 0.914 m / SP 5 kg / JT 700 g / DT 1.5 kgdecathlon-men-u18
    DecathlonWA current scoring · Women senior / U20 · TR39 · H 0.838 m / SP 4 kg / JT 600 g / DT 1 kgdecathlon-women

    Timing method (availability depends on event and course)

    EN: timing_basis / JA: 計時方式

    Scroll the table sideways to see every column.

    MeaningEnter this code
    Fully automatic timing (FAT)fully-automatic
    Hand timinghand
    Other timing methodother
    Transponder timing — gun timetransponder-gun
    Transponder timing — net timetransponder-net

    You are ready when: All records are entered one per row, and row 1's headings are unchanged.

  5. Save the file for Import

    In desktop Excel, choose File → Save As and select the file type labeled CSV UTF-8 with a .csv ending. Keep the .csv ending and accept Excel's prompt to keep this format. Save after every correction. Do not upload an .xlsx workbook or simply rename it .csv.

    ExcelSave AsCSV UTF-8 (*.csv)
    Choose CSV UTF-8 in Excel's Save As file type. A generic CSV choice or another spreadsheet app has not been verified here.

    You are ready when: The saved filename ends in .csv. This Excel 16 path was checked against Deltafolio's current Import rules.

  6. Open Account Import

    Create and verify your account if needed, complete your athlete profile, then open Account → Import before adding a Performance by hand.

    Sign upOpen Account Import

    You are ready when: You can see “Import performance data” and a file selector in Account.

  7. Choose the file and Validate

    Select the saved .csv file, then choose Validate CSV. This checks the whole file and does not write records to your account.

    Deltafolio CSV fileValidate CSV
    File selection and Validate are the checking step. Confirm appears only after validation passes.

    You are ready when: You see either a list of problems to fix or a validation-passed summary.

  8. Fix a problem and check again

    If a problem appears, use its row or column, reason, and next action to find the cell in Excel. Correct it, save again as CSV UTF-8, reselect the new file in Account, and Validate again.

    Data row 1English-heading file → performance_dateJapanese-heading file → 日付Why: Not a valid calendar dateNext action: Use YYYY-MM-DD
    Example: an invalid date in data row 1 needs a real date written as YYYY-MM-DD.

    You are ready when: The problem is gone or the next problem is shown. Continue until validation passes.

  9. Review, then Confirm Import

    When validation passes, review the counts shown in Account. Choose Confirm import only when they look right. Confirm checks the file again and writes the whole file or nothing.

    Validate CSV1 PerformancesConfirm import
    Validate checks. Confirm is the separate step that creates the records.

    You are ready when: Account shows that performance data was imported successfully.

  10. Check Timeline

    Open Timeline and find the imported performances. If records already existed, Import cannot add or merge them; changing the file will not make it eligible.

    Open Timeline

    You are ready when: Your imported records appear in Timeline.

If Validate finds a problem

A heading is missing or changed

The problem points to the file headings.

Download a fresh template and keep its first row unchanged. Copy your record cells into the matching columns, save, reselect, and Validate.

A date is not accepted

The problem points to a data row and its date column.

Enter a real calendar date like 2026-09-29 as YYYY-MM-DD, save, reselect, and Validate.

An event, result, or unit is not accepted

The problem points to the row and field to correct.

Compare the cell with the example and the accepted values below. Keep exact values such as 100m and seconds; save, reselect, and Validate.

Records already exist

Account says Import is unavailable.

Import works only before the first Performance is added. Editing or splitting the file cannot add to or merge with existing records.

More detail when you need it

Verified route: desktop Microsoft Excel 16 with all cells set to Text before entry, then Save As → CSV UTF-8. Other spreadsheet exports have not been verified for Deltafolio's required file format.

Important limits

Import is create-only and available only when there are no saved performances. It validates the whole file before an all-or-nothing write. It cannot merge, update, overwrite, deduplicate, or import a second time. There is no arbitrary column mapper. Limits: 4,000,000 bytes, 10,000 Performance rows, 100 Evidence relations and 100 Field Attempts per Performance, 420 columns, and 8,192 decoded UTF-8 bytes per cell.

Columns and accepted values

Either complete header profile works with either UI language. Keep the exact template headers. Cell values use the current canonical Deltafolio codes in both profiles; do not translate them. Leave an optional value blank when it does not apply.

  • Date: YYYY-MM-DD. Time: optional HH:MM in 24-hour time.
  • Result value and unit: use the Discipline's stored numeric result and canonical seconds, meters, or points unit. Result Status is an alternative to a numeric Result. Measured Result value/unit apply only with a compatible primary Result and matching unit.
  • Wind reading: canonical numeric m/s where supported. Round: positive integer. Day Title, Place, Note, and Shoe name are text; Shoe is resolved within your account.
  • Evidence: each counted ordinal is a relation, including a blank external video URL. A nonblank URL must satisfy current external video URL rules.
  • Field Attempts: use contiguous outcomes. Vertical outcomes are clear, miss, pass; horizontal/throw outcomes are valid, foul, pass. Value and wind must match Discipline, outcome, and headline Result rules.
Supported Discipline values

60m100m200m200m Short Track400m400m Short Track800m800m Short Track1500m1500m Short TrackMile3000m3000m Short Track5000m10000m60m Hurdles100m Hurdles110m Hurdles400m Hurdles3000m Steeplechase4x100m Relay4x100m Mixed Relay4x400m Relay4x400m Mixed Relay4x400m Relay Short Track4x400m Mixed Relay Short Track3000m Race Walk Short Track5000m Race Walk Short Track10000m Race Walk20km Race Walk35km Race Walk50km Race WalkHalf Marathon Race WalkMarathon Race WalkHigh JumpPole VaultLong JumpTriple JumpShot PutDiscus ThrowHammer ThrowJavelin ThrowPentathlon Short TrackHeptathlonHeptathlon Short TrackDecathlon

Venue environment codes: outdoor covered

Combined wind assessment codes: within-limit assisted not-required

Result status codes (availability depends on Discipline): DNS DNF DQ NM

Attempt outcome codes: clear, miss, valid, foul, pass

More than 1 Evidence relation or 6 Field Attempts

Add consecutive Evidence columns immediately before the Attempt count column. After slot 1, add these exact headers for slots 2 and 3:

evidence_2_external_video_urlevidence_3_external_video_url

記録資料2外部動画URL記録資料3外部動画URL

Continue without gaps through at most 100 slots. The Evidence count cell is that row's actual relation count; leave higher slots blank. A counted Evidence relation can have a blank URL. evidence_count / 記録資料件数

After the six baseline Attempts, append one complete, consecutive three-column triplet per additional Attempt. For Attempt 7:

attempt_7_outcomeattempt_7_valueattempt_7_wind_reading_mps

試技7結果試技7記録値試技7風速(m/s)

Continue without gaps through at most 100 slots. The Attempt count cell is that row's actual count; leave higher triplets blank. field_attempt_count / 試技件数

Spreadsheet text safety

Export adds a protective apostrophe when Day Title, Place, Note, or Shoe name begins with =, +, -, or @. Import removes that protection in those four fields. A literal leading apostrophe in rare matching text is ambiguous. Check spreadsheet software's own automatic formatting when preparing a CSV.