2015 Spreadsheet of all the Black Friday deals

[Shopper X]

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.)

[kenziekinz09]

Thanks for always putting these together!

[guitarist19862005]

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

[DemetriaBeth]

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

[Shopper X]

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]

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?

[Shopper X]

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.

[bfaddict]

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

[blue3715]

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

[xpedite]

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.

[Shopper X]

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]

Thank you, I will try that.

[Shopgirl2119]

Thank you for doing this

[ced1106]

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!

[Shopper X]

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.