2015 Spreadsheet of all the Black Friday deals

All Site Suggestions or General Black Friday Tips

Moderators: Tony, cematra173, killasnake, Huy

User avatar
Shopper X
Suspected Line Jumper
Posts: 2637
Joined: Wed Nov 16, 2005 6:05 pm

2015 Spreadsheet of all the Black Friday deals

Postby Shopper X » Sat Oct 31, 2015 12:20 am

A spreadsheet containing all the 2015 Black Friday deals on BFAds.net is available to download:

November 26, 2015, 5.7 MB, 160 ads, 33813 items

November 25, 2015, 5.6 MB, 157 ads, 33371 items
November 24, 2015, 5.4 MB, 149 ads, 31894 items
November 23, 2015, 5.3 MB, 143 ads, 31607 items
November 22, 2015, 5.1 MB, 133 ads, 30704 items
November 21, 2015, 4.9 MB, 129 ads, 29178 items
November 19, 2015, 4.7 MB, 120 ads, 28473 items
November 18, 2015, 4.3 MB, 111 ads, 26165 items
November 17, 2015, 4.2 MB, 101 ads, 25364 items
November 16, 2015, 3.9 MB, 87 ads, 23210 items
November 15, 2015, 3.7 MB, 83 ads, 22491 items
November 14, 2015, 3.7 MB, 83 ads, 22500 items
November 13, 2015, 3.7 MB, 82 ads, 22034 items
November 12, 2015, 3.2 MB, 66 ads, 19208 items
November 11, 2015, 2.9 MB, 58 ads, 17745 items
November 10, 2015, 2.3 MB, 48 ads, 13761 items
November 9, 2015, 1.9 MB, 39 ads, 11251 items
November 6, 2015, 1.3 MB, 27 ads, 7591 items
November 5, 2015, 1.0 MB, 22 ads, 5964 items
November 4, 2015, 0.8 MB, 15 ads, 4773 items
November 3, 2015, 0.7 MB, 13 ads, 4326 items
November 2, 2015, 0.6 MB, 11 ads, 3772 items
October 31, 2015, 0.4 MB, 9 ads, 2328 items

The spreadsheet is a plain text file in CSV format that can be imported into Excel or other spreadsheet programs. The information is pulled from the web site, so any errors on BFAds.net will also show up in the spreadsheet. Please let me know if you have any questions or suggestions or if there are any problems. The spreadsheet columns are: "Store,Category,Item,Early Bird,Rebate,Price,URL". For research purposes, the 2014, 2013, 2012, and 2011 spreadsheets are also still available.

(I'll keep updating this top post as updated versions of the spreadsheet are available.)
Last edited by Shopper X on Thu Nov 26, 2015 11:27 am, edited 21 times in total.

User avatar
kenziekinz09
Black Friday Pro
Posts: 2462
Joined: Thu Nov 01, 2007 5:56 am
Location: Disney World!

Re: 2015 Spreadsheet of all the Black Friday deals

Postby kenziekinz09 » Sat Oct 31, 2015 10:34 pm

Thanks for always putting these together!
Tek for weird uncle! TEAM SISTER WIVES 8)
My Disney Blog- http://www.kenziewdwcp.blogspot.com/

User avatar
guitarist19862005
Black Friday Pro
Posts: 2130
Joined: Tue Oct 02, 2007 2:44 pm

Re: 2015 Spreadsheet of all the Black Friday deals

Postby guitarist19862005 » Mon Nov 02, 2015 9:18 am

Thanks for this undertaking this huge task. I'm sure I'll check back quite often throughout the next few weeks.

DemetriaBeth
Black Friday Newbie
Posts: 1
Joined: Wed Nov 04, 2015 7:37 pm

Re: 2015 Spreadsheet of all the Black Friday deals

Postby DemetriaBeth » Thu Nov 05, 2015 8:35 am

I hate to sound stupid....but how do i get this into Excel in the correct excel format?

User avatar
Shopper X
Suspected Line Jumper
Posts: 2637
Joined: Wed Nov 16, 2005 6:05 pm

Re: 2015 Spreadsheet of all the Black Friday deals

Postby Shopper X » Thu Nov 05, 2015 9:45 am

You just need to:
1. Download and save a local copy of the file on your computer, and then
2. Open the file in Excel, like you would with any other file.
3. Excel should either automatically display the spreadsheet or bring up the Text Import Wizard to help you.

Please try this and let me know if you have any problems.

Here are two Microsoft support articles that describe the opening process:
https://support.office.com/en-ZA/articl ... e_by_openi
https://support.office.com/en-ZA/articl ... e_by_openi

racerwill18
Black Friday Newbie
Posts: 2
Joined: Fri Nov 13, 2015 11:59 am

Re: 2015 Spreadsheet of all the Black Friday deals

Postby racerwill18 » Fri Nov 13, 2015 12:29 pm

Shopper X, Thanks so much, i actually created an account to say thanks. every year i bust my butt trying to make my sheets and always wanted a site dump. this is brilliant. i would like to know how you are aggregating all the info though?

User avatar
Shopper X
Suspected Line Jumper
Posts: 2637
Joined: Wed Nov 16, 2005 6:05 pm

Re: 2015 Spreadsheet of all the Black Friday deals

Postby Shopper X » Fri Nov 13, 2015 9:44 pm

I have a computer program that visits every ad listing web page on BFAds.net, for every store. It grabs the information from all the web pages and converts it into a list. Fetching all the web pages takes a while. Today's list had 773 web pages and took 80 minutes to compile.

User avatar
bfaddict
Black Friday Pro
Posts: 4808
Joined: Thu Nov 16, 2006 4:19 pm
Contact:

Re: 2015 Spreadsheet of all the Black Friday deals

Postby bfaddict » Mon Nov 16, 2015 2:42 pm

Thank you!!!! I love having this every year!!

User avatar
blue3715
Black Friday Pro
Posts: 290
Joined: Wed Oct 29, 2014 4:34 pm

Re: 2015 Spreadsheet of all the Black Friday deals

Postby blue3715 » Mon Nov 16, 2015 3:09 pm

Most help indeed. No way else to search all ads for a TV model, etc.

xpedite
Black Friday Newbie
Posts: 5
Joined: Fri Nov 28, 2008 11:24 pm

Re: 2015 Spreadsheet of all the Black Friday deals

Postby xpedite » Mon Nov 16, 2015 11:00 pm

Is there anyway to get this spreadsheet on my phone? Maybe in Google drive?


My laptop died and I need to search for a new one.

User avatar
Shopper X
Suspected Line Jumper
Posts: 2637
Joined: Wed Nov 16, 2005 6:05 pm

Re: 2015 Spreadsheet of all the Black Friday deals

Postby Shopper X » Tue Nov 17, 2015 6:28 am

Sorry, I'm not sure how to do this. Perhaps other people might have advice on how to view this spreadsheet on a phone?

But, from just looking at the Google Drive help pages it seems that you should be able to import a CSV file from a URL into a Google Drive spreadsheet via the IMPORTDATA function.

https://support.google.com/docs/answer/3093335?hl=en

Code: Select all

IMPORTDATA("http://www.example.com/filename.csv")

xpedite
Black Friday Newbie
Posts: 5
Joined: Fri Nov 28, 2008 11:24 pm

Re: 2015 Spreadsheet of all the Black Friday deals

Postby xpedite » Wed Nov 18, 2015 8:56 am

Thank you, I will try that.

Shopgirl2119
Black Friday Pro
Posts: 29
Joined: Sat Oct 25, 2014 9:42 pm

Re: 2015 Spreadsheet of all the Black Friday deals

Postby Shopgirl2119 » Sun Nov 22, 2015 3:02 pm

Thank you for doing this :)

ced1106
Black Friday Pro
Posts: 41
Joined: Sun Nov 11, 2007 10:28 pm

Re: 2015 Spreadsheet of all the Black Friday deals

Postby ced1106 » Mon Nov 23, 2015 11:23 pm

xpedite wrote:Is there anyway to get this spreadsheet on my phone? Maybe in Google drive?


If your'e looking for a specific item, you can just open this in your browser and do a search like you would on a browser page.

Thanks for the spreadsheet! Mom's toys are expensive!

User avatar
Shopper X
Suspected Line Jumper
Posts: 2637
Joined: Wed Nov 16, 2005 6:05 pm

Re: 2015 Spreadsheet of all the Black Friday deals

Postby Shopper X » Wed Nov 25, 2015 5:26 am

The spreadsheet currently doesn't include Cyber Monday ad deals. Should it? Or, should I perhaps create a second spreadsheet for those deals?

My focus has always been on retail store sales on Black Friday. I almost never shop online, so I've always ignored those Cyber Monday ads. However, it seems that online shopping might become popular soon, and I notice that the two Black Friday and Cyber Monday sales seem to be merging into one general shopping holiday anyway.

Of course, Cyber Monday itself seems to be disappearing as a shopping holiday. Walmart is moving that sale to Sunday starting this year. In the past, people had to wait until Monday to have access to the internet and online sales at work. However, now people tend to have fast internet at home and no longer have to wait until Monday to shop online.


Return to “Suggestions and Tips”

Who is online

Users browsing this forum: No registered users and 1 guest