Caffeine Intake Worksheet

Total caffeine from entered product-label amounts and consumption events, while keeping unknown label values visible.

Files stay on your device No sign-up Free to use
How this works

The tool runs in this browser. Your file or text is not uploaded to UseFreeTools. Check this tool's limits for anything it may save on your device.

Privacy details

Total entered caffeine controls

One tab-separated row per product, exactly three columns. Up to 200 rows and 100,000 characters; a name up to 80 and a serving label up to 60. Leave the mg column empty when the label does not state a value: those entries stay unknown instead of counting as zero. The example rows are samples, replace them with your own.

One tab-separated row per drink, exactly four columns. The date is YYYY-MM-DD, the time is 24-hour HH:MM, the product must match a row above and servings may be a decimal such as 0.5. Up to 200 rows. Nothing is stored or sent anywhere; the totals are calculated in your browser.

Drop your file here

or choose one from your device

Open a JSON project saved by this page. The file names the tool and schema it was written for; values in the file replace the matching fields above and are checked the same way as typed input. Leave this empty to keep the fields as they are.

    Processed in your browser. Your inputs stay on this device.

    Showing a generated example. Generate again for a new result.

    How to use Caffeine Intake Worksheet

    1. Enter supplied product names, caffeine amounts and serving descriptions. Leave an unknown amount empty.
    2. Enter consumption events by calendar date, clock time, matching product name and servings. Review known daily subtotals and unknown events.
    3. Download CSV for rows, JSON to continue editing later, or PDF for a printable copy. Review exports before sharing them.

    Example: Caffeine Intake Worksheet

    Total one sample product serving and two of another.

    You add
    Products: name, caffeine mg per serving, serving label (tabs): Example cold brew 200 300 ml bottle Example green tea 30 250 ml cup Consumption events: date, time, product, servings (tabs): 2026-10-01 08:15 Example cold brew 1 2026-10-01 14:30 Example green tea 2
    You get
    Totaled 2 entries over 1 day: 260 mg known. Sample rows: 2026-10-01 | 2 | 260 | 0 | Every entry has an entered mg value

    Options

    Label amounts
    Milligrams refer to the serving description you supplied. There is no product database or estimate for an unknown product.
    Fractional consumption
    A fraction scales the supplied amount. It does not apply a personal safety threshold or metabolism model.

    Supported inputs and limits

    Up to 200 rows per dataset and 100,000 characters per dataset. Unknown entries are counted separately from known milligram subtotals. Processing runs in the browser without uploading entries or automatic saving. JSON projects are limited to 100,000 bytes/characters. Saved files contain your supplied details. Printable reports use standard Latin fonts; unsupported characters are refused rather than omitted.

    Where your input is processed

    This tool processes your input in this browser. Your text and files are not uploaded to UseFreeTools. Check this tool's limits for anything it may save on your device.

    A known subtotal can omit unknown entries

    Each consumption event scales the supplied milligrams per serving. If a product has no entered caffeine amount, its contribution stays unknown instead of becoming zero. The known daily subtotal therefore does not prove complete intake. No product database, metabolism estimate or personal safety threshold is used.

    Questions about Caffeine Intake Worksheet

    Does the worksheet tell me a safe amount?

    No. It totals entered values without recommending a dose, applying a safety limit or assessing pregnancy or medical circumstances.

    What if a label does not state caffeine?

    Leave its amount empty. Events using that product remain unknown and are counted separately from the known subtotal.

    Can I record half a serving?

    Yes. Enter the fraction consumed and keep the serving description consistent with the supplied milligram value.

    Project manager: Tony Hines · Content updated 4 October 2026 · Report a problem