Free office tools
23 tools for the small jobs that eat an afternoon. They run in your browser, so nothing you type or paste is uploaded, and most show the spreadsheet formula that does the same thing.
Time and payroll
Hours, shifts and timesheets, with the spreadsheet formula for each.
- Handoff time converterShows one meeting or handoff time in every teammate's time zone, with daylight saving handled.
- Decimal hours converterTurns hours and minutes into decimal hours for payroll, and back again.
- Shift length calculatorHours worked between a start and end time, minus breaks, including shifts that pass midnight.
- Weekly timesheet calculatorTotals a week of start and end times with breaks, and splits regular hours from overtime.
Dates and deadlines
Working days, due dates and gaps between dates.
- Google Sheets workday formula builderBuilds WORKDAY.INTL and NETWORKDAYS.INTL formulas with your own weekend days and holiday list.
- Business days between two datesCounts working days between two dates, skipping weekends and your holiday list.
- Add business days to a dateFinds the date a set number of working days after (or before) a start date.
- Days between datesCalendar days, weeks and whole months between two dates.
Money and costs
Quick sums for meetings, margins and the value of automating a task.
- Meeting cost calculatorWhat a recurring meeting costs in people time, per meeting and per year.
- Automation time savings calculatorHow many hours a year automating a repeated task saves, and how fast the build pays back.
- Percentage change calculatorPercent increase or decrease from an old value to a new one.
- Margin and markup calculatorProfit margin and markup from a cost and a selling price.
Lists and text
Clean, compare and convert pasted lists. Nothing leaves your browser.
- Remove duplicate linesKeeps the first copy of each line in a pasted list and tells you how many repeats it dropped.
- Compare two listsShows what is only in list A, only in list B, and in both.
- Extract email addresses from textPulls every email address out of pasted text, signatures or exports, one per line with no repeats.
- Text case converterChanges pasted text to UPPER, lower, Title or Sentence case.
Spreadsheet formulas and SQL
Builders that write the formula or query for your own columns.
- Completion rate calculatorRolls project counts up into one correct percentage and shows how far an average of percentages would be off.
- Plain-English SQL query builderFill in a sentence and get the query for MySQL, PostgreSQL or DuckDB: filters, totals, newest row per ID and daily counts.
- Latest row per ID SQL builderGenerates a ROW_NUMBER query that keeps the newest row per ID for six databases.
- Google Sheets QUERY builderBuilds a formula that counts rows per group, with the quoting already handled.
- Google Sheets currency formula builderBuilds GOOGLEFINANCE formulas for a currency calculator that follows dropdowns and handles weekend dates.
Data cleanup
Prepare exports and contact lists for import.
Find the email you need in a busy inbox.
Templates
CSV files to start from. Open them in any spreadsheet.