6 Replies Latest reply on Sep 18, 2018 1:23 PM by Shinichiro Murakami

    Monthly Excel Data Loading as One Month

    Paul Weber

      Hello.

       

      I'm a new Tableau user and I'm trying to load monthly budget data from an Excel spreadsheet.  The data is formatted as such:

       

      1/1/18     5,000

      2/1/18     5,000

      3/1/18     5,000

      etc.

       

      Tableau is putting everything into January 2018, so that I have one column of 60,000, rather than 12 monthly columns of 5,000 each.

       

      I live in the U.S., but I work for a UK company.  I believe our Tableau server default is UK date format, so it's reading the Excel data as Day/Month/Year.

       

      I tried changing the Excel date format to UK, and changing my Workbook locale to U.S., but those didn't work.

       

      I imagine this is a fairly common issue.  Any suggestions as to how to fix?

       

      Thanks in advance.

       

      Paul