A Collection of FREE Excel Templates

Here is a collection of free Excel templates. Every template has a brief description with the download link. If you want to learn more about the templates, click on the read more link.

This section is updated frequently with new Excel Templates.

FREE Excel Templates

Below is the category of Excel templates available for download. 

PRODUCTIVITY TEMPLATES

This section has some useful personal productivity Excel templates. 

You can download each Excel template by clicking on the download button. If you want to learn more about the template and how to use it, click on the 'Read more' option.

Excel To Do List Template (Printable)

free  excel templates - to do list

Here is a simple excel template where you can fill the tasks and take a print-out. If you prefer writing the tasks yourselves, simply print it first and then fill in the tasks.

Read more about the Excel To Do List Template (Printable)

Excel To Do List Template (Drop Down List)

free excel templates - to do drop down

Use this Excel Template to jot down all the TO DO list items and then mark it as completed by simply selecting it from the drop-down. The completed tasks get checked off and highlighted in green.

Read more about the Excel To Do List Template (Drop Down List)

Excel To Do List Template (with Check Boxes)

excel templates to do check box

Use this Excel Template to jot down all the TO DO list items and then mark it as completed by checking the box for that item. The completed tasks get checked off and highlighted in green.

Read more about the Excel To Do List Template (with check boxes)

Task Matrix Productivity Template

productivity excel templates - productivity task matrix

This Excel template is inspired by the highly successful technique - Eisenhower Decision Matrix (popularized by Stephen Covey in his book 7 habits of highly effective people).

This is a simple and easy to use Excel Template that will help you prioritize work and increase productivity.

It helps you divide tasks into categories based on Importance and Urgency.

Read more about the Excel Task Matrix Template | Watch Video

Shared Expense Calculator Template

free excel templates - shared expense calculator

This template can be used to calculate 'who owes whom', when the incurred expenses are shared by many people (for example, sharing apartment expenses or vacation/trip expenses).

Simply enter the expense incurred by different people and it automatically gives you the summary.

Read more about the Shared Expense Calculator Template

Calendar Integrated with To Do List Template

free excel templates - calendar to do list

A calendar template that also doubles as your To-do list template. Simply double click on a date and enter the to-do task list (as shown above).

The list is stored for each date and reflected in the calendar. You can also get to see the list of all the task in the month by clicking on 'Show Monthly Tasks List'.

This Excel template is created using Excel functions and VBA.

Read more about this Excel Template

Vacation Itinerary Template

free excel templates - vacation itinerary

Use this Vacation Itinerary Template to have all the details in one place (such as flight/travel details, hotel details, and activities/meetings details).

It's an editable template and you can fill the details in Excel, or can take a printout and fill it.

Read more about this Excel Template

Vacation Packing List Template

free excel templates - packing list

This free Excel template will help you be more efficient while you pack for your next vacation/trip.

You can either use the template in Excel or can take a print out and manually cross off items that you have packed. It’s an editable file so you can add/delete items based on the nature of your trip.

If you are using this template as an Excel workbook, you can simply mark the items as packed by double clicking on the cell to the left of the item name. As soon as you do that, the item gets a check mark on the left and gets shaded in green color.

Read more about this Excel Template

PROJECT MANAGEMENT TEMPLATES

This section has some useful project management templates. These are ready to use templates that you can download and start using.

With most of the Excel templates, you will also find links to the tutorials on how these have been created.

You can download each Excel template by clicking on the download button. If you want to learn more about the template and how to use it, click on the 'Read more' option.

Employee Leave Tracker Template

free excel templates - employee leave tracker

A ready-to-use Excel template to keep a track of employee leaves.

This template has the built-in functionality to select the working and non-working days. It automatically accounts for specified holidays as well.

Highly recommended projected management tool.

Read more about this Excel Leave Tracker Template

Excel Timesheet Calculator Template

free excel templates - timesheet calculator

A timesheet calculator template that will calculate the total number of regular and overtime hours and the total payout based on in time and out time.

Available in 3 formats - weekly, bi-weekly, and monthly.

When printed, it fits perfectly on a single page.

Read more about this Excel Timesheet Template

Milestone Chart Template

free excel templates - milestone chart

Use this milestone chart Excel template to depict project scope and timelines/milestones.

Just specify the milestones along with the date, and it automatically builds out the chart for you. Highly recommended for project management.

Pareto Chart Template

free excel templates - pareto chart

Remember the Law of Vital Few (better known as the 80/20 rule or Pareto Rule).

Here is an Excel template you can use to quickly create a Pareto chart in Excel.

To make it even better, there is a dynamic version of the chart as well.

Excel Gantt Chart Template

free excel templates - gantt chart

Gantt Chart is a simple yet powerful tool to create a schedule or track progress.

Here is a free Excel template that Batman used to get his Batsuit ready 😉

To make it even better, there is a dynamic version of the chart as well.

Read how to create this Gantt chart in Excel

Excel Thermometer Chart Template

free excel templates - thermometer chart

A Thermometer chart is a good way to show target and actual values in a dashboard.

Just specify the target and actual value and it automatically depicts it in the thermometer chart.

OTHER EXCEL TEMPLATES

This section has some additional useful Excel templates that you can use for personal/professional work.

You can download each Excel template by clicking on the download button. If you want to learn more about the template and how to use it, click on the 'Read more' option.

Excel Calendar Template

Yearly Excel Calendar 2017 & 2018 with Notes

This calendar template has two different set of calendars - Monthly calendar and Yearly calendar.

It updates automatically when you update the year (in the yearly calendar template) or Month & Year (in the monthly calendar template). The calendar is built in a way that you can easily take a print and will fit in a single page.

Excel Holiday Template

free excel templates - holiday template

This Excel template will give you all the national US holidays for the selected year.

Even better, it tells you the number of days to next holiday and the long weekend.

Random Group Generator Template

free excel templates - random group generator

This Excel template will help you quickly create random groups of people/items.

You can use it if you're a teacher want want to create random group of students or if you want to create random groups of employees/team-members.​

This template uses some basic Excel formulas and VBA.

Read more about this random group generator template

Excel Stopwatch Template

free excel templates  - stopwatch

Here is an excel template that has a stopwatch in it.

It has the options to start, stop and reset the timings. It also automatically records the timings as soon as you hit the reset key.

It has been customized for a ToastMasters kind of meeting where the speeches are timed and the speaker is shown a green card after 1 minute, a yellow card after 1.5 minutes, and a red card after 2 minutes.

Read more about this stopwatch template

Excel Age Calculator Template

free excel templates - age calculator

Download this Free Age Calculator Template in Excel.

You can specify the Date of Birth and it automatically calculates the total age till date (using the current date). You can also change the current date to any date and it will calculate the time elapsed in the given time interval.

This Excel template can also be used to calculate service tenure or the duration of a project.

Read more about this Age Calculator Template

Military Alphabet Code Generator Template

free excel templates - military alphabet code

'A' as in Alpha, 'B' as in Bravo, 'C' as inCharlie.. Heard this before? These are called the military alphabet codes. It is often used during telephonic conversations to communicate name, address, or email address.

Here is a template that will automatically generate the military alphabet code for you as soon as you enter a word

Useful Excel Tutorials:

  • Rodolfo Valdes R

    I love the employee leave tracker, will you be releasing one for 2016 or how i customize it?

  • Shiva pallan

    IN employee sheet calucator i worked for partime that is
    7.30pm to 12.30am till midnight but it is coming error

    • Hello Shiva.. Since this leads to a change in date, the time sheet calculator gives an error. You can split it into 2 parts (Day 1 – 7:30 pm – 12:00 am) and (Day 2 – 12:00 am to 12:30 am).

      • Hi Sumit, Can I have your phone number please, The convienient time to call you.
        Thanks

      • Jaime Dachelet Ratino

        Hi Sumit! We’ve been trying to use the Employee Leave Tracker and wondered if there is one for 2018 yet? Thanks!

        • Hey Jaime.. For 2018, create a copy of the leave tracker template and change the year in cell A2. This will automatically update the tracker.

  • fghh ghgcgh

    Please make a tutorial or template for students database management.

    • Shipon Foraji

      Hello. I am use excel 2010. My file size 1gb. But some time is not save. And not open. Please help me.

  • CoolAllie

    I love the Gantt chart – is there something that shows the information in both normal calendar view and Gantt chart view so I can swap between the two, i.e. when you add information in one it automatically updates the other?

  • Michelle Brassard

    Good morning Sumit, I have downloaded your To Do list (The one with %) to use at my work to track my work load. I have customize it to fit my requirement. My question is: Am I allow to you it for Business purposes? If so, although I usually ensure to mention who is the original author of this workbook, is there a place where it is mentioned?

  • Gopalakrishna Rao.

    Sir, In Bangalore training is required for one day for 10-12 employees in an Office. Please provide your contact number for enquiry. send mail to gopalakrishnarao1@gmail.com

  • LibertarianUSA42

    I would love to see some of these templates combined, you could have a cheap CRM in no time!

  • Fibo314
  • Mohsin

    hello,i want to pull data form another excel file1 in to excel file2 through dropbox and in excel file1 increase day by day and excel file2 should be updating automatically.

  • Adrian

    Thank you for all! You rock!

  • Adrian

    Thank you for all! You rock!

  • Ravishankar

    Dear Mr.Sumit,
    Can you give me code for converting .xls to .xlsx for a batch of files

  • Selvakumar M

    Hi Sumit, It is an excellent work on the excel. Hats off to your hard work.

    I need to have a datewise consolidattion in the final monthly summary in the final sheet. Let me have a template please. Thanks again

  • WP_MayUno

    Email Generator Excel Template -file cant be found =(

  • Naushad Ansari

    Hi, Sumit Sir. I am Naushad Ansari from Nepal. I am very happy having too much useful templates.
    Sir, I am working as a Principal in a School. Do you have any School Management System templates in Excel? And also for accounting. If you have please, provide me. I’ll be very thankful to you.

  • Shahajalal Rumi

    Many Many Thanks.

  • b kishorekumar

    sir can you suggest me how to select data from long list and place them in a table with the same order i selected

  • Dennis Young

    I love your Task Matrix but I have literally HUNDREDS of activities I want to put into the To Do List but you only offer 50. I’ve been trying to figure out how to expand the number to at least 100. How would I do that?

  • jay

    Sumit,
    I am a small business owner and want to create checklist or process for my staff to follow. i would like to create a template first…then use the template to different events such as employee onboarding etc.
    can this be done via excel sheets? if so can you share an example.

  • Ajitkashid

    Hi Sumit,
    I m trying image look but it given error as reference not valid. can u help me in that.

    Thank ajit

  • Michael

    i would love to see how to make a Check out log we have alot of printers and as we issue out ink we have a list issued out list of employees that have used ink with a date that gives us a count of days so we know how long it has been since they lasted asked for ink do you think there is a way to make a more automatic check out sheet ?

  • Sara

    does anyone have a nine box model template?

  • Ignacio

    Hello! I am responsible for managing a caseload of clients and tasked with assigning each client with our employees for follow-ups. Is there a template or anything which will allow me to do that? For example, if in column 1 I enter the name of a client, can this automatically assign this client to an employee? Furthermore, am I able to create a time constraint that the employee is given to follow-up with the client or complete a task associated to that client? I’m very sorry if this message is confusing 🙁

  • Kk Prabhu

    Hi Can any one help me in creating searchable drop down list in data validation itself , i have one using combo but i am unable to make it in data validation..to use at multiple location

  • Rae Sharp

    I need help! I have looked everywhere for a paid time off calculator and tracker based on hours. Any help is so appreciated.

  • ASHIRVAD LOBO

    Thanks a lot these are fantastic!

  • akhil

    may i get temp for daily cash reporting?

  • Fred

    Can you create a IT loaner equipment type of spreadsheet for Tracking. Like a check in check out sheet that would also generate an email to the user upon check out and reminder to return on due date.

  • Riyaz Khan Pathan

    wow your just awesome Mr.Sumit Bansal. now onwards i follow your all mail each and every tamplat is very very very educative sir i am just FAN of you sir.
    Actually i have small computer education center where poor student come to learn from me specially COMPUTER BASIC & OFFICE. data from you i found very use full.

    thanks once again for enlightening me with your precious knowledge
    thanks soo much sir.

  • GRH Conseil

    This website is absolutely fantastic

  • Harish

    Hi Sumit,
    I am facing a problem in excel .I have a 3 excel sheet & i want to them sort into 4 alternate parameter .How Can i do it i don’t know. I have tried Vlookup,Pivot & Conditional formatting. Can you suggest

    • Hey Harish.. Not really clear on what you want to get done. Would help if you can explain a bit more

  • Pavan Marotkar

    I am automating SAP print activity using VBA macro code.
    When is automate my repetitive active one print dialog box open and I need to press OK.

    Please suggest code for automate OK button

    https://uploads.disquscdn.com/images/c3e7231f3cf62c10d099d0a09b78366baec7abf81fde3e9102eeb5fb23dd32c2.png

  • Imran Bashir

    Dear Sumith need your help to send me the excel file where you cerate helping columns and retrieve the data by selecting from drop down list.
    My email ID Imran.bashir@Infofort.com