How to Create a Calendar in Microsoft Excel

PDF download Download Article
Simple ways to make monthly and yearly interactive calendars in Microsoft Excel
PDF download Download Article

While not known as a calendar program, you can use Excel to create and manage your calendar. There are a variety of calendar templates available that you can customize to your liking, which will be a lot quicker than trying to format a calendar yourself. You can also take a list of calendar events from a spreadsheet and import them into your Outlook calendar.

Things You Should Know

  • Excel comes with several interactive calendar templates you can use to create weekly, monthly, and yearly calendars.
  • Once you select a calendar template, you can fill in your own events and customize the overall look and feel.
  • You can also use Excel to create schedules and calendars that are easy to import into Outlook.
Method 1
Method 1 of 2:

Use a Calendar Template

PDF download Download Article
  1. When you click the "File" tab or Office button and select "New," you'll be shown a variety of different templates to pick from.
    • For certain versions of Excel, such as Excel 2011 for Mac, you'll need to select "New from Template" from the File menu instead of "New."
    • Creating a calendar from a template will allow you to create a blank calendar that you can fill in with events. It will not convert any of your data into calendar format. If you want to convert a list of Excel data into an Outlook calendar, see the next section.
  2. Depending on the version of Office you are using, there may be a "Calendars" section, or you can just type "calendar" into the search field. Some versions of Excel will have a few calendar templates highlighted on the main page. If these meet your needs, you can use them, or you can search for all the different calendar templates available online. [1]
    • You can get more specific with your search depending on your needs. For example, if you want an academic calendar, you can search "academic calendar" instead.
    Advertisement
  3. Once the template loads, you'll see your new blank calendar. The date will likely be incorrect, but you can usually change this using the menu that appears when you select the date.
    • The process will be a little different depending on the template you are using. Usually you can select the displayed year or month and then click the ▼ button that appears next to it. This will display the options you can pick from, and the calendar will adjust automatically.
    • You can usually set the day the week starts as well by selecting it and choosing a new one.
  4. Many templates will have a text box with tips that can inform you on how to change the dates or adjust other settings for the calendar template. You'll need to delete these tip text boxes if you don't want them to appear on your printed calendar.
  5. You can adjust the look of any of the elements by selecting one and then making changes in the Home tab. You can change the font, color, size, and more just like you would any object in Excel.
  6. After your calendar is configured correctly, you can begin entering events and information into it. Select the cell you want to add an event to and start typing. If you need to put more than one thing on a single day, you may have to get creative with your spacing.
    7. Advertisement
Method 2
Method 2 of 2:

Import Excel Data into Outlook

PDF download Download Article
  1. You can import data from Excel into your Outlook calendar. This can make importing things like work schedules much easier.
  2. It will be a lot easier to import your list into Outlook if your spreadsheet is formatted with the proper headers. Enter the following headers into the first row:
    • Subject
    • Start Date
    • Start Time
    • End Date
    • End Time
    • Description
    • Location
  3. The "Subject" field is the name of the event as it appears on your calendar. You don't need to enter something for every field, but you will need at least a "Start Date" as well as the "Subject."
    • Make sure to enter the date into the standard MM/DD/YY or DD/MM/YY format so that it can be read properly by Outlook.
    • You can make an event that spans multiple days by using the "Start Date" and "End Date" fields.
  4. Once you're finished adding events to your list, you can save a copy of it in a format that can be read by Outlook.
  5. This is a common format that can be imported into a variety of different programs, including Outlook.
  6. Give the list a name and save it in CSV format. Click "Yes" when asked by Excel if you want to continue.
  7. Outlook comes with Office, and you'll generally have it installed if you have Excel installed. When Outlook is open, click the "Calendar" button in the lower-left corner to view your calendar.
  8. You'll see several options for handling Outlook data.
  9. This will open a new window for importing and exporting data into and out of Outlook.
  10. You'll be prompted to select the file you want to load from.
  11. You should usually be able to find it in your Documents folder if you didn't change the default location in Excel.
  12. It should be selected since you're in the Calendar view in Outlook.
  13. Your list will be processed and the events will be added to your Outlook calendar. You can find your events in the correct spaces, with times set according to your list. If you included descriptions, you'll see these after selecting an event.
    14. Advertisement

Community Q&A

Search
Add New Question
  • Question
    What holiday is it on the 21st march 2028?
    Community Answer
    As far as I have found out, the only holiday in March in 2028 is Memorial Day, BUT it's on the 29th.
    Thanks! We're glad this was helpful.
    Thank you for your feedback.
    If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
    Yes No
    Not Helpful 33 Helpful 3
Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
      Advertisement

      Tips

      Submit a Tip
      All tip submissions are carefully reviewed before being published
      Name
      Please provide your name and last initial
      Submit
      Thanks for submitting a tip for review!

      You Might Also Like

      How to
      Set a Date and Time in Microsoft Excel
      How to
      Make a Spreadsheet in Excel
      How to
      Create a Timeline in Excel: SmartArt, Templates, and More
      How to
      Merge Cells in Microsoft Excel: A Quick Guide
      How to
      Unhide All Rows and Columns in Microsoft Excel
      How to
      Unprotect an Excel Sheet
      How to
      Use If‐Else in Microsoft Excel: Step-by-Step Tutorial
      How to
      Password Protect a Microsoft Excel Spreadsheet
      The Best Ways to Make & Format Lists in Excel
      How to
      Show Hidden Columns in Microsoft Excel & Unhide Column A
      How to
      Link Sheets in Excel
      How to
      Create a Mortgage Calculator With Microsoft Excel
      How to
      Insert Pictures in Excel That Automatically Size to Fit Cells
      How to
      Create a Chart in Microsoft Excel: Step-by-Step Guide
      Advertisement

      References

      1. ↑ https://support.office.com/en-us/article/Excel-calendar-templates-f2e7ffe9-41fa-4ce5-8278-cf92d3b66340?ui=en-US&rs=en-US&ad=US&fromAR=1

      About This Article

      Article Summary X

      1. Open Excel.
      2. Search for a calendar template.
      3. Select a template.
      4. Set the correct dates.
      5. Adjust visuals as needed.
      6. Enter your events.

      Did this summary help you?
      In other languages
      Thanks to all authors for creating a page that has been read 1,092,706 times.

      Is this article up to date?

      Advertisement