Help! My DMU Template does not open in the proper format!

Modified on Tue, 3 Mar at 1:09 AM

Sometimes we encounter issues in excel where the correct template format is not kept. This can be an issue based on your regional settings.

Correct template format should reflect in columns with one piece of information per column, as in the screenshot below:

mceclip2.png

An example of incorrect format below, where one column contains all of the data points:

incorrect_format_dmu.jpg

 

Here's a simple way to fix this issue in Excel:

  1. Open Excel
  2. Go to the 'Data' tab
  3. Select 'From Text' (third option from left) and select the .CSV file you want to import.
  4. Click 'Next' on the pop-up window. Make sure you select 'Comma' in the
    next window.
  5. You should now see your data applied into columns below
    already. You can add any other information if you need to here.
  6. Click 'Finish' when you're done with editing.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article