Chapter 9: Coding and File Management

Chapter 9: Coding and File Management — ThinkNavi User Manual

Chapter 9: Coding and File Management

9.1 Coding (Qualitative Analysis)

Coding is a feature for assigning qualitative data analysis codes (labels/classification tags) to collected data.

Purpose of Coding:

  • Assign thematic classifications to collected data
  • Use as categorical variables during model building
  • Identify patterns and trends in data

Steps:

  1. Select the “Coding” tab in the left sidebar
  2. Select the target CSV project and file
  3. Data loads and displays in the table

Creating Codes:

  • Manual creation: Enter code names in the text input field to add
  • AI suggestions: Click “AI Code Suggestion” to have AI suggest codes based on data content

Applying Codes:

  • Select codes from each data row’s dropdown to assign
  • Multiple codes can be assigned simultaneously

Export:

  • “Export Codebook CSV” downloads a code-annotated CSV
  • The code columns in the exported CSV can be used as categorical variables in ConceptMap-Text

9.2 File Management

Features for importing, merging, previewing, and editing CSV files.

CSV Import

Steps:

  1. Select the “File Management” tab in the left sidebar
  2. Click the “CSV Import” button
  3. Select a .csv or .tsv file in the file dialog
  4. The file uploads to the project

Supported Formats:

  • CSV (comma-separated)
  • TSV (tab-separated)

Character Encoding: UTF-8 recommended. Shift-JIS files may have character encoding issues.

CSV Merge

Merge multiple CSV files into one.

Steps:

  1. Check the checkboxes for files to merge (select 2 or more)
  2. A “Merge” button appears
  3. Click “Merge”
  4. Selected files are combined into one new CSV file
  5. “Clear Selection” button to deselect

Note: Merged files should ideally have the same column structure. If columns differ, all columns are included in the merged result, with empty cells where data doesn’t exist.

CSV Preview and Editing

Preview Display:

  1. Click the eye icon in the file list
  2. Data displays in table format in the main area

Edit Mode:

  1. Click “Edit” while in preview
  2. Table cells become editable
  3. Click cells to edit content directly
  4. Delete button removes unwanted rows
  5. “Save” to confirm changes
  6. “Cancel” to discard changes

Download:

  • “Download” button during preview downloads the CSV file locally

CSV File Encoding: CSV files downloaded from ThinkNavi include a UTF-8 BOM (Byte Order Mark), ensuring Japanese characters display correctly when opened directly in Excel.

9.3 Troubleshooting

IssueCause and Solution
Imported CSV shows garbled charactersEnsure the file is saved in UTF-8. Convert Shift-JIS files to UTF-8 before importing
Merge button not displayedCheck at least 2 files
Edits not savedClick the “Save” button. Unsaved edits are lost when reloading the browser
Downloaded CSV shows garbled characters in ExcelWhen opening CSV in Excel, import via “Data” → “From Text” specifying UTF-8. Or open via “File > Open” instead of double-clicking