Apologies for the newb question. But what's the best way to convert data on spreadsheet (lists of addresses and corresponding amounts to be sent), into a format suitable to be entered as a sendmany command into bitcoin console with the minimum amount of steps? Ideally would handle any amount of addresses and amounts.
Thanks in advance if anyone can help out at all!



1D1ZrZNe3JUo7ZycKEYQQiQAWd9y54F4XZ     0.01
1353tsE8YMTA4EuV7dgUXGjNFf9KpVvKHz     0.5

to this

sendmany "" "{\"1D1ZrZNe3JUo7ZycKEYQQiQAWd9y54F4XZ\":0.01,\"1353tsE8YMTA4EuV7dgUXGjNFf9KpVvKHz\":0.5}"

You can export the spreadsheet as a CSV file, then parse it using your favorite programming language into a dictionary. Convert the dictionary to JSON, and that will give you the second argument to the sendmany command.

I'd do this in Python using the built-in csv and json packages.

I'm not aware of any solutions that will do this if you don't know how to program, though.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.