<p>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. </p>

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

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

CC BY-SA 3.0
2015-06-22T14:43:57.723Z
2015-06-22T14:43:57.723Z
jdb6167
<p>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.<br>
Thanks in advance if anyone can help out at all!</p>

<p>ie</p>

<p>from</p>

<pre><code>1D1ZrZNe3JUo7ZycKEYQQiQAWd9y54F4XZ     0.01
1353tsE8YMTA4EuV7dgUXGjNFf9KpVvKHz     0.5
</code></pre>

<p>to this</p>

<pre><code>sendmany "" "{\"1D1ZrZNe3JUo7ZycKEYQQiQAWd9y54F4XZ\":0.01,\"1353tsE8YMTA4EuV7dgUXGjNFf9KpVvKHz\":0.5}"
</code></pre>

<transactions>
Auto formatting data into sendmany command
Len
# Auto formatting data into sendmany command

(Asked by: username_0 on 2015-06-01)

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!

ie

from

```
1D1ZrZNe3JUo7ZycKEYQQiQAWd9y54F4XZ     0.01
1353tsE8YMTA4EuV7dgUXGjNFf9KpVvKHz     0.5

```

to this

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

```

**Tags:** transactions


---

## 1 answers

### Answer by username_1 on 2015-06-22. Score: 1

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.


---

