This article may be out of date!
Visit the New Knowledge Center

How Do I Correct Inconsistent Dates in a CSV File That I Want to Import to Clio?

Objective:

  • Errors when importing into Clio with mm/dd/yy format
  • Invalid Date error when getting data into Clio Manage

Environment:

  • Microsoft Excel

Additional Information:

Note: While these screencaptures are from a Mac, the steps should be very similar, if not identical in a PC. 

Sometimes, when a CSV file is opened in Excel, the format of dates is not consistent, or in a format that can be easily uploaded into Clio. These steps reformat the dates to a standard MM/DD/YY format. 

Procedure:

  1. Open the CSV in Excel
  2. Right-click the Date column 
  3. Click Format Cells



  4. Under Category click Custom 
  5. Click in the Type field
  6. Enter "mm/dd/yyyy"



  7. Click OK
  8. Save the CSV
  9. Import it to Clio (see here)

 

Was this article helpful?
This information is confusing or wrong
This isn't the information that I was looking for
I don't like this functionality