How to Create an Exercise Log Using Excel

Written by stephanie ellen
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Create an Exercise Log Using Excel
Keep track of your daily physical activity with an Excel exercise log. (Creatas Images/Creatas/Getty Images)

An exercise log allows you to chart your workout progress with over time. Microsoft Excel is ideal for creating an exercise log, because you can create a chart of your progress and dynamically update the data in a spreadsheet. Once you've created the log, you can add exercises and other details at any time.

Skill level:

Other People Are Reading


  1. 1

    Start Microsoft Excel. A blank worksheet will open.

  2. 2

    Type the different exercises you perform in column A. For example, type "Push ups" in cell A2, "Chin ups" in cell A3 and "Crunches" in cell A4. Do not type anything in cell A1.

  3. 3

    Enter the dates for the exercise sessions in row 1. Insert one date per cell. Leave cell A1 blank. For example, type "Feb 1" in cell B1, then type "Feb 2" in cell C1, then type "Feb 3" in cell D1.

  4. 4

    Fill in your data. For example, if you perform 10 push ups on Feb 1, type "10" into cell B2.

  5. 5

    Create a graph of your progress for one exercise. Hold down the Ctrl key and click the "1" and "2" to the left of the rows to select them. Click the "Insert" tab, then click "Line." Click "2D Line" and a chart of your data will be inserted into a spreadsheet. Click "Switch Row/Column" after the graph has appeared.

Tips and warnings

  • The American College of Sports Medicine and The American Heart Association recommend resistance training at least two days per week and intense cardiovascular exercise 30 minutes a day, five days a week.

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.