Keep TikTok Comment IDs Intact in Excel

Keep TikTok comment IDs as text from the moment they enter Excel. If you use the comment workspace in CommentTok’s TikTok Viewer, choose its native Excel (.xlsx) export to retain the identifier strings supplied to the exporter. If you already have a CSV, import it with explicit text column types. Then compare the imported IDs against untouched source strings before matching replies or removing duplicates.

This guide uses two deliberately invented 19-digit identifiers. They are teaching values, not IDs collected from TikTok, and no live capture is claimed. The reused September 14 screenshot shows the workspace before capture; it does not demonstrate today's export controls. For collection basics, start with the CSV export walkthrough.

Key Takeaways

• Excel numeric precision is limited to 15 significant digits; identifiers belong in text cells.
• CSV quotation marks do not declare a spreadsheet column's data type.
• Native XLSX preserves strings already present in the current exporter; it cannot repair earlier damage.
• Check both the cell type and every character against an independent reference.

Why a readable ID can still be wrong

An identifier labels a record. Adding, averaging, or rounding it has no useful meaning. Microsoft's explanation of Excel numeric precision documents the 15-digit limit. A 19-digit identifier stored as a worksheet number cannot be trusted to retain all its digits.

Scientific notation is a display clue, not a complete diagnosis. A wider column may reveal more characters without restoring the original value. Two different identifiers can lose their distinguishing final digits and appear identical, creating a false duplicate or attaching a reply to the wrong parent.

Changing an already damaged cell to Text only changes how its current value is treated. Return to the untouched source and import again. Do not attempt to reconstruct a missing suffix from row order, neighboring IDs, or the number of replies.

Prefer the native Excel export when available

In the current CommentTok workspace, select Excel (.xlsx) in the export selector and choose Export after comments are available. Export requires a signed-in CommentTok account. If prompted, complete sign-in and retry. Browsing public comments without signing in does not mean downloads are anonymous.

The implementation checked on September 16 writes comment_id, parent_comment_id, and video_id as literal strings. Likes and reply counts are numeric; is_reply is Boolean. The workbook contains a Comments sheet with the same 12 fields as the CSV, including source and capture metadata. This is an implementation check, not a report of a successful production capture.

The protection starts with the values received by the exporter. If an upstream system already rounded an ID, converting it to a string cannot recover its original digits. Missing platform IDs also remain missing: a temporary UI identifier is not exported as a real comment ID. Keep those limitations visible when joining datasets.

Practice with two intentionally adjacent IDs

Download the fictional practice CSV. It contains only three teaching columns, not the full CommentTok export schema. All comments and identifiers below were invented for this exercise; they are not links to real records.

The IDs differ only in their last digit and are numerically adjacent. That makes the fixture useful: preserving just their shared prefix is not enough. The parent field in the second record must still match the first record exactly. The empty parent field in the first row represents no parent in this example, not the number zero.

Save an untouched copy of the download. Open that copy in a plain-text editor to inspect the original characters; do not save it through Excel before using it as the reference. CSV contains values and separators, but no persistent Excel cell types. Quoted digit strings can still be inferred as numbers.

Import the CSV before Excel guesses its types

Use a desktop Excel version with the Text/CSV Power Query importer. Menu placement varies by version and platform. Microsoft's guide to keeping large numbers describes importing through the Data tab and selecting Text for the relevant columns.

1. Open a blank workbook. Choose Data → From Text/CSV and select the practice file.
2. Choose Transform Data so you can inspect column types before loading.
3. In Applied Steps, inspect any automatic Changed Type step. Remove a step that converts identifier columns to numbers before assigning their text types; adding Text after a numeric conversion is too late.
4. Set comment_id and parent_comment_id to Text. Keep comment as Text too. Confirm the final digits in the preview.
5. Choose Close & Load, placing the table at A1 in a blank sheet for the checks below. Save the workbook as .xlsx.

For a real export, also set video_id to Text. Leave count columns numeric when you need arithmetic. If your Excel edition does not expose this import path, use the native XLSX download rather than guessing at an equivalent menu. Avoid double-clicking the CSV for your controlled import.

Verify types, exact values, and the reply link

For the three-column practice file loaded at A1, headers occupy row 1 and the records occupy rows 2 and 3. Enter these formulas in spare cells outside the imported table. These are expected results, not screenshots of an executed Excel session.

Keep the quotation marks around reference IDs in formulas. An unquoted 19-digit literal would itself enter Excel's numeric handling. Microsoft documents EXACT as a text comparison that returns TRUE for identical strings and ignores formatting. Pair it with ISTEXT: a text cell alone does not prove that earlier processing preserved the value.

Some regional Excel settings use semicolons instead of commas between formula arguments. In a full CommentTok export, the three ID fields occupy columns E, F, and G, so adapt references rather than pasting the practice formulas unchanged. A length check of 19 is useful for this fixture but is not proof of accuracy or a universal rule for every source ID.

Keep identifiers intact through the handoff

Repeat the checks after saving and reopening the workbook. Preserve an unedited source file beside your working copy, and ask recipients to keep identifier columns as text. Saving an intact workbook back to CSV removes its cell-type information; the next recipient must perform a controlled import again.

For real datasets, compare IDs against independently preserved source strings before deduplicating or joining replies. A parent-match check alone can pass when both sides were damaged in the same way. Record missing identifiers separately and do not replace them with guessed values.

Once identifiers pass validation, continue with manual comment categories and analysis, or open the CommentTok workspace to prepare an export. An exact ID establishes record identity; it does not establish that a capture includes every comment or represents every viewer.

Explore profiles, videos and comments

To choose a source before collecting comments, use the TikTok account viewer to review a public profile and its available videos, or the TikTok video viewer to inspect a specific video’s details. Return to the comment viewer to review the discussion. Browse all TikTok Viewer guides for related workflows.