Skip to content
FileMyLove

Excel comments missing from CSV: move essential notes into columns

Separate Excel comments from cell values, prepare a reviewed notes column and check that a CSV delivery includes the explanations recipients need.

By FileMyLove Team2 min read

A price has an explanation attached to its Excel cell, but the CSV recipient sees only the price. An attached note is not an ordinary table column. Make essential delivery information explicit before converting.

Identify where the explanation lives

Microsoft distinguishes threaded comments for discussions from notes for annotations. FileMyLove's CSV path builds rows from cell text; it does not collect attached comments, replies or notes into extra fields.

A column named “Notes” containing ordinary values is different. Its text travels as table data. The column name alone does not make it an Excel note object.

Prepare a reviewed delivery table

Source information Suggested preparation
Reason a value is provisional Add a clear status or explanation column
Internal discussion Decide what the recipient actually needs
Decision recorded only in a reply Put the approved conclusion into a cell
Author and review date needed Add explicit fields after checking them

These are preparation steps, not automatic comment extraction. Preserve the original workbook with its discussion history. A copied conclusion should not imply that every reviewer approved it unless you have checked that separately.

Test before sending

  1. Keep the original and create a delivery copy.
  2. Review comments and notes for information needed to interpret the values.
  3. Copy only approved delivery explanations into labelled columns.
  4. Use Excel to CSV.
  5. Open the actual CSV and compare several rows with their source explanations.

Check identifiers so each note remains attached to the right record. If the download contains several CSV files, inspect every file you plan to send.

Do not use conversion as a privacy audit

The absence of attached comments does not prove that the whole CSV is safe to share. Private information can remain in normal cells, including hidden rows. Read hidden rows in CSV before handing off a filtered-looking sheet.

If explanations contain links, also check link labels versus actual URLs. The final acceptance question is whether a recipient can understand each record from the delivered fields, without needing a conversation that exists only in the original workbook.