Skip to main content

Excel sheets

The Excel file is created in Step 3 (Excel).

What you will do​

  • Know what sheets exist in the Excel file
  • Understand row limits
  • Know what to check if Excel looks incomplete

Steps​

1) Find the Excel file​

Default file name:

  • KoreaTime_ResearcherView.xlsx

It is saved in the participant output folder. See: Output files and folders

2) Check the sheet list​

The workbook usually includes:

  • Summary
    • A table of CSV files
    • Columns: collectionKey, fileName, records, columns
  • One raw sheet per input CSV
    • Sheet name format: <collectionKey> (raw)

3) Know the row limit​

Raw sheets can have a hard limit. In the current generator, the max is 50,000 rows per raw sheet.

4) Know how collectionKey is built​

The app tries to extract a short key from the CSV file name. If your export file name does not match the expected pattern, the key can look long.

5) Data types​

Raw cell values are written as plain strings. So numbers and dates may not be formatted.

Common mistakes​

  • Expecting more than 50,000 rows in one raw sheet
  • Assuming numbers are typed as numbers (they can be strings)
  • Opening an old Excel file when a newer one exists with a suffix like (2)

Report issues​

Include:

  • The Excel file name and creation time
  • The input CSV file names used for Excel
  • A screenshot of the Summary sheet
  • Your participant output folder (or a safe subset)