Welcome!
Welcome to the Marin Software Support Center. We're glad you're here. Here's what you can look forward to:
  • Real-time search so you can find what you need faster than ever.
  • Easy-to-follow video guides for our most popular articles.
  • Interactive simulations and Live Screenshots to make learning easy.
  • Regular content updates to ensure every word you read is accurate and up-to-date.

Reports In Marin

Home > English > Reports In Marin > Creating Reports and Alerts > Troubleshooting Articles: Creating Reports & Alerts > Report Date Format is Not Consistent When Imported to Excel

Report Date Format is Not Consistent When Imported to Excel

What is the issue?

When downloading reports with a long date range and opening it in Excel, you may find that some of the dates are in date format while others are in text format.

What causes the issue?

This problem is most likely caused by an Excel locale setting trying to change the date format.

How to fix the issue

To workaround this problem, follow these steps:
 

  1. Download the report file from the Platform and save it to your computer.
     
  2. Open Excel (A blank sheet will appear).
     
  3. Go to Data, and click From Text.
     
  4. Choose the file and click Import.
     
  5. The Text Import Wizard appears.
     
  6. No need to do anything at Step 1 and 2, just click the Next button.
     
  7. In Step 3, select Text in Column data format.
     
  8. Click Finish, and the spread sheet should open with a consistent date format.

Important notes

  • The date format is dependent on the locale of the Marin account. You can change the Locale setting under client settings. 
     
  1. Click Admin.
     
  2. Navigate to the Clients sub-tab.
     
  3. Check the box next to desired client, then click Edit.
     
  4. Change the locale as necessary. 
     
  • If you notice that the year format is missing for any rows (i.e. showing YY rather than YYYY), there is a solution. Use the text import again, but at step 3, select Date and choose MDY from the drop-down, then click Finish. The date should now be formatted correctly. 

 

Last modified

Tags

Classifications

This page has no classifications.

 

wiki.page("Internal/Mindtouch_Launch_Sandbox/js.cookie.js")