Skip to main content
Import dates and times

A simple guideline for importing dates and times correctly from Excel

Martin Moen avatar
Written by Martin Moen
Updated over 6 years ago

When importing dates and times from Excel we recommend formatting cells as Text. Follow this step by step guide:
โ€‹
First, select the cells that contain date and time data. Right click and select Format Cells...


In the Numbers tab, select Text from the Category list. Then click OK and you are ready to import.

Did this answer your question?