If this page appears for more than 5 seconds,
New to Xcoin?
Sign up today
Forgot your password?
How to Export PP History?
How to Import PP History?
Features & Benefits
Select the Right Solution
Export My PayPal Transaction History
How to Export Buyer Names & Addresses from Paypal to a CSV File
If your buyers use PayPal to pay for their purchases, you can quickly export all names and addresses to a type of spreadsheet known as a CSV file and then use that spreadsheet to import the shipping information into other programs like Stamps.com or Endicia. Here’s how:
How does it work?
Log in to your PayPal Account. Go to
. In the Account Overview, look for the
link towards the bottom of the window. Click on it.
This will take you to your
area, where you can find payment information sorted by date. You can choose dates based on a defined period, like “Past Month” or by specified “To” and “From” parameters. PayPal’s history is very comprehensive, so that you can go back literally for years.
Be aware that the more transactions there are in your history, and the more data you are requesting, the longer it will take PayPal to process your request. If you are a high volume seller, PayPal may notify you that you will receive an email telling you when the information is ready. Do not be alarmed. Even for large amounts of data, the processing time is usually a matter of minutes rather than hours.
In your History area, begin to set up your Search criteria.
criteria to “
Select the appropriate
by clicking on the radio button for either “Within” or “From.” Then enter the period or dates you want to use.
When you are ready, click the Search button.
Your results will appear in a table at the bottom of the screen.
Now look at the top left hand side of your screen. You will see a navigation bar labeled “History.” Look for the link “
Download My History
” and click on it. This will take you to a new page, called
, where you will begin to prepare your data for the CSV export.
When you reach the
page, look for the
Customize Download Fields
link on the right hand side. This is your starting point. Click on the link.
You will now be presented with a large number of options, for both website and auction payments. For the purposes of exporting for address labels, all eBay sales, no matter what their listing format (auction, store, fixed price) should be considered Auction Payments. Web site payments will not include eBay payments.
Since you are using this CSV file to create shipping labels, you will probably want to keep your included fields minimal: include the information you need to identify the item, the buyer, and the ship to address.
Be sure to choose the same column option - either Single Column or Multi-Column Shipping Address - for both your website and PayPal payments. To simplify converting your finished CSV file to address labels, I recommend you choose
Multi Column Shipping Address
Select only the fields
need to identify your buyer, the item, and the shipping address. Click
when you are finished. You can go back and change these options as often as you wish.
After saving your Customized Download Fields, you will be returned to the Download History page.
Here you will see a date range option.
The more often you use the export function, the more likely it is that you’ll opt for
Last Download to Present
. It is not only a time saver, but it ensures that you do not accidentally miss any payments.
However, while you are first setting up this feature, I recommend that you select
Custom Date Range
Under both “Custom Date Range” and “Last Download to Present,” you will see a drop down list called
File Type to Download
. This menu is keyed to the date range. Be sure to select from the “File Type to Download” list that is
the date range option that you wish to use.
From the drop down list, choose
Comma Delimited – Completed Payments
Now click on the Download History button.
Remember, if you have a lot of data, or if you are a high volume seller, this process will take a bit longer. In that case, don’t wait until you are running out the door to print your shipping labels.
PayPal will begin to download the new CSV file to your computer. You will see a dialogue box asking if you wish to open or save the file. Choose Save, and then select a folder on your computer where you want to place these files. Make a note of the location, since you will need to be able to find the file from third party applications like Stamps.com.
Congratulations! You have successfully exported the CSV file to your computer, where it is ready for use.
| CEO Blog | Team Blog |
©2000-2014 Xcoin (USA) Inc. All Rights Reserved.
Designated trademarks and brands are the property of their respective owners.