Excel file:

The date fields for Timeline data sets are: start, latestStart, earliestEnd, and end. Processing options for these fields:

Save Excel date-time values in:

If an Excel string value is found instead of an expected date-time value, should this software try to parse the value as a date?

Conditions of use

  • This software is open source and the conversion service is free.
  • Use of this software is at your own risk.
  • We offer NO warranty that your data will remain private. We use a low-cost shared server and do not have control of its security.
  • The service may not be abused or used in an improper way. All use of the service is tracked, including your IP address.
  • We have no interest in your data and this service does not save your data file, except as a temporary file used to process your data. Do not upload any private data whose security you are concerned about. Instead, you can run this software on your own computer, source is available.

Notes

  • The file must be saved in Excel 2000 format or prior versions. If you have Excel 2003, store your data in Excel 2000 format.
  • Excel Epoch issues: If you're dealing with dates between 1 Jan 1900 and 1 Mar 1900 and use a Mac then you need to change a setting in Mac Excel. The issue is that Excel files created on a Mac use a method for tracking dates that affects dates during the Jan 1 - Mar 1, 1900 time period. For the dates to be understood correctly, you must set the Mac Excel software to not use the "1904 date system." To do this:
    1. Start Excel on the Mac
    2. Select Excel / Preferences... menu item
    3. Select "Calculation" on the left side of the pop-up
    4. Uncheck the box "1904 date system" in the Workbook options section of the window.
    5. Verify the JSON file from this service to ensure that your dates are being interpreted correctly.
    More information about how Excel deals with dates is available here.