Row & Page

Row & Page / Guides

GoHighLevel Date Format Fixer

GoHighLevel Import Fix

Want us to fix the file for you? We map your contacts to your exact pipelines, stages and custom fields and return an import-ready CSV plus a field map.

See GoHighLevel Import Fix

Date fields such as Date of Birth or a custom "Start Date" field are a common source of silent import problems: as the ISO 8601 page puts it, 01/05/22 could mean January 5, 2022, or May 1, 2022. ISO 8601 sets out YYYY-MM-DD as an internationally agreed way to write dates (source: https://www.iso.org/iso-8601-date-and-time-format.html). Convert your dates to that format before you import. Nothing leaves your browser.

GoHighLevel date format fixer

Paste dates one per line, or upload a CSV and name the date column. Dates are converted to YYYY-MM-DD. Dates where day and month could be swapped are converted using the order you pick, and anything unreadable is flagged instead of guessed.

Your file is read in your browser with JavaScript. Nothing is uploaded or sent anywhere, and nothing is stored after you close the page.

What the fixer reads

If the first number is above 12, the fixer reads it as the day. Values it cannot turn into a real calendar date are flagged in a new date_check column.

Before you import

  1. We suggest storing dates in a Date custom field rather than a text field.
  2. Check the date format your import screen expects and run a 5 to 10 row test import.
  3. Fix phone numbers too with the phone number format fixer.

FAQ

Why YYYY-MM-DD?

It is the date format set out in the ISO 8601 standard, which ISO describes as an unambiguous, internationally understood format (source: https://www.iso.org/iso-8601-date-and-time-format.html).

Is my file uploaded?

No. The file is read in your browser only.

If you want us to fix the file

Our GoHighLevel Import Fix formats dates, phones and tags and maps every column to your account. The Template Pack is the do-it-yourself option. Also try the tag cleanup tool. We are independent and not affiliated with GoHighLevel or HubSpot.

Buy import fix - $149Buy template pack - $29

GoHighLevel Import Fix

Want us to fix the file for you? We map your contacts to your exact pipelines, stages and custom fields and return an import-ready CSV plus a field map.

See GoHighLevel Import Fix

Free: GoHighLevel import checklist

A 2-page PDF checklist to run before you upload a CSV into GoHighLevel: pipelines, stages, custom fields, tags and a test batch. Enter your email and the download starts right away.

I'll email occasional CRM tips. Unsubscribe any time. Unsubscribe

More CRM guides: GoHighLevel CSV import errors · HubSpot legacy private app migration · GBP categories for dentists · GBP categories for HVAC companies · GBP categories for roofers · Google review reply templates · HubSpot import errors fix · GoHighLevel duplicate contacts · GoHighLevel CSV field mapping checker · GoHighLevel phone number format fixer · HubSpot to GoHighLevel field map generator · HubSpot duplicate contact finder · GoHighLevel custom field name checker · GoHighLevel tag cleanup tool · HubSpot lifecycle stage mapper · HubSpot property name checker · CSV email validator and dedupe · CRM data quality score · GBP description checker · GBP categories for plumbers · GBP categories for chiropractors · GBP categories for law firms · Zoho CRM CSV import checker · Pipedrive CSV import checker · Keap CSV import checker · ActiveCampaign CSV import checker · Mailchimp to GoHighLevel field mapper · CSV name splitter (first and last) · US state abbreviation normalizer · ZIP code leading zero fixer · Company name normalizer (Inc, LLC) · URL and domain cleaner · Duplicate company finder · GBP categories for electricians · GBP categories for landscapers · GBP categories for med spas · GBP categories for auto repair shops · HubSpot multiple companies domain · HubSpot failed to find record · GHL duplicate unique property · HubSpot could not parse date · GHL 1013 phone number · GHL 1008 email validation

Services: CRM contact cleanup · GoHighLevel import fix · HubSpot private app audit · GoHighLevel import templates · HubSpot duplicate audit · Workflow fix · HubSpot to GoHighLevel migration · HubSpot AI connector setup · Zoho Blueprint import fix · 1099 vendor tracker · Google Business Profile audit