transaction history csv date format

Raphael240
Level 1
San Diego, CA

transaction history csv date format

Hello

it's about transaction history

Getting the transactions in a csv file format seems quite easy. But when I upload the file to Excel, the dates are a mixed format - some US and some UK. Some dates are also not 'date' format - but text that looks like a date. This is really frustrating when trying to organise my transaction data for tax purposes. I need all dates in the same formate .

 

Please help

**

2 Replies 2
JoseLuis74
Level 2
Puerto Vallarta, Mexico

Hey,

 

When you convert the .Csvf fiel from Text to Colum, there is an option "Delimited --> Next -->Date"

 

Under the "Colum Date Format" part of the small window, you need to select your computer date format and then excel will convert it to the correct format. The Csv file comes out in an american format.

 

Hope this explanation helps??

 

If you maybe need more help with your Csv file, you can also check the following link:

 

** 

 

I basically did an excel template which automates the CSV data you get...

 

Stay healthy!

 

 

**[Advertisement removed in line with - Community Center Guidelines]

Paul-and-Dawn0
Level 2
Northern Ireland, United Kingdom

I came here for the exact same issue. 
Please Airbnb make your date formats standardised so that its simple to sort and change date format. 
Ive been working on this for an hour and not getting anywhere, it should be easy but excel wont format...