Import from CSV - date column invalid

  • 2
  • Problem
  • Updated 5 months ago
Keep getting the error "date column doesn't look like valid dates." Only options are Day,Month or Month,Day - I've changed the format to use hyphens and slashes and neither have worked. It's a comma separated file so Day,Month shouldn't be allowed. The formats I've tried are MM/dd; dd/MM; dd-MM; MM-dd. None have worked.
Photo of Melisa Reyes-Stewart

Melisa Reyes-Stewart

  • 1 Post
  • 0 Reply Likes

Posted 5 years ago

  • 2
Photo of Steven Tafzil

Steven Tafzil, Employee

  • 1494 Posts
  • 82 Reply Likes
Hi Melisa,

Could you send a copy of the .csv file to support@goodbudget.com so we can take a look?
Photo of Catherine Morales

Catherine Morales

  • 2 Posts
  • 0 Reply Likes
Im having the same issue. Does it take awhile to download-there was no response.
Photo of Catherine Morales

Catherine Morales

  • 2 Posts
  • 0 Reply Likes
IM having the same problem.
Photo of Steven Tafzil

Steven Tafzil, Employee

  • 1494 Posts
  • 82 Reply Likes
Hi Catherine, 

Send a copy of your .csv file to support@goodbudget.com and we'll take a look. 
You can read more about csv importing here: https://goodbudget.com/2012/02/faq-how-can-i-import-my-banking-activity-with-csv/

If QFX or OFX files are available from your bank, I would strongly suggest you use those instead. 
Photo of Frances Patrick Lancaster

Frances Patrick Lancaster

  • 1 Post
  • 0 Reply Likes
I had the same problem and tried over and over again to figure out what format the date needed to be in.  The way I finally got it to import successfully was to just use the sample file they provide.  I exported my data from Quicken (with only Date, Description, Amount fields), opened it in Excel.  I downloaded their sample CSV file, opened it in Excel.  Then I copied and pasted the Date, Description, Amount value from my Quicken data into the sample CSV, putting it right below the sample data.  Then saved the file and imported it into GoodBudget.  You can just ignore their sample data when matching into your account.
Photo of Karisa Russell

Karisa Russell, Official Rep

  • 1691 Posts
  • 217 Reply Likes
Hi Frances, 

I'm glad that worked for you. All bank's format their CSV files differently. The sample CSV file that we provide is a standard format that Goodbudget can read easily. Making your file match the sample is a good strategy. 

For anyone else who needs to take a look at the sample CSV, you'll find it in the link that Steven provided above. 
Photo of tanglynlyn

tanglynlyn

  • 1 Post
  • 0 Reply Likes
I had the same issue. Reformatted my CSV file using the "date" format in excel and still could not read it. 
Photo of Alex Park

Alex Park, Official Rep

  • 243 Posts
  • 48 Reply Likes
Hi tanglynlyn,

Sorry to hear about the troubles importing your file! Would you send us an email at support@goodbudget.com with your CSV file so we can take a look at it and try to offer some more specific help?