Caffeine Intake Worksheet

Total caffeine from entered products and events using editable amount and time fields.

On-device No sign-up Free to use

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 an example. Change the fields, then use total entered caffeine to update it.

    Result

    Showing an example.

    Total one sample 200 mg bottle and two sample 30 mg cups: 200 + 2 × 30 = 260 mg. These are entered examples, not typical caffeine values for all drinks of those types.

    Totaled 2 entries over 1 day: 260 mg known.

    Loading the tool. Your result will appear here.

    https://usefreetools.net/caffeine-intake-worksheet · 20 November 2026

    Was this helpful?

    How to use Caffeine Intake Worksheet

    1. Replace the sample Products with the names, milligrams per serving and serving labels you have. Use one product name per row; names are matched without case.
    2. Leave Caffeine mg per serving empty when the amount is unknown. Enter 0 only when you intend a known zero; an empty cell is never counted as zero.
    3. Under Consumption events, enter the calendar date, 24-hour time, matching product name and number of those servings consumed. For half a labeled serving, enter 0.5.
    4. Select Total entered caffeine. Review the daily known milligram subtotal and unknown-entry count together. Missing amounts make the known total partial.
    5. Download caffeine-intake-worksheet.csv for event-level data or its PDF for daily and event tables. Save the JSON project to restore both editable lists later.

    Example: Caffeine Intake Worksheet

    Total one sample 200 mg bottle and two sample 30 mg cups: 200 + 2 × 30 = 260 mg. These are entered examples, not typical caffeine values for all drinks of those types.

    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.

    Options

    Editable fields
    Products: Product name, Caffeine mg per serving (optional), Serving label (optional). Consumption events: Date, Time, Product, Servings. Add or remove these records with the labeled controls; each new row starts blank.
    Advanced raw input
    Products use three tab-separated cells: name, milligrams per serving and optional serving label. Events use four: date, time, product and servings. Keep empty cells when a value is unknown or a label is omitted.
    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

    • Use up to 200 product rows and 200 event rows, with 100,000 characters allowed in each dataset.
    • Product names allow 80 characters and serving labels 60.
    • A supplied amount ranges from 0 to 5,000 mg per serving; consumed servings from 0.01 to 1,000.
    • These are accepted input ranges, not recommended intakes.
    • Event amounts and known subtotals are rounded to three decimal places.
    More details

    Times order entries within their written calendar dates; there is no time-zone conversion, elimination/half-life estimate or bedtime prediction.

    Unknown amounts remain separate from known zero values.

    No product database, intake limit or personal safety assessment is applied.

    Entries stay in this browser without automatic saving or upload.

    Save the JSON project to continue later; imports are limited to 100,000 bytes and characters.

    Saved files contain the entered details, and PDF text uses the supported standard-font character set.

    Where your input is processed

    This tool does not upload your inputs. See the limits for anything saved 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.

    Page updated · Project managed by Tony Hines · Report a problem with Caffeine Intake Worksheet