Excel & Spreadsheets

Join The MysteryShopForum Community

We are a community of shoppers helping shoppers. Join to get full access to all the discussions.

Discussions About Excel & Spreadsheets

MS Spreadsheet

New year, new spreadsheet!... Continue Reading

Spreadsheet -- Database of Companies (Can you help update this?)

As many of you know @stilllearning and @StormCloud are working on updating the official database of companies here, which is very out of date. They've created a spreadsheet, linked below, which will be useful in updating the database here. They can edit it -- so if you add corrections, add notes,... Continue Reading

Spreadsheet

I have searched for a spreadsheet but have been unable to locate a template. All the thread links were gone and I couldn't find anything in the new member forum. Is there still any available? Also, what type of business would be best for tax purposes? ... Continue Reading

2021 Spreadsheet

Don't forget to build it!... Continue Reading

$4k+ Route and living in a van for part of the trip. PIcs and spreadsheets to view too.

Okay, so I (or my gf and I) do some pretty large mystery shopping routes. We've always tried to hedge our risk by utilizing a rental car and hotels. We budget about 150 a day of our shopping income for this. We got into a few groups... Continue Reading

Importing spreadsheet data into Google Maps

Can someone tell me how I can import address data from an XLSX spreadsheet into google maps. I have a list of 40+ assignments that I want to organize into routes in Google Maps but I'm not sure if that is possible. Obviously one of the column headings... Continue Reading

Excel Spreadsheets?

Hello, I'm new here and I can't find any downloadable Excel spreadsheets in the pinned topics above. Does anyone have any? Thank you!... Continue Reading

Here's my profit and loss spreadsheet for my January work for those interested in seeing what you can make

The goal of this route was to make a fair bit of cash but spread it out over the month. Everything we did in this route could have been done at least one week faster, probably as many as 10 days sooner. Feel free to ask questions if... Continue Reading

Spreadsheet Users

Don't forget to start a new one for 2020!... Continue Reading

Does anyone use a spreadsheet to track activity and payment details?

Thinking that an Excel spreadsheet might help me track details for upcoming, "in process", and completed shops. A place to consolidate dates, times, MSC, fee, reimbursement, bonus, when submitted, when paid, special notes. etcetera. I'm willing to collaborate with a couple of other people on creation of a prototype. [ Even have this... Continue Reading

Excel Spreadsheet

Does anyone have a spreadsheet that they have created and are willing to share? I am having a hard time keeping track of things because I have signed up to so many different companies in order to try this out and see which company works best.... Continue Reading

Shop/finance tracking/spreadsheets opinions and advice?

Hey y'all. I currently use one spreadsheet with different pages for each month to track all my shops. Once I've done the shop I move it into completed status in the section below, then put an X in the paid column when it's done. That being said, I need a... Continue Reading

Shopper Resource: Spreadsheet for Video shop companies, contact info, and allowed devices.

Hey everyone, I've been working on this spreadsheet to give out to shoppers. It's a list of all the known video shopping companies, scheduler emails, and what devices they approve for their shops. Everything else is just the normal site for the company. We carry all of... Continue Reading

Mystery Shopper Spreadsheet

How can I get a copy? Thanks.... Continue Reading

Alternatives to excel?

I started mystery shopping in June, and have quickly realized how lucrative it can be. I have been signing up for more companies and getting more assignments. I realize that I need to record everything, and I am very excel savvy, however my laptop does not have it. I'm not... Continue Reading

Excel Spreadsheet for Shopping expenses

Has anyone developed a spreadsheet for keeping a record of shops and expenses?... Continue Reading

Need some advice to set up spreadsheets for 2017, please

I'm trying to set my spreadsheets for individual companies so I can copy and paste into the main spreadsheet or vice versa. I would like date, location, scheduler, fee, reimbursement, expenses, how I'm paid (DD, PP, check), mileage and date I'm supposed to be paid. I'm not sure if this... Continue Reading

Taxes and the spreadsheet

I'm starting a new thread about keeping track of expenses for taxes. If the mods need to move it to the original thread, please do so. I called my accountant about what we can or cannot take as expenses on our schedule C for the tax year of 2016. Meals may... Continue Reading

Excel

How are your spreadsheets developed or organized? My spreadsheet is for the current year. The first tab is a summary with a list of the MSCs I contract with and links for mileage, shopper fees, and the amount I was paid. Following spreadsheets are categorized by MSC and have... Continue Reading

Spreadsheet for keeping track of mystery shops

Anyone have a spreadsheet that will help me keep track of my shops for income tax purposes? Doing taxes drives us crazy. I have got to find a better and easier way to do this.... Continue Reading

Seeking spreadsheet

Does anyone have a spreadsheet that they can share? I am a newbie and need some examples.... Continue Reading

Someone willing to share their excel spreadsheet?

Salutations, I've been mystery shopping for years, but recently decided to turn it up. This forum is awesome and I appreciate the abundance of knowledge being shared. I am hoping someone is able to share a basic spreadsheet I can use to enter MSC notes and information. It... Continue Reading

Mystery spreadsheet

I am a 'New-Bee" at this. Does anyone have a spreadsheet to track shops, payment, and when I am paid that they could share with me? I would be forever be grateful.... Continue Reading

Spreadsheet(s) Help Needed

I would like some help from some of the pros in this forum on some detailed info about how to keep track of the assignments (shops) that I have accepted and then completed and then awaiting payment for. I have been doing all this by hand by setting up weekly log... Continue Reading

Printing long survey -or- creating short spreadsheet?

I have a MSC that has a grocery store audit that is really simple to do once you read the 32 page book the first time and know what they are looking for. They also have an audit form for this shop that is 20 pages long and are repeating... Continue Reading

EXCEL help

So I'm finally getting around to my 2013 taxes and I want to simplify my life a little late. I downloaded transactions from Paypal in CSV. The problem I have is I would like to SUM the Gross column but I would like to be able to exclude items. For example... Continue Reading

Excel Shopping and Consulting

Hi, I am considering signing up with this company. Any experiences (good, bad or ugly)? TIA... Continue Reading

Price Audits.. 12000 items on an exel spreadsheet, get prices from given grocery store without getting caught.

How would one go about this? 12 000 items, recording the prices without getting caught? (Instructions explicitly say not to get caught.) The assignment is worth $450, and there are two of them, each about two hours from my home. Would it be worth spending a night in that city... Continue Reading

Spreadsheets

Hi, I downloaded the spreadsheet that was mentioned on here. When I opened it, it appears to be duplicated on itself. The cells are on top of each other and I cannot fix it. Example G1 is for the year, so I put in 2013 and then lower about three inches... Continue Reading

Trying to locate the "Mystery Shopping Bible" spreadsheet

Nothing shows up in the results of my searched for this... Looking for a spreadsheet to help organize my shops! :) Can anyone help?... Continue Reading

Need a spreadsheet asap

Hi all. I'm new to shopping, but so far everything is going smoothly. I would like to know if anyone can PM me a spreadsheet or something useful to keep track of my shops. I'm already on jobslinger plus, but that only keeps track of Sassie shops. Thank you all in advance! Leedah... Continue Reading

Excel Spreadsheet

Can anyone assist me. I am looking for a spreadsheet to keep track of my shopping assignments, track mileage and expenses. Robert Woods... Continue Reading

Excel spreadsheet problem

Since most of use Excel for keeping track of shops/expenses etc., and use different colors to help with that, I was wondering if anyone has had this problem. I have Excel 2003 and previously worked just great. Now every time I try to change the color of a... Continue Reading

Excel and a calendar?

Is there a free, or minimally priced, online software that imports from Excel? I enter assignments on Excel. If the dates and locations could segue to an online calendar, it would save me from duplicating my efforts. Also, it would give me online access, while on the... Continue Reading

Tips for Organizing my MSC's Spreadsheet?!

So I'm signed up with 138 MSC's thus far. About 15-20 of them are those notorious "We'll Email you when we have jobs". It's been 8 months since I compiled my list so it's 8 months old and hasn't been cleaned out or updated. I really only work for... Continue Reading

Microsoft Excel needed for a shop! Yikes!

I'm thinking about signing up for a shop, but it requires I know how to use Microsoft Excel. Is it hard to learn? I've not had a company require this, and thought it was just for their hotels. Sigh! Any thoughts floating around on the forum about this... Continue Reading

what does your excel spreadsheet look like for shops? what do you title each of your columns?

what does your excel spreadsheet look like for shops? what do you title each of your columns? what things do you list? like date? client name? address? payment? reimbursement? mileage? etc? i want to get everything perfect on paper for each day/week/month/year. what's... Continue Reading

Confessions of a spreadsheet junkie

By now, if you have been reading this forum for any period of time, you know I am a huge fan of Excel spreadsheets. I love making ‘workbooks’ where all of my information is at my fingertips. I was putting together one as sort of a genealogy of... Continue Reading

Help Please -- Using Open Office with Excel Documents

I just booked my first Buckalew hotel shop. I downloaded Open Office but don't know if I downloaded the correct thing and not sure how to use the programs. Also, would Google docs work as well? Thanks.... Continue Reading

Excel Spreadsheet for mystery shoppers

Hi! I am new to this mystery shoppers forum, but I have been dong mystery shopping forb several months and enjoy it. I, too, would like to get a copy of Flash's Excel worksheet for organizing everything in a more efficient way.... Continue Reading

Spreadsheet for keeping track of shops

I need some way to track a shop from its receipt to completion to payment. How do you do this?... Continue Reading

Technical question about Excel

Not sure where to post this. I recently upgraded my phone to a HTC Touch pro with Windows Mobile Office. I love it so much it's a wonderful phone. I went to school for computer applications from 96-98, but everything I learned is obsolete. The excel on my phone is... Continue Reading

Payment tracking and excel sheets

Flash and others have shared a great deal about record keeping. Somewhere I saw a PayPal account sheet that someone posted to reveal how much they made doing on line surveys. In the past, I've seen great shared comments. Do any of you have a great spreadsheet that you could... Continue Reading

Discussions of Excel & Spreadsheets

• Selecting the date on which you commit to conducting the shop. • Opportunities are consistently available monthly. San Diego CA Anaheim CA San Diego CA Anaheim CA Bonita Springs FL This restaurant excels in the art of Hawaiian and Japanese fusion cuisine, particularly highlighting the mastery of sushi, the richness of seafood, and the perfection of steak dishes. (Source). April 23, 2024

• Selecting the date on which you commit to conducting the shop. • Opportunities are consistently available monthly. This restaurant excels in offering unique Texan regional flavors complemented by a hint of Southern influence. (Source). April 23, 2024

I would generally rate the burgers as “good”, but compared to the Five Guys corporation standards, unless the franchisee has messed it up badly, I rate it “excellent” because that tells the Five Guys corporation that the franchisees are following their standards. (Source). April 19, 2024

- Evaluate the customer service, product knowledge, and salesmanship skills of store associates. - Assess the cleanliness and appearance of the store. Requirements: - Excellent observation skills and attention to detail are a must. (Source). April 19, 2024

I needed an excellent camera, and it is probably the best one I've used. (Source). April 18, 2024

But this is an ongoing project with shoppers. Requires attention to detail, work in a very short window, excellent eyesight, lifting, and shoppers are expected to deliver each and every month. (Source). April 13, 2024

Very old school and takes zero time to keep organized.[/quote] This will only work for those that do a low volume of shops. I keep a spreadsheet & my receipts for the current month go in a bin, after that month is over I move the contents of that bin to a larger one that has the entire year. (Source). April 12, 2024

Two Samsung phones ago, I had an S20 and it will definitely take excellent night photos, as well as stunning daylight photos. (Source). April 12, 2024

This is a spreadsheet of the Mystery Shopping Companies: https://docs. (Source). April 11, 2024

Spreadsheet day. (Source). April 11, 2024