Convert the dates of a CSV export to YYYY-MM-DD
Exports write dates as DD/MM/YYYY, as MM/DD/YYYY, with dots, with two-digit years or with the month as a word. Year-month-day is the form that sorts correctly as plain text and that leaves no doubt about which part is the day. Choose the file below: the page works in your browser, 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 the dates are read
- All-numeric dates with slashes, hyphens or dots are read, with a four-digit or a two-digit year. A two-digit year below 70 is placed in the 2000s, any other in the 1900s.
- Day-first or month-first is taken from the file, never guessed. A date such as 03/04/2024 is valid both ways. The cleaner settles the order only when some date in the file has a part from 13 to 31. When none has, the page stops and asks you. When the file holds proof of both orders, it asks too, and rows that do not fit your choice are listed as not parsed.
- Month names are read in English, short or long, with the day before or after the month. Month names in other languages are not recognised.
- Year-first dates written with slashes or dots, or as eight digits with no separator, are rewritten with hyphens.
- A time after the date is dropped. Nothing is converted between time zones.
- Impossible dates are not repaired. A 31st day in a 30-day month leaves the row out of the output and puts it under "Lines not parsed" with the reason. Years outside 1900 to 2100 are treated the same way.
Only the transaction date column is converted. The output is always the same eight columns, and columns of your file that are not among them are not carried over, so this is a cleaner for files of transactions and not a general CSV editor.
By hand: import the column with the date order of the file stated in the import dialog, then give it the custom number format yyyy-mm-dd before saving as CSV.
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.