News & Tips

Receive our occasional newsletter and Knowledgebase articles.
Robert Axford
/ Categories: Content Management

Fix faulty dates in CSV data exports

This can matter when importing data from a CSV into a website.

This issue presents itself as follows:

When viewing exported data from a Webbit such as a form, the store, or even user data, in Excel, some dates will be right-aligned and others will be left-aligned. Some are detected as dates in Excel, whilst the others are only seen as text.

The issue arises with data exported in US format (which is typical), and opened in Excel within NZ or Australia. Excel confuses the day value with the month and when the value is higher than 12, it no longer sees the data as a date.

This video demonstrates how to open the file in such a way that the data is correctly detected and displayed as dates in the local format. View the video full-screen for best results. 

Image

 

1700
Previous Article Xero Integration
Next Article Filename rules for images and documents

Contact Us

We'd love to hear from you. Please complete the form on this page or use the contact details below.

Loading