Search the WonderWebs Knowledgebase below or contact us for additional help.

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. 

Updated on 5 July 2024

All the Support You'll Ever Need

Flawless Support

Knowledgeable service and support is our most popular and appreciated asset.


Online articles for many typical issues. Search above or visit the knowledgebase here.

Optional Support

Regular website and Google SEO assessments are available to be scheduled.

How to Get Help

We don’t force you into a phone queue or make you use a complicated ticketing system. Just call or use the contact form below and we’ll be there to help with any website, email, domain, Google, or related issues.  Some quick answers are also in the FAQ below.

Quick Answers

A few answers to basic common questions are provided here. Search the Knowledgebase at the top of the page for detailed articles.

The free basic email provided with your WonderWebs website is a simple POP account. It won’t set itself up automatically like a Google, Apple or Microsoft account. The Email Guide has all necessary details or give us a ring from another phone, and we can take you through it.

Marketing. There’s no getting around the fact that you need to market your business. A website alone does not create business out of thin air. Review our carefully considered SEO guide for our website-related tips and advice. We can also handle your Google Ads to be as efficient and cost effective as possible.

SEO services are like Nigerian Princes.  We do SEO here at WonderWebs and we do it honestly. Beware of SEO scammers.

Email or give us a ring. This is what we do and we do it well.

Let's Sort Out Your Website!

Send us a message here or contact us via the details at the bottom of the page.

Scroll to Top