How to Preserve a Table's Units and Footnotes When Saving an Excerpt

Summary

• When you save a table excerpt, capture its units and footnotes as inseparable context, not optional extras.
• Use a consistent excerpt format that separates original text, paraphrase, and interpretation.
• Record where units apply (table-wide, column-level, row-level, cell-level) and how footnotes map to specific cells.
• Include a verification status field so readers know what you checked versus what you inferred.
• A worked example and reusable template below help you preserve meaning when tables are copied into notes, reports, or evidence logs.

Saving a table excerpt sounds simple until you reuse it later and realize the numbers no longer mean what you thought they meant. The two most common causes are (1) the units were separated from the values (or applied at a different scope than you assumed), and (2) the footnotes that qualify the data were dropped or detached from the cells they modify.

This guide shows a practical, repeatable way to preserve a table’s units and footnotes when you save an excerpt, including a worked example and a reusable record format. It also helps you clearly distinguish original text from paraphrase and interpretation, and to mark what you have (and have not) verified.

Why units and footnotes are part of the data (not “extra”)

In tables, meaning is distributed across multiple elements:

• Values (the numbers or categories in cells)
• Units (what the values measure and in what scale)
• Footnotes (definitions, exceptions, methods, rounding rules, inclusion/exclusion criteria, time windows, and caveats)
• Scope cues (whether a unit or note applies to the whole table, a column, a row, or a single cell)

If you excerpt only the values, you may accidentally change the claim. For example, “12” could mean 12%, 12 people, 12 million dollars, 12 per 100,000, or an index value. A footnote can also reverse the practical meaning (e.g., “preliminary,” “modelled,” “excludes refunds,” “not seasonally adjusted,” “rounded,” “includes estimates”).

Common failure modes when saving table excerpts

• Unit drift: the unit is in the table caption, but you only copied the grid.
• Scope confusion: a unit applies to one column, but you treat it as table-wide.
• Footnote detachment: you copy footnotes but lose which cells they refer to.
• Symbol loss: superscripts (a, b, *, †) are stripped in plain-text copying.
• Rounding/precision loss: you retype values and change decimals or separators.
• Timeframe loss: “FY2023” or “Q2” is in a header you didn’t capture.
• Definition loss: a footnote defines what a category includes, but you paraphrase it away.

The core method: capture a “table excerpt bundle”

When you save an excerpt, treat it as a bundle with four required parts:

• Table identity: what table it is and where it came from (enough to find it again).
• Excerpted cells: the exact values you copied (as original text).
• Unit map: a structured note of where units apply (table/column/row/cell).
• Footnote map: the footnote text plus an explicit mapping to the affected cells.

This is the minimum needed to preserve meaning when the excerpt is separated from the original layout.

Step 1: Identify where the units live

Units can appear in several places. When saving an excerpt, explicitly record the unit location and scope:

• Caption-level: “Table 2. Revenue (USD millions)”
• Header-level: “Revenue (USD m)” as a column header
• Stub/row label: “Rate (per 100,000)” as a row group label
• Cell-level: “12%” or “$12” embedded in the cell

Rule of thumb: if the unit is not inside each cell, assume it can be lost during copying and record it separately in your excerpt bundle.

Step 2: Preserve footnote markers and their targets

Footnotes are only useful if you preserve two things:

• The marker: a, b, *, †, 1, 2, etc.
• The target: which cell(s), row(s), or column(s) the marker modifies

When copying into plain text, superscripts may flatten or disappear. Replace them with bracketed markers like [a], [*], or [1] and record a mapping.

Step 3: Separate original text, paraphrase, and interpretation

To keep your excerpt usable (and defensible) later, store three layers:

• Original text: the table excerpt as copied, including units/markers.
• Paraphrase: a faithful restatement that keeps the same meaning, without adding new claims.
• Interpretation: what you think it implies (comparisons, conclusions, implications). This is where mistakes happen, so label it clearly.

Step 4: Add verification status

Verification status is a simple field that tells future-you (or a reviewer) what you checked. Keep it explicit and limited to what you actually did. For example:

• Verified: you re-opened the source and confirmed units, footnotes, and mapping.
• Partially verified: you confirmed units but not every footnote mapping.
• Unverified: you captured the excerpt but have not checked it against the source after copying/formatting.

You can also add a short “verification notes” line (e.g., “Checked that [b] applies to 2024 only”).

Worked example: saving an excerpt without losing units or footnotes

The example below is fictional and provided only to demonstrate the method (it is not a quote from any real source).

Example table (as seen in a document)

Table A. Service performance (units vary by column)

• [a] Resolution rate excludes cases closed as duplicates.
• [b] Response time measured from ticket creation to first human reply; automated replies excluded.

How to save an excerpt bundle (good practice)

1) Original text (verbatim excerpt)

Original text:
Table A. Service performance (units vary by column)
Columns: Response time (minutes); Resolution rate (%); Cost (USD)
North: Response time 18; Resolution rate 92[a]; Cost 14.20
South: Response time 25[b]; Resolution rate 88; Cost 13.10
Footnotes: [a] Resolution rate excludes cases closed as duplicates. [b] Response time measured from ticket creation to first human reply; automated replies excluded.

2) Unit map (explicit scope)

• Unit map:
  • Response time: minutes (column-level)
  • Resolution rate: percent (column-level)
  • Cost: USD (column-level)

3) Footnote map (explicit targets)

• Footnote map:
  • [a] applies to cell: (North, Resolution rate)
  • [b] applies to cell: (South, Response time)

4) Paraphrase (faithful restatement)

Paraphrase:
In Table A, response time is reported in minutes, resolution rate is reported as a percentage, and cost is reported in USD. North shows a resolution rate of 92% with a note that duplicates are excluded. South shows a response time of 25 minutes with a note that the timing excludes automated replies and starts at ticket creation.

5) Interpretation (your analysis, clearly labeled)

Interpretation:
North’s resolution rate may not be directly comparable to a metric that includes duplicates, because the footnote changes the definition of “resolution rate.” South’s response time metric may appear longer or shorter depending on whether other reports include automated replies.

6) Verification status

Verification status: Unverified
Verification notes: Excerpt captured from a rendered table; confirm footnote markers and unit scopes against the original source before publication.

A reusable record format you can copy into notes

Use the template below as a consistent “table excerpt bundle” record. It is designed to survive copy/paste into plain text, spreadsheets, or evidence logs.

Practical techniques for tricky tables

1) Mixed units in one table

Some tables mix units across columns (e.g., minutes, %, USD). In that case:

• Record a unit map per column.
• In your “Original text,” repeat the unit in the column label line even if it feels redundant.

2) Units implied by abbreviations

If a header says “USD m” or “kg CO2e,” do not expand it in the original text. Expansion belongs in paraphrase (and only if you are confident). If you do expand, mark it as paraphrase and keep the original abbreviation preserved.

3) Footnotes that apply to a whole column or row

Sometimes a footnote marker appears in a column header (e.g., “Revenue[a]”). Your footnote map should then say:

• [a] applies to: (All rows, Revenue column)

4) Footnotes that define categories

If a footnote defines what a category includes (e.g., “Includes contractors”), treat that as a definition that must travel with the excerpt. In paraphrase, you can restate it, but keep the definition intact.

5) Ranges, inequality signs, and special symbols

Preserve symbols like “<”, “>”, “~”, “±”, and ranges exactly in the original text. If your destination system strips them, add a note in verification notes and re-check the source.

6) When you must reformat the table

If you convert a table into sentences or bullets, do it in the paraphrase section, not the original text section. Keep the original excerpt as close to the source as possible, then provide a readable paraphrase for downstream use.

Quality checks before you reuse the excerpt

• Unit check: Can every number be read with a unit without guessing?
• Scope check: Do you know whether the unit applies to the whole table or only a column?
• Footnote check: Does every footnote marker have a mapped target?
• Definition check: Did any footnote redefine a metric or category?
• Timeframe check: Did you preserve the period (year/quarter/date range) if present?
• Verification check: Is the verification status accurate for how you plan to use it?

Frequently Asked Questions

Back to FAQ Table of Contents

Back to FAQ Table of Contents

Back to FAQ Table of Contents

Back to FAQ Table of Contents

Back to FAQ Table of Contents

Back to FAQ Table of Contents

Back to FAQ Table of Contents

Back to FAQ Table of Contents

Related Guides

• What Is an AI Context Pack?
• How to Prepare Better Context for ChatGPT
• How to Organize Copied Text for AI Work
• Source-Labeled Context for AI: Why It Matters
• ChatGPT Context Pack for Consultants