Ninjastic
Home
Search
Users
Boards
Addresses
Ctrl + K
Toggle theme
Open menu
Post
Edited versions
Quotes to this post
Post
18836912
Topic
1545898
Board
Services
Re: excel-sheet for the tradehistory.csv export from poloniex
by
guesswho1234
on
02/05/2017, 12:20:44 UTC
Quote from: kroongh on May 02, 2017, 11:26:38 AM
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
hope this helps
greetings