Monthly Archives: May 2017

Easiest Way to Sell Bitcoin to PayPal

guide-on-how-to-sell-bitcoin-to-paypalSell Bitcoin to PayPal? How is this possible?

This is the complete guide to selling your Bitcoin to PayPal with 15% markup and converting your Bitcoins to USD or local currency in your PayPal account.

There are other guides showing how to sell Bitcoins to PayPal, but none of them discuss how to sell at a 15% markup to the current market price of Bitcoin.

This is a great method of cashing out from:

  • Coinbase to PayPal
  • Gdax to PayPal
  • Poloniex to PayPal
  • Kraken to PayPal
  • Offline cold storage wallet to Paypal
  • Bitcoin to bank account – via PayPal

Guide Summary

  1. Go to xCoins
  2. Open an account
  3. Link your xCoins account to PayPal wallet and select your settings for buyers.
  4. Transfer your Bitcoin to your xCoins wallet
  5. Wait for your Bitcoin to be sold – 100% automated by the xCoins, and completely secure
  6. Receive USD or local currency from the Bitcoin sale into your PayPal account

You can then use the funds in your PayPal account as usual, for online purchases or cash out to your bank account.

Steps 1-3 take perhaps 15-20 minutes to complete. Steps 4 -6 are completely automated.

 1. Go to xCoins

xCoins describes itself as a secured P2P Bitcoin lending service. It’s more accurate to describe it as a place to sell Bitcoin at a markup (from the sellers’ point of view)

2. Open an account

Click “sign up” on the top right hand corner:


Fill out your name, email, agree to terms of use and confirm that you’re not a robot:


Copy and paste the email confirmation code, sent to your inbox:


Enter “3fscfw” into the promotional code box (optional):


Enter a password:


Select your country (and state, if necessary):


Enter a phone number.  This is used to confirm withdrawals for security reasons. It’s a very important feature to protect your Bitcoin balance:


3. Link your xCoins account to PayPal wallet and select your settings for buyers.

Select “Lend Bitcoin” in the main menu. Click the green plus icon:


Enter your email address that you use with your PayPal account:


You may need to verify this in your email inbox.

4. Transfer your Bitcoin to your xCoins wallet

Move your mouse cursor over “My Wallet” in the menu, and click “Deposit Bitcoin”. Copy the wallet address (long string of text):


Go to your Bitcoin wallet – you may have Bitcoin at an exchange such as Coinbase, Kraken, Poloniex or an offline wallet on a computer or USB drive. Send a small amount of Bitcoin first to the address you just copied from above, to test that everything works correctly! When the first transaction shows up in the xCoins wallet, feel free to deposit as much as you like.

Note: due to the delays currently being experienced on the Bitcoin blockchain, the deposit will likely take at least 30-40 minutes to appear in your xCoins wallet. This is nothing to do with xCoins, it affects all users of the Bitcoin blockchain. Don’t worry, it will arrive eventually.

Next, you need adjust the settings which affect what kinds of buyers can actually purchase your Bitcoin. Below is a screenshot with my settings, feel free to adjust according to your own risk appetite. Be aware that Rating refers to the number of times a buyer has used xCoins – so 1 = 1 first time buyer (higher potential for PayPal disputes or chargebacks), 2 = second time buyer (much lower risk), and so on.


Steps 5 and 6 – waiting for your Bitcoin to be sold and receiving USD or local currency from the Bitcoin sale into your PayPal account are completely automated.

That’s it! You can also use xCoins to continuously earn passive income with Bitcoin.

How to Export Passwords from Lastpass to KeeWeb or KeePass

I recently became interested in switching away from Lastpass , a password manager that is very convenient, but has some drawbacks for me, for several reasons.

My Requirements

I wanted a password manager that would allow me to:

  • use iOS as well as my desktop PC
  • Utilise an open source project
  • Control where the file containing the list of passwords was stored.

With KeeWeb, you can store locally or in cloud storage like Dropbox or google Drive.

The Challenge

Unfortunately, getting your account names, usernames and passwords out of Lastpass and into KeeWeb is a somewhat complicated process. This guide helps you through this process, step by step.

The Solution

The process involves: exporting the data from Lastpass, cleansing the data in Excel, importing the clean data into KeePass (a free windows password utility), saving the data in a format that KeeWeb recognises, and finally importing the data into KeeWeb.

Step by Step: Cleaning the exported Lastpass data and importing to KeeWeb

According to this help file [], your information must be in this format:

“Account”,”Login Name”,”Password”,”Web Site”,”Comments”

  1. Go into lastpass vault, select export, enter password. Ctrl-A, Ctrl-C and save as lastpass.txt.
  2. Open Excel. Data tab, From text, select the new text file you just created. Separate by commas, you should see the data split neatly into columns.
  3. Next step is to clean the data. Rename Sheet1 excel tab to “Original Export” and rename Sheet2 to “Clean Export”. We will use Sheet2 to create clean data that KeePass (the utility we use as an intermediate step) will recognise.
  4. Hide all columns except the “url” column
  5. In the cell next to the “url” cell, type in “Valid HTML?” (in my case, cell number H1) and enter this forumla in the cell below it: =(IF(LEFT(A2,4)=”http”,”Y”,”N”)) Drag this formula down the list of URLs, until you come to a point in the spreadsheet where none of the cells in the URL column start with “http” (this is the export of your Lastpass secure notes). With the list of cells still selected, go to the white box on the top left (to the left of the formula bar) where it states the current cell/range, double click it, and type “validTest”. This will quickly allow us to reference this range. This forumla will detect the cells where the value starts of doesn’t start with “http”. This allows us to quickly find the cells where the exported data is in a format that KeePass won’t recognise.
  6. In the cell next to “Valid Html?” type “Non valid count:” (Cell I1 in my case) and in the cell next to that, type “=COUNTIF(validTest,”N”)”. this quickly counts the number of non-valid urls from our overall list.
  7. With the list of cells still highlighted, go to Home tab> Conditional Formatting > Highlight Cell Rules > Equal To > type in “N” (with quotes) and for formatting select “Light Red Fill with Dark Red Text”. This highlights all the broken links in red for us.
  8. On the numbered left column, click row 1, to highlight all the cells. Select Data tab > Filter.
  9. In the column headed by “Valid HTML”, click the dropdown arrow and select only the “Y” checkbox, click OK.
  10. Unhide all the columns
  11. In the “Cleaned Export” sheet, name cells A1-E1 “Account”,”Login Name”,”Password”,”Web Site”,”Comments” respectively.
  12. The order of the columns is different in Lastpass to what KeePass expects. This is the order in Lastpass exported file: url, username, password, extra, name. In case it’s not clear Account=name, Login Name=username, Password=password, Web Site =url, comments=extra. Copy all the (filtered and valid) data from the original sheet to the cleaned sheet. Make sure that you don’t change the order of the rows. Make sure to sort the data into the correct column!
  13. Now Ctrl-A and Ctrl-C all the clean data in the sheet. Open notepad, paste in the text. File> Save As> “lastpass_clean1.csv”. In the file type, select all files.

To be continued…