How to Export Your Wishlist from Amazon.com12 Mar 2016
Today, I accidentally deleted my wishlist from Amazon.com.
Born on April 23, 2010, my reading list disguised as a wishlist grew to 931 unread books. A few recommendations came from friends and coworkers, but the large majority were a byproduct of late nights spent scouring the corners of the Internet.
Fortunately, Amazon’s customer support team was able to reverse my damage almost immediately.
At this point, I realized I should own this data, not Amazon. Doing so would provide me with a backup of my reading list and the ability to sort, edit and prioritize my list quickly and easily.
I saw three options:
- Export my wish list as a PDF
- (1), then copy and paste the PDF into Excel as text
- Use a Web Query to import my wish list directly from Amazon.com to Excel
I chose (3), for (1) didn’t meet my requirement to sort the list as desired and (2) required more steps (and memory usage) than (3).
Here’s how to do it.
How to import your wish list from Amazon.com to Excel using a Web Query
Open your browser.
- From Amazon.com, navigate to ‘Your Lists’
- Click the printer icon
- Copy the URL from the address bar
Now, we will create a ‘Saved Query’ that Excel will run to pull-in the data. The example sets the minimum number of options for the sake of simplicity and our simple use-case.
- Open a text editor
- Write the query as follows
Here’s an explanation of the query:
Line 1: Query Type. Since this is a web query, we set this to Web.
Line 2: Query version. Since we only have one version, we set this to 1.
Line 3: URL (Uniform Resource Locator). Excel will run your query against this file.
Lines 5 and beyond: Custom Parameters. Configure settings such as what data you would like to select for retrieval, data type, formatting, and so on.
- Save the file as wishlistQuery.txt
- Switch to Excel
- ⌘ + ⇧ + / to open the search prompt for Excel’s Menu Bar
- Type and select ‘Run Saved Query’
- Select and open wishlistQuery.txt
- Choose your desired range