Payment protectionDetails
- Revisions within the package are free.
- If you do not respond within 3 days of delivery, the work is accepted automatically.
The money is reserved when you pay and released only once you accept the work.
Example result
Spreadsheet cleanup: customer list of a garden centre before a mailing
Before (sample rows)
| Name | Phone | Signed up | Spent | |
|---|---|---|---|---|
| JANE MORRIS | 07700 900123 | [email protected] | 3/4/21 | £1.240 |
| Jane Morris | +44 7700900123 | [email protected] | 2021-04-03 | 1240 |
| peter o'neil | 7700-900-456 | April 2022 | £85,50 | |
| Dr. Alan Fisk | alan.fisk@mail | 12.06.2023 | £310 | |
| test test | 0000 | test@test | 0 |
After
| First name | Last name | Title | Phone | Signed up | Spent (£) | Flag | |
|---|---|---|---|---|---|---|---|
| Jane | Morris | +44 7700 900123 | [email protected] | 03/04/2021 | 1,240.00 | Merged (2 rows) | |
| Peter | O'Neil | +44 7700 900456 | 01/04/2022 | 85.50 | No email | ||
| Alan | Fisk | Dr | alan.fisk@mail | 12/06/2023 | 310.00 | Check email | |
| test | test | test@test | 0.00 | Test row |
What was done
- Duplicates: 61 groups found (by email: 48, by name + phone: 13); merged into one row each, keeping the most complete details and the earliest sign-up date. Spending was not summed, because the two rows showed the same amount; 4 groups with different amounts are flagged for you.
- Names: split into first and last name; titles (Dr, Mrs, Mr) moved to their own column; capitalisation fixed, including O'Neil and McKenzie.
- Phones: 571 numbers brought to +44 format; 22 numbers with too few digits flagged.
- Emails: lower-cased and trimmed; 17 without a domain ending flagged as "Check email".
- Dates: 9 different formats converted to DD/MM/YYYY; month-only dates set to the 1st and flagged.
- Amounts: currency signs removed, comma and dot mix-ups fixed, stored as numbers.
Row count check
| Rows | |
|---|---|
| Rows in the original file | 684 |
| Removed by merging duplicates | −67 |
| Test or blank rows moved to the "Removed" sheet | −9 |
| Rows in the clean list | 608 |
| Of these, ready to email | 553 |
Every change is listed on the "Change log" sheet (row number, column, old value, new value, reason), and removed rows are kept on the "Removed" sheet, so nothing is lost.
Client: Greenhill Garden Centre, preparing a spring newsletter and a loyalty card launch Input: "customers_all.xlsx", one sheet, 684 rows collected over 5 years from the till, a paper sign-up form and an old website Rules from the client: a duplicate is the same email, or the same name plus phone; phones in one format; split "Name" into first and last name; dates as DD/MM/YYYY
The client and all details are made up.
About this service
Exports from Google Forms, Typeform or SurveyMonkey are rarely ready for analysis: question text as column headers, multiple-choice answers in one cell, 'Other' answers typed in free text, test submissions and the same respondent twice. Send the export as an Excel file with your questionnaire and we rename columns to short codes, split multi-select answers into Yes or No columns, code answers into numbers by your scheme, group 'Other' and short open answers into categories and remove test and duplicate submissions by your rule. You get a codebook that explains every code, so the file can go straight into Excel, SPSS, R or any analysis tool.
What is included
- What you getThe survey data as an Excel workbook: a coded data sheet with one row per respondent, a codebook sheet with every variable, question and code, a sheet of grouped open answers and a log of removed submissions. We clean and code the data; we do not run the analysis.
- Short variable namesQ1, Q2a instead of full questions
- Multi-select splitOne Yes or No column per option
- Answers codedScales and choices as numbers
- Open answers grouped'Other' and short answers into categories
- CodebookEvery variable and code explained
How it works
- 1UploadYou send the export and your rules
- 2Clean-upWe go through every row
- 3DeliveryYou get the Excel file and change log
What we need from you
The survey export as an Excel file with up to 12 columns (split wider surveys into parts), the questionnaire as Word or PDF, your coding scheme if you have one (for example 1 to 5 for agreement scales), how to spot test and duplicate submissions and confirmation that respondents agreed to the processing of their answers.
We will ask you:
- Which tool did you run the survey in?
- Do you have a coding scheme for scales and choices?
- How should we spot test or duplicate submissions?
- Which analysis tool will you use?
Compare packages
| Packages | BasicUp to 300 responses$12 | StandardUp to 700 responses$25 | PremiumUp to 1,200 responses, up to 3 sheets$45 |
|---|---|---|---|
| Deadline | 1 day | 2 days | 3 days |
| Revisions | 1 | 2 | 3 |
| Rows | up to 300 | up to 700 | up to 1,200 in total |
| Columns | up to 12 | up to 12 | up to 12 |
| Sheets | 1 | 1 | up to 3 |
| Order Basic | Order Standard | Order Premium |
Payment protection
You pay when you order, but the money is released only for accepted work.
- Fixed priceThe package price does not change after you pay.
- The money is reservedWhen you pay, the amount is only reserved. It is released to the service once you accept the work.
- Checked before deliveryEvery result goes through a quality check before it reaches you, and you see it on the order page before accepting it.
- Free revisionsAsk for changes within your brief as many times as the package allows.
- Acceptance after 3 daysIf within 3 days of delivery you neither accept the work nor ask for changes, it is accepted automatically. If you write in the order chat after delivery, the order waits; once we answer, we may start the 3 days again and will say so in the chat.
- Redo or a full refundIf the result does not match your brief and the revisions did not fix it, or the work takes more than twice its deadline, write in the order chat: we will redo the work or refund the payment in full.
Questions and answers
Will you analyse the results?
No, this service prepares the data. You get a clean, coded file and a codebook; for charts and findings, order an analysis service separately.
Can you code long open-ended answers?
We group short answers and 'Other' fields into categories. Long essays need a thematic analysis service instead.
My survey has 40 questions. What should I send?
Each order covers up to 12 columns. Send the questions that need cleaning in parts with the respondent ID in each, and join them back by that ID.
My list has more than 1,200 rows. What can I do?
Split it into parts of up to 1,200 rows and place one order per part with the same rules, so the results match.