Qurio Cell Viewer
User Guide (English Edition)
Qurio Cell Viewer lets you inspect and search CSV, TSV, LOG, and TXT files in a spreadsheet-style interface. It supports large files, search, split view, and LOG/TXT column splitting for efficient data analysis.
1. Getting Started
Qurio Cell Viewer displays CSV, TSV, LOG, and TXT files in a spreadsheet-style grid. The bottom pane lets you inspect long cell values and text containing line breaks, including in large files.
Search, split view, and file splitting/merging help you inspect and investigate data efficiently. Each feature is explained in the relevant chapter.
Viewer is designed for viewing and searching. It does not support editing cell values, adding or deleting rows or columns, or overwriting source files.
2. File
Open CSV, TSV, LOG, or TXT files from the File menu or by dragging and dropping them into the application.
2.1 Open a file
- Choose File → Open (Ctrl+O).
- Select a CSV, TSV, LOG, or TXT file. You can also drag and drop it onto the window.
- The file contents appear in the grid.
2.2 Close a file
- Choose File → Close File (Ctrl+W).
- The current file closes.
Search, navigation, and split-view commands requiring an open file are disabled when no file is open. File splitting and merging work independently of the currently displayed file.
For first-time loading and indexes, see Chapter 12: Large Data Mode and Indexes.
2.3 Display modes
Viewer has two display modes: Normal Mode and Large Data Mode. Normal Mode loads relatively small files into memory; Large Data Mode reads the required portions of larger files as needed.
The mode switches automatically based on the number of rows and the configured threshold. See Chapter 7 for settings and Chapter 12 for mode-specific differences.
2.4 Printing
2.4.1 Open the Print dialog
To print the open file, choose File → Print (Ctrl+P). The Print dialog contains three tabs: Basic, Layout, and Content. Use Preview to check the output before printing.
- Open the CSV, TSV, LOG, or TXT file you want to print.
- Choose File → Print (Ctrl+P).
- Set the print range, paper layout, and content in the three tabs.
- Select Preview to review the output, then Print to proceed.
2.4.2 Basic
| Setting | Description |
|---|---|
| Printer | Select an available printer, including a PDF printer such as Microsoft Print to PDF. |
| Copies | Specify the number of copies. |
| Current Sheet | Print the current sheet. Be mindful of the output size for large files. |
| Selection | Print a selected range when this option is available. The option may be disabled. |
| Visible Range | Print the currently visible range. |
| Specified Row Range | Specify the first and last rows to print. |
| Portrait / Landscape | Choose portrait or landscape orientation. |
2.4.3 Layout
| Setting | Description |
|---|---|
| Paper Size | Choose A4 or A3 as the paper size. |
| Actual Size | Print using the original display scale as the basis. |
| Fit to One Page Wide | Scale the output to fit within one page in width. |
| Custom Scale | Specify a custom print scale. |
| Margins (Top / Bottom / Left / Right) | Set each page margin in millimeters. |
2.4.4 Content
| Setting | Description |
|---|---|
| Table heading — None | Do not add a table heading row. |
| Table heading — Use row 1 as the title row | Use the first row as the table title row. |
| Row Numbers | Include or exclude row numbers. |
| Grid Lines | Include or exclude cell grid lines. |
| Show header / Show footer | Show or hide the page header and footer. |
| Header Content | Choose File Name, Date/Time, or Custom Text. Enter text when Custom Text is selected. |
| Footer Content | Choose Page Number, File Name, Date/Time, or Custom Text. Enter text when Custom Text is selected. |
| Position | Choose Left, Center, or Right for header and footer placement. |
2.4.5 Preview, print, and PDF output
| Button | Action |
|---|---|
| Preview | Review the selected range, layout, and content before printing. |
| Send the output to the selected printer. | |
| Cancel | Close the dialog without printing. |
To save as a PDF, select a PDF printer such as Microsoft Print to PDF and print to that destination. There is no separate PDF export menu.
2.5 Split and merge files
These are independent file operations available from the File menu even when no file is open. They create new output files and do not modify the source.
Split a file
- Choose File → Split File (Alt+Ctrl+S).
- Select the CSV/TSV/LOG/TXT source file.
- Specify the number of rows per output file, and check any format, encoding, and line-ending options.
- Review the output folder and filename preview, then start the operation.
Merge files
- Choose File → Merge Files (Alt+Ctrl+M).
- Add at least two files and check or change their order. Follow the supported-format requirements shown in the dialog.
- Check any header-row, encoding, and line-ending options or warnings.
- Choose the output file and start merging.
CSV/TSV files are split by logical records; LOG/TXT files are split by physical lines. Virtual expansion is checked when the source is selected and again when processing begins. Files with detected virtual expansion cannot be split.
3. Edit (Selection and Copy)
The Edit menu in Viewer contains selection and copy commands that help you inspect data. It does not change cell values.
3.1 Select cells and ranges
| Action | How to |
|---|---|
| Select a cell | Click the cell. |
| Select a continuous range | Drag from the first cell to the last. |
| Extend a selection | Hold Shift and click the end cell. |
| Select a row | Click its row number. |
| Select a column | Click its column header. |
| Select consecutive rows or columns | Hold Shift and click row numbers or column headers. |
| Select multiple rows or columns | Hold Ctrl and click row numbers or column headers. |
3.2 Select all
Choose Edit → Select All (Ctrl+A), or click the upper-left corner of the grid.
3.3 Copy data
- Select the cells or range to copy.
- Choose Edit → Copy (Ctrl+C).
- Paste the copied content into another application if needed.
3.4 JSON and HTML Formatting in the Bottom Pane (Viewer)
You can format the selected cell's text for easier reading in the bottom pane. Formatting changes the display only; it does not modify the cell or source file.
- Select a cell and, if necessary, choose View → Show Bottom Pane (Ctrl+B).
- Right-click inside the bottom pane text area.
- Choose Format JSON or Format HTML.
- To return to the original text display, right-click again and choose Restore Original Display.
| Command | Description |
|---|---|
| Format JSON | Parses valid JSON and displays it with indentation and line breaks. Invalid JSON is not formatted. |
| Format HTML | Introduces line breaks and indentation around tag boundaries. To protect text content, HTML containing pre, textarea, script, style, or code elements is not formatted. |
| Restore Original Display | Returns to the original, unformatted text display. |
This is a viewing aid, not an HTML validator or repair tool. The formatted display is also cleared when you switch cells.
5. Search
Use the search panel to find text and jump to matching cells. Searches can be limited to specific rows and can be stopped or resumed when processing large files.
5.1 Open Search
- Open a file and choose Search → Search (Ctrl+F).
- Choose either Selected Cell or Current Document.
- Enter the search term and any conditions, then start searching.
Selected Cell searches within the currently selected cell. Current Document searches the open file. Select a cell first when using Selected Cell.
5.2 Search options
| Option | Description |
|---|---|
| Match Case | Distinguishes uppercase and lowercase letters, e.g. ABC versus abc. |
| Match Whole Word | Matches a complete word, avoiding partial matches such as cat inside catalog. |
| Regular Expression | Uses a pattern. For example, ERROR[0-9]+ matches ERROR followed by one or more digits. |
Options can be combined. Regular-expression syntax affects which strings match.
5.3 Row range and header row
When Current Document is selected, search the entire file or specify a start and end row. The initial range is from the first to the last row.
If “Use First Row as Header” is enabled, row 1 is excluded from searching. When disabled, row 1 is included. Even if the start row is 1, searching begins at row 2 when the header option is enabled.
5.4 Progress and resuming
During a search, the interface shows scanned rows, matches found, elapsed time, and progress in 0.1% increments. Duration varies with file size and search range.
When a search can be resumed, New Search starts over and Resume Search continues from the previous stopping point.
5.5 Results and pagination
Matches appear in a list. Select a result to jump to its cell. Results are paginated, with up to 100 results per page. Page counts may increase as more matches are found.
When split view is active, check which pane is being navigated; each pane has its own scroll position.
5.6 Highlighting
Matching text is highlighted in the grid and bottom pane. The bottom pane is useful for long or multiline cells. Visible highlights depend on the current selection and viewport.
5.7 Cancel and resume
While searching, click Cancel Search or press Esc to stop. Matches found so far remain available. Use Resume Search to continue with unchanged conditions, or New Search after changing the term, options, or range.
5.8 Clear results
When results exist and no search is running, select Clear Search Results to remove the list. Clearing is unavailable during an active search.
5.9 Navigate Between Search Results
When search results are available, press F3 to move to the next result or Shift+F3 to move to the previous result. You can review matches in sequence without clicking the results list.
6. Navigation
Navigate to a specified row or column, or use keyboard shortcuts to move to the beginning or end of the data.
6.1 Go to Row
| Action | Command |
|---|---|
| Go to Row | Search → Go to Row (Ctrl+G) |
6.2 Go to Column
| Action | Command |
|---|---|
| Go to Column | Search → Go to Column (Ctrl+Shift+G) |
6.3 Keyboard Navigation
| Action | Command |
|---|---|
| Ctrl+Home | Move to the first data row and first column. |
| Ctrl+End | Move to the last row and last column. |
| Ctrl+↑ | Move to the first data row, staying in the current column. |
| Ctrl+↓ | Move to the last row, staying in the current column. |
| Ctrl+← | Move to the first column, staying in the current row. |
| Ctrl+→ | Move to the last column, staying in the current row. |
6.4 Navigation Notes
These Ctrl-key navigation shortcuts do not inspect blank cells or boundaries of contiguous data. When “Use First Row as Header” is enabled, navigation to the first data row goes to row 2.
7. Preferences
Configure display, startup behavior, cell presentation, and large-file handling.
Change preferences
- Open Preferences (Alt+Ctrl+P).
- Choose a category on the left.
- Change the settings and select OK to save.
Default values shown below are for the English edition. Previously saved preferences may override them.
7.1 Display
| Setting | Description | Default |
|---|---|---|
| Display Language | Choose Japanese or English. | English |
| Font | Choose Yu Gothic UI, Meiryo, or MS Gothic. | Yu Gothic UI |
| Font Size | Choose 9, 10, 11, 12, 14, 16, 18, 20, or 24. | 12 |
| Show Thousands Separators in Row/Column Numbers | Display numbers such as 1,000 without changing data. | On |
7.2 Startup
| Setting | Description | Default |
|---|---|---|
| Use First Row as Header | Use row 1 as column headers when loading. | On |
| Show Bottom Pane on Startup | Show the pane for long cell contents. | On |
| Startup Freeze Mode | Choose No Freeze, Freeze Top Row, or Freeze First Column. | Freeze Top Row |
7.3 Cell View
These settings control grid display limits in Normal Mode. They do not apply in Large Data Mode, which prioritizes display performance.
| Setting | Description | Default / Range |
|---|---|---|
| Maximum Visible Cell Lines | Maximum visible lines inside a grid cell. | 6 / 1–20 |
| Maximum Cell Height (px) | Maximum expanded cell height. | 120 / 60–1,000 |
| Maximum Cell Width (px) | Maximum expanded column width. | 520 / 80–2,000 |
7.4 Large Data Mode
| Setting | Description | Default / Range |
|---|---|---|
| Large Data Mode Row Threshold | Row count used to switch display modes. | 50,000 / 10,000–1,000,000 |
| Auxiliary Cache | Shows cache file count and storage usage; allows deletion of all auxiliary caches. | Depends on usage |
7.5 Recent Files
Select entries and remove them from history, or clear the entire history. Removing an entry from history does not delete the actual file.
8. Window (Split View)
Split view lets you compare different positions in the same open file. It does not split the file itself.
8.1 Split commands
| Action | Shortcut |
|---|---|
| Split Horizontally | Alt+Ctrl+H |
| Split Vertically | Alt+Ctrl+V |
| Remove Split | Alt+Ctrl+U |
8.2 Use split view
- Open a file.
- Choose Window → Split Horizontally or Split Vertically.
- Scroll each pane independently to compare distant locations.
- Choose Window → Remove Split to return to a single pane.
Split commands are disabled when no file is open. After removing a split, check the active selection and scroll position.
9. Updating Viewer
In the installed version of Qurio Cell Viewer, choose Help → Check for Updates to check for a newer release. Viewer also checks for updates after startup, but it never downloads or installs an update without your approval.
- Choose Help → Check for Updates.
- If an update is available, review the version and choose Download or Later.
- Download progress is displayed. Once the download finishes, choose Quit and Update to exit Viewer and install the update, or choose Later.
An internet connection is required. Finish any file splitting, merging, or index creation before installing an update, and finish your viewing work before quitting.
10. Menus, Toolbar, and Keyboard Shortcuts
Use this table to find the menu command, toolbar control, and shortcut for each action. A dash indicates that no corresponding toolbar button or shortcut is available.
| Menu | Toolbar | Shortcut | Action |
|---|---|---|---|
| File → Open | 📂 Open | Ctrl+O | Open CSV/TSV/LOG/TXT files |
| File → Close File | — | Ctrl+W | Close the current file |
| File → Print | — | Ctrl+P | Print data |
| File → Split File | — | Alt+Ctrl+S | Split a file |
| File → Merge Files | — | Alt+Ctrl+M | Merge files |
| File → Exit | — | Alt+F4 | Exit Viewer |
| Edit → Copy | ⧉ Copy | Ctrl+C | Copy selected content |
| Edit → Select All | — | Ctrl+A | Select all |
| View → Show Bottom Pane | — | Ctrl+B | Toggle the bottom pane |
| View → Freeze Top Row | — | Ctrl+Shift+R | Freeze the first row |
| View → Freeze First Column | — | Ctrl+Shift+C | Freeze the first column |
| View → Unfreeze | — | Ctrl+Shift+U | Remove freezing |
| View → Auto Fit Columns by Header | — | Ctrl+Shift+H | Fit widths to headers |
| View → Wrap Bottom Pane | — | Ctrl+Shift+W | Toggle bottom-pane wrapping |
| View → Split Log Columns | — | Ctrl+Shift+L | Configure LOG/TXT column splitting |
| View → Remove Log Column Split | — | Alt+Ctrl+L | Remove LOG/TXT column splitting |
| View → Zoom In | — | Ctrl+; | Increase zoom |
| View → Zoom Out | — | Ctrl+- | Decrease zoom |
| View → 100% | — | Ctrl+0 | Reset zoom |
| Search → Find | 🔍 Search | Ctrl+F | Find text |
| (Search results) | — | F3 | Go to the next search result |
| (Search results) | — | Shift+F3 | Go to the previous search result |
| Search → Go to Row | — | Ctrl+G | Navigate to a row |
| Search → Go to Column | — | Ctrl+Shift+G | Navigate to a column |
| Preferences | — | Alt+Ctrl+P | Open preferences |
| Window → Split Horizontally | 🪟 Window | Alt+Ctrl+H | Split into top and bottom panes |
| Window → Split Vertically | 🪟 Window | Alt+Ctrl+V | Split into left and right panes |
| Window → Remove Split | 🪟 Window | Alt+Ctrl+U | Return to a single pane |
| Help → Help | — | F1 | Open this guide |
| (Grid navigation) | — | Ctrl+Home | Move to the first data row and first column. |
| (Grid navigation) | — | Ctrl+End | Move to the last row and last column. |
| (Grid navigation) | — | Ctrl+↑ | Move to the first data row, staying in the current column. |
| (Grid navigation) | — | Ctrl+↓ | Move to the last row, staying in the current column. |
| (Grid navigation) | — | Ctrl+← | Move to the first column, staying in the current row. |
| (Grid navigation) | — | Ctrl+→ | Move to the last column, staying in the current row. |
| Help → Check for Updates | — | — | Check for a new installed Viewer release |
| Bottom pane right-click → Format JSON | — | — | Format JSON for viewing |
| Bottom pane right-click → Format HTML | — | — | Format HTML for viewing |
| Bottom pane right-click → Restore Original Display | — | — | Return to the unformatted text |
The Search and Window toolbar controls are dropdowns. Available actions depend on the file type and current application state.
11. Troubleshooting
If an operation does not work as expected, check the relevant item below. Available features depend on the open file and the current display state.
Search or split view is disabled
Check that a file is open. These commands are unavailable when no file is open.
The first load is slow
An index may be under construction for a large file. Check the progress indicator.
Search results appear incomplete
Check whether the search was stopped. Partial match counts are not final totals.
A shortcut does not work
Try the corresponding menu command and check which window currently has keyboard focus.
Copy is rejected
The selected range may exceed safety limits. Select fewer cells and retry.
File splitting or merging does not progress
Check input format, output destination, free disk space, and whether files are in use. Keeping a separate backup of source data is recommended.
12. Appendix: Large Data Mode and Indexes
This chapter explains large-file display and indexing. For opening and closing files, see Chapter 2.
12.1 Normal Mode versus Large Data Mode
The modes differ in how data is loaded and in certain display features. The default switch threshold is 50,000 rows and can be set between 10,000 and 1,000,000 rows.
| Feature | Normal Mode | Large Data Mode |
|---|---|---|
| Display | Loads data for display | Loads required portions on demand |
| Cell selection and copy | Supported | Supported (large-copy limits apply) |
| Search | Supported | Supported (row ranges, cancellation, resumption, etc.) |
| Split view | Supported | Supported |
| Bottom pane | Supported | Supported |
| Column width adjustment | Supported | Supported |
| Automatic row-height adjustment | Supported | Not supported (fixed height) |
| Cell view preferences | Applied | Not applied |
| Printing | Supported | Supported (range and quantity limits apply) |
When printing, follow the on-screen guidance about ranges and output limits.
Neither mode supports editing cells, inserting or deleting rows or columns, or overwriting the original file.
12.2 Indexes and loading time
Large Data Mode uses an index to retrieve the portions of the file needed for display. Building the index on the first open can take time. Subsequent opens may be faster if the index can be reused.
12.3 Important notes
- Wait for index creation to finish; do not remove source files or related caches while processing.
- Processing time depends on file size, row count, line length, disk speed, and other conditions.
- A 100 GB file is not guaranteed to open or search quickly. Verify performance in your own environment.