Hi,
When I generate the CSV from Nicehash, I only select mining as transaction type and change the dates to the range that I require. This helps as trades should be done manually to ensure correct and withdrawals can are better done editing the API of the wallet deposit.
Once the report is generated I do the following:
Go to bottom and delete the summary
Insert new column as B
select column A and in the data tab on the ribbon select text to columns
Select Fixed Width and only have one break line just after the seconds so the " GMT" is on right
Click Finish
Delete Column B
Select New Column B, Cut, Select Column E, Paste, Delete Empty Column B
Select B1 and cut whatever Token is there out so only “Amount” remains
Whatever Token was cut from B1 paste in C2 without the brackets
Copy C2, hold shift and press the down arrow, Paste.
Select C1 and type “Currency”
Select D1 and type “Description”
Select A1 and type “Koinly Date”
Close Excel, choose save, choose yes.
Now you can import. Just be sure that all the mining fees come up as Cost because if they dont that will show as withdrawals and you will need to filter as withdrawal with no label go the last page, mouse over the Red up arrow and select checkbox, click the double tick at the bottom to select all on that page and mark as cost. Once all on that page are done, select the page before the last and repeat until all are done.
I have not found a way to mass do it for all that does not involve a separate csv import where you mark all as Cost.
