Convert month-name dates in a CSV to YYYY-MM-DD
Dates written with a month name, such as March 3, 2024 or 02 Apr 2024, do not sort as text and are refused by importers that expect year-month-day. Choose the file below: the page works in your browser, rewrites those dates as YYYY-MM-DD, shows the first 20 cleaned rows and lists every line it left out, with the reason.
Clean your CSV export
The cleaner detects the delimiter (comma, semicolon or tab), looks for a header row with a date column and an amount column, and writes eight fixed columns, comma-delimited: date, description, amount, currency, fee, net, reference and source. It recognises common header names in English, Spanish, German and French, such as Date, Fecha, Buchungstag, Amount, Importe, Betrag and Montant.
Your file is read in your browser and is never uploaded, stored or logged. It is held in the memory of this tab only, and closing or reloading the page discards it. Operator: Augeo. See the privacy notice.
Exports do not share one layout, and this page makes no promise about yours: the free preview shows what it does to your file.
The cleaning logic is checked by an automated test script that runs the engine file of this site over six synthetic sample files and a set of checks of the parsing rules; it ran in a sandbox before this site was published and finished with no failed check. The script does not open this page in a browser, does not test the licence key step, and nothing was tested against a real export from any provider. Use the free preview to check your own file.
Report
Warnings
Lines not parsed
Lines dropped
Preview of the cleaned rows
| line | date | description | amount | currency | fee | net | reference | source |
|---|
Download the full cleaned file
- Price: 6 USD, paid once on Gumroad. No subscription. You receive a licence key.
- What the key unlocks: the download of every cleaned row of the file you chose, as one CSV named after your file with -cleaned.csv at the end, instead of the first 20 rows on screen. The report and the way files are read stay the same.
- The key is for one buyer. Runs are not counted and no number of runs is promised. The key is kept in the memory of this page only, so you enter it again after closing or reloading the page.
- Refunds are requested through your Gumroad receipt and follow Gumroad's refund policy.
- Try the free preview first. If the preview cannot read your file, the full download cannot either.
Get a licence key on Gumroad for 6 USD
How month-name dates are read
| In the export | date in the cleaned file |
|---|---|
| March 3, 2024 | 2024-03-03 |
| 02 Apr 2024 | 2024-04-02 |
| 15-Jan-99 | 1999-01-15 |
| 02/14/24 (month first) | 2024-02-14 |
| 31 Apr 2024 | row left out: date not recognised |
- Month first. A month name, the day and a four-digit year:
March 3, 2024,Mar 3 2024orMar. 3rd, 2024. - Day first. The day, a month name and the year, with spaces, hyphens, slashes or points between them:
3 March 2024,02-Apr-2024or2/Apr/24. - Names are English. Full names and three-letter abbreviations are recognised, plus Sept, in capitals or lower case. Month names in other languages, such as
5 mars 2024, are not recognised. - Two-digit years. 00 to 69 are read as 2000 to 2069 and 70 to 99 as 1970 to 1999, so
15-Jan-99becomes1999-01-15. In the month-first form the year must have four digits. - No question about day and month. A month name settles the order. All-numeric dates such as
02/14/24still need it: the cleaner takes it from a date with a day above 12, and asks you when the file has none. - A time after the date is dropped.
March 3, 2024 10:15becomes2024-03-03. - Impossible dates are not moved to the next month.
31 Apr 2024is not a date, and neither is a year before 1900 or after 2100. - A date that is not recognised is never guessed. The row is left out and listed with its line number and the text found: under "Lines not parsed", or under "Lines dropped" as a footer line when it comes after the last readable row.
Dates that are already year-month-day, such as 2024-03-05, 2024/3/5 or 20240305, are written as 2024-03-05.
The output is always the same eight columns (date, description, amount, currency, fee, net, reference and source), so this is a cleaner for files of transactions and not a general date converter. In a comma-delimited file, a date such as March 3, 2024 has to be inside double quotes in the input to stay one field.
Notices
- Privacy: files are read in your browser and never uploaded, stored or logged. Operator: Augeo.
- Independent tool, not affiliated with or endorsed by Etsy, PayPal, QuickBooks or any bank.
- Check the output before you use it. This is not accounting, tax or financial advice.
- Price of the full download: 6 USD one-time. The key is for one buyer. Refunds are requested through the Gumroad receipt.
- Only upload data you have the right to process. Choosing a file here does not send it anywhere, but you remain responsible for the data in it.
Other pages
- Fix date and decimal format in a bank CSV
- Convert a semicolon CSV to a comma CSV
- Negative amounts in parentheses in a CSV
- Fix DD/MM and MM/DD dates in a CSV
- Convert a tab-delimited file to a comma CSV
- Remove total and footer lines from a bank CSV
- Line breaks inside quoted fields of a CSV
- Gross, Fee and Net columns of a PayPal CSV
- Remove the lines above the header of a CSV
- Convert CSV dates to YYYY-MM-DD
- Remove duplicate rows from a CSV export
- Merge debit and credit columns into one amount
- Any other CSV export of transactions