Skip to content
FileMyLove

Excel links become labels in CSV: keep the URL in its own column

Prepare explicit URL values before converting Excel to CSV when cells show friendly link labels instead of their destination addresses.

By FileMyLove Team1 min read

Your workbook contains a clickable “Open report” label, but the CSV contains only those words. The displayed label and the link destination are different information. Put the destination in a dedicated text column when the recipient needs it.

What travels into this CSV

Microsoft's link instructions distinguish the address from the text shown in the cell. FileMyLove's Excel-to-CSV path reads stored cell text; it does not extract hyperlink relationships into additional columns.

A label that looks meaningful in Excel may therefore be insufficient for a delivery table. Repeating the conversion with the same workbook does not add a missing address.

Prepare a destination column

Source cell Suggested preparation
Friendly label such as “Open report” Keep the label and add a separate verified URL value
Full URL already stored as text Check that the exported value matches it
Link to a place inside the workbook Decide what destination makes sense outside that workbook
Link to a local file Confirm the recipient can access the intended location

These are preparation steps, not automatic features. The converter does not test recipients' access rights or locate a replacement for a workbook-only destination.

Inspect the actual download

  1. Preserve the original workbook and prepare a delivery copy.
  2. Name separate columns for the label and destination.
  3. Copy the verified address into the destination column as a value.
  4. Use Excel to CSV.
  5. Open the downloaded text and compare several complete addresses with the source.

If the receiving application makes an address clickable, still compare its actual destination. Clickable styling alone does not prove that a label's original target survived.

Check values and structure separately

For cells calculated by formulas, review saved Excel formula results rather than assuming formulas will run during export. For visually grouped records, read merged cells and blank values. A usable delivery table needs both explicit destinations and records that retain their intended meaning.