Map Extract
Free tool

Turn a timesheet CSV into an invoice

Open the CSV export from your time tracker, or paste it. Hours in decimal, 7:30 or 7h 30m form are understood, rows are grouped into invoice lines by project, client or day at each rate, and one click opens an invoice already filled with those lines.

Runs in your browser. Nothing you enter is uploaded.

Example: a week of work for one client

A freelance PPC consultant exports four rows from her time tracker for Brightwell Dental. Two rows of Google Ads setup are logged as 2:30 and 1h 45m at £55 an hour, a monthly report row has 1.5 hours and no rate, and a cancelled call shows 0 hours.

With a default rate of £45, VAT at 20% and lines grouped by project, the tool uses three rows and skips the zero-hour one. Google Ads setup becomes one line of 4.25 hours at £55, which is £233.75, with the dates and the notes from both rows in its description. The report becomes 1.5 hours at £45, £67.50. Net total: £301.25 for 5.75 hours.

Input
Date,Client,Project,Hours,Rate,Notes
02/11/2026,Brightwell Dental,Google Ads setup,2:30,55,Account structure
03/11/2026,Brightwell Dental,Google Ads setup,1h 45m,55,Ad copy
04/11/2026,Brightwell Dental,Monthly report,1.5,,October figures
05/11/2026,Brightwell Dental,Google Ads setup,0,55,Call cancelled
Result
Rows used 3, rows skipped 1, hours 5.75
Brightwell Dental, Google Ads setup, 4.25 h at £55.00 = £233.75
Brightwell Dental, Monthly report, 1.5 h at £45.00 = £67.50
Net total £301.25

From export to invoice

  1. Load the timesheet

    Choose Open a timesheet CSV or paste it into the box. The first row must be the header.

  2. Check the columns were found

    Columns are matched by name: Date, Hours (or Duration or Time), Rate, Project (or Job or Task), Client (or Customer) and Notes. If no hours column is found, a message says so.

  3. Set a fallback rate and VAT

    The fallback rate is used for any row without its own rate. Choose 20% VAT, or 0% if you are not registered.

  4. Choose how lines are grouped

    One invoice line per project and rate, per client and rate, or per day and rate.

  5. Make the invoice

    Press Make the invoice and the full invoice form opens below, with the lines and the first client's name filled in, ready for your details, numbering and printing.

Hour formats the tool understands

Written asRead as
7.5 or 7,57.5 hours
7:307.5 hours
7h 30m7.5 hours
45m0.75 hours
0, blank or textRow skipped

Grouping choices and what the customer sees

Grouping by project keeps invoices short for clients who only want a figure per piece of work. Grouping by day suits clients who sign off time daily. Rows at different rates never merge, so a senior rate and a junior rate on the same project stay as separate lines.

Each line's description carries the client, the project or day, the date range covered, the number of entries and up to three of the notes, so the client can see where the hours went without a separate timesheet. Dates in day-first UK form such as 02/11/2026 are read as 2 November.

Questions people ask

Which time tracking apps does this work with?

Any that export CSV with a header row and an hours or duration column. The tool finds columns by their names rather than by position, so exports with extra columns or a different column order still work. If yours uses an unusual name for hours, rename that header to Hours.

What happens to rows without a rate?

They use the fallback rate you set above the results. That is useful when your time tracker only records hours, or when most work is at one standard rate and only a few rows carry a special one. Rows with their own rate keep it.

Can I invoice several clients from one timesheet?

The grouping keeps each client's rows separate, so lines for different clients never merge. The invoice form is filled with all the lines and the first client's name, so for several clients either filter the CSV first or remove the other clients' lines before you print.

Is the timesheet uploaded?

No. The CSV is read and grouped by the page in your browser. The invoice that opens works the same way, and if you save it, it is kept in this browser's storage on your device rather than on a server.

Where your data goes

Your timesheet file is read locally and never uploaded. The invoice built from it stays in the page unless you save it, in which case it is held in this browser's storage only.

Checked against the tool on

Top