Post
Topic
Board Services
Re: excel-sheet for the tradehistory.csv export from poloniex
by
guesswho1234
on 02/05/2017, 12:20:44 UTC
Well, Excel on my computer IS properly set up, I just installed it to test this file. So that's not the problem. The problem is the decimal, which Excel does not change automatically when importing the export.

there are two solutions for that
#1
set the decimal seperator to "." and from there on can just open the *.csv-file without having to do anything but copy & paste after that

#2

complete import:
https://support.office.com/en-us/article/Text-Import-Wizard-c5b02af6-fda1-4440-899f-f78bafe41857
copy & paste + convert:
https://support.office.com/en-us/article/Split-text-into-different-columns-with-the-Convert-Text-to-Columns-Wizard-30b14928-5550-41f5-97ca-7a3e9c363ed7

didnt think importing the data could be such a huge problem Cheesy hope this helps


greetings