A Collection of FREE Excel Templates

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.

1. Task Matrix Productivity Template

FREE Excel Templates - Trump Excel - Excel To Do ListA simple and easy to use Excel Template that helps prioritize work and increase productivity. It divides tasks into categories based on Importance and Urgency.

Inspired by the highly successful technique – Eisenhower Decision Matrix (popularized by Stephen Covey in his book 7 habits of highly effective people).

Download FREE Excel TemplateRead more | Watch Video

2. Email Generator Excel Template

FREE Excel Templates - Send Email from ExcelAn Excel Template to send an email directly from the spreadsheet.

It uses the hyperlink formula to pick the content from excel and create an email instantly with a single click. 

Download FREE Excel Template | Read more

3. Milestone Chart Template

Free Excel Templates - Milestone chart in Excel Pic

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.

Download FREE Excel Template | Read More | Watch Video

4. Holiday Template (US Only)

FREE Excel Templates - Excel Holiday Calendar Template

An Excel template that gives 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.

Download FREE Excel Template | Read More

5. Excel Formula Crossword

FREE Excel Templates - Excel Crossword formula

Test your EQ (Excel Quotient) with this fun Excel Formula Crossword Template. 

Download FREE Excel Template | Read More

6. Dynamic Pareto Chart

FREE Excel Templates - Pareto Chart in Excel - Dynamic Demo

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.

Download FREE Excel Template | Read More

7. Excel Gantt Chart

Free Excel Templates - Gantt Chart in Excel - Building a BatSuit

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 😉

Download FREE Excel Template | Read More

8. Thermometer Chart in Excel

Free Excel Template - Thermometer Chart in Excel - Final

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.

Download FREE Excel Template | Read More

9. Project Management – Employee Leave Tracker

Free Excel templates - Excel-Leave-Tracker

A ready-to-use Excel template to keep a track of employee leaves. Built-in functionality to select the working and non-working days. It automatically accounts for specified holidays as well.

Highly recommended projected management tool.

Download FREE Excel Template | Read More

10. Shared Expense Calculator

Free Excel Templates - Shared Expense Calculator - Expense Summary

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.

Download FREE Excel Template | Read More

11. Calendar Integrated with a To Do List

Free Excel Template - Calendar cum To Do List Template in Excel - Enter Task

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. The list is stored for each date and reflected in the calendar. A personal time management tool, it is built using Excel functions and VBA.

Download FREE Excel Template | Read More

12. Employee Timesheet Calculator Template

Free Excel Templates Employee-Timesheet-Calculator-Template-in-Excel-Enter-Data

 

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.

Download FREE Excel Template | Read More

13. Vacation Itinerary Template

Free Excel Templates - Vacation Itinerary Template

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.

Download FREE Excel Template | Read More

14. Vacation Packing List Template

Free Excel Templates - Vacation Packing List Double Click

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.

Download FREE Excel Template | Read More

15. Excel To Do List Template (PRINTABLE)

Free Excel Templates - Printable 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.

Download FREE Excel Template | Read More

16. Excel To Do List Template (with Drop Down)

Free Excel Template - To Do List 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.

Download FREE Excel Template | Read More

17. Excel To Do List Template (with Check Boxes)

Free Excel Template - To Do List Check Boxes

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.

Download FREE Excel Template | Read More

18. Military Alphabet Code Generator Template

‘A’ as in Alpha, ‘B’ as in Bravo, ‘C’ as in Charlie.. 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.

Free Excel Template Download - Generate-Military-Alphabet-Code-in-Excel-Demo

Download Free Excel Template | Read More

19. StopWatch in Excel (Template)

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.

Free Excel Template Download - Stopwatch-in-Excel-Demo

Download Free Excel Template | Read More

20. Age Calculator Template in Excel

Free Excel Templates - Age Calculator

Download 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.

Download Age Calculator Excel Template | Read More

21. Random Group Generator Template

If you’re a teacher or a trainer, creating groups of students/participants is a common task. For example, you may want to create groups to conduct a quiz or a team building activity. And in most of the cases, you need these groups to be random.

Here is a Random Group Generator template that will create random groups from a list of names. All you need to do is specify the number of random groups you want to create.

Random Group Generator Template - Demo

Note: This Excel template is currently made to create a maximum of 10 random groups.

Download Random Group Generator Template | Read More

Other Excel Resources:
  • 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

  • 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