NorthSort / Samples

See a delivery before you order one

We ran three jobs from start to finish on made-up data, so you can see what you would get: the numbers, the checks and the questions. Every name, company, product and amount on this page is invented.

Jump to: Contact list cleanup, PDF to Excel, Merge and standardize.

Contact list cleanup

1,757 messy rows in.1,500 clean contacts out.

Delivered as one Excel file: the clean list, a change log, and a short list of questions.

The problem: Seven years of customer contacts from four different sources, too messy to load into a new CRM.

1,500clean contacts, one layout

257repeat rows combined, each one listed

1,757 of 1,757rows accounted for, none lost

182unclear rows flagged, none guessed

Before: rows of the one file, as they arrived (4 of its 10 columns)

before-contacts-export_2026-10-02.csvphones in 14 layoutsdates in 13 layouts

Row	Name	Email	Phone	Date Added
14	Hall, Justin	<justin.hall@darrowgate.example>	(905) 555-0141	04/14/2021
377	Christine Ivanov	civanov@perrinmere.example	716.555.0187	January 23, 2024
1322	karen chen	kchen@sablestead.example	1-716-555-0198	11/19/2022 17:18
1614	Jonathan BÃ©langer	jonathan@tansyridge.example	(773) 555-0125	04/04/2022
1679	David Gauthier	Dgauthier@fathomvale.Example	8025550177	2/20/19

before-contacts-export_2026-10-02.csvthe same person, entered twice

Row	Name	Email	Phone	Date Added
55	Donna Lewis	donna.lewis@mirrenfield.example	(250) 555-0199 ext 786	2024-09-24
1442	donna lewis	DONNA.LEWIS@MIRRENFIELD.EXAMPLE	1-250-555-0199 ext. 786	09/24/2024
161	Pamela Wang	pamela.wang@fathomvale.example	(802) 555-0180 x531	2019-02-11
1273	WANG, PAMELA	pamela.wang@fathomvale.example	8025550180 ext 531	11/02/2019

After: the same contacts in the delivered file (6 of its 15 columns)

Row	First Name	Last Name	Email	Phone	Ext	Date Added
12	Justin	Hall	justin.hall@darrowgate.example	(905) 555-0141		2021-04-14
53	Donna	Lewis	donna.lewis@mirrenfield.example	(250) 555-0199	786	2024-09-24
158	Pamela	Wang	pamela.wang@fathomvale.example	(802) 555-0180	531	2019-02-11
371	Christine	Ivanov	civanov@perrinmere.example	(716) 555-0187		2024-01-23
1208	Karen	Chen	kchen@sablestead.example	(716) 555-0198		2022-11-19
1414	Jonathan	Bélanger	jonathan@tansyridge.example	(773) 555-0125		2022-04-04
1446	David	Gauthier	dgauthier@fathomvale.example	(802) 555-0177		2019-02-20

What was fixed

Duplicates: 257 repeat rows combined, each one listed so nothing is lost
Names: split into first and last name, with proper capitals
Phones, dates, provinces, states and postal codes: one format each
Clutter: stray spaces, N/A fillers, blank rows and damaged accents cleaned up

The checks

Every row accounted for: 1,757 in, 1,500 clean plus 257 combined
Every email, phone number and ID traced back to the original file
Nothing guessed: 182 unclear rows flagged, with 11 short questions
A change log that counts every change, delivered with the file

Starter cleanup: 1 file, up to 2,000 rows, change log. Delivery: 2 days.

Open the one-page case study (PDF)Have a list like this? Get a fixed price

PDF to Excel

44 pages of PDF invoices in.383 checked rows of Excel out.

Delivered as one Excel file: every invoice, every line item, a totals check, and a short list of questions.

The problem: Three months of supplier invoices locked in PDFs, in two layouts, with the books waiting to be closed.

383line items, one layout

38 of 38totals matched to the PDFs, to the cent

2invoices that do not add up, caught

5problems caught and listed, none guessed

Before: the files as they arrived, and what did not match

quillhaven-invoices_2026-q3.pdfits own layoutunits and tax codesamounts as 472.00
brumont-factures_2026-t3.pdfanother column ordera discount columnamounts as 696,00 $

After: supplier_invoices_q3_2026-10-02.xlsx, 4 of the 383 rows in the delivered file (7 of its 14 columns)

Document No	Item Code	Description	Qty	Unit Price	Disc %	Amount
QF-104512	10240	Butter, unsalted, 454 g, case of 20	4	118.00		472.00
QF-104512	11020	Flour, all-purpose, unbleached, 20 kg bag	3	21.85		65.55
EB-26-00318	EB-B5031	Boîte à sandwich avec fenêtre compostable, caisse de 400	5	139.20		696.00
EB-26-00318	EB-M3001	Manchon isolant kraft, caisse de 1200	15	54.30	10	733.05

What was delivered

All 38 invoices and credit notes on one tab, all 383 line items on another
Two layouts and two ways of writing numbers and dates made one
Two-page invoices and split descriptions joined; a reprinted copy listed once
A change log that counts every change, delivered with the file

The checks

Every page accounted for: 44 pages, 38 documents, 383 lines
Every total matched to its PDF, to the cent: 107,273.95 in all
Supplier errors caught: 2 invoices that do not add up, 1 invoice number used twice
Nothing guessed or corrected: 5 short questions come with the file

Standard PDF to Excel: up to 50 pages, totals checked against the PDFs. Delivery: 3 days.

Open the one-page case study (PDF)Have a stack of PDFs like this? Get a fixed price

Merge and standardize

3 mismatched sales exports in.1 clean Excel file out: 4,489 checked rows.

Delivered as one Excel file: every order line in one layout, a validation report, and a short list of questions.

The problem: Three months of sales in three files that do not match: other columns, other date and number formats, and lines that are in two files.

4,489order lines, one layout

9 of 9control totals matched to the cent

50repeated lines caught between files

9problems caught and listed, none guessed

Before: the files as they arrived, and what did not match

sales-export_2026-07.csvmonth-first dates$ amounts stored as text
sales-export_2026-08.xlsxits own column namesdates as 1-Aug-26item codes that lost their zeros
ventes-export_2026-09.csvsemicolonsday-first datesdecimal commas

After: sales_merged_2026-10-03.xlsx, 4 of the 4,489 rows in the delivered file (8 of its 17 columns)

Order No	Order Date	Item Code	Description	Qty	Unit Price	Discount %	Line Total
100101	2026-07-01	083346	Roofing nail 1 in, 25 lb box	24	64.01		1,536.24
100664	2026-08-01	096083	Insulation batt R20 15 in	2	64.23		128.46
101208	2026-09-01	046890	Breaker 15 A single pole	5	11.50		57.50
101209	2026-09-01	080045	Hose bib frost free, 12 in	100	26.16	12.5	2,289.00

What was delivered

All 4,489 order lines on one tab, in one layout, each traced back to its file and row
Three ways of writing dates and amounts made one; item codes given back their zeros
A validation report, cleanup steps for next month's files, and a counted change log

The checks

Every line accounted for: 4,539 in, 4,489 kept, 50 repeats listed once
Quantity, line total and tax matched for each file, to the cent
Caught: a file total off by 412.50, 3 line totals that do not multiply out, 2 lines that differ between files
Nothing guessed or corrected: 9 short questions come with the file

Advanced cleanup: up to 10 files or 100,000 rows, validation report, and a written column map with a rule for each column. Delivery: 4 days.

Open the one-page case study (PDF)Have files that do not line up? Get a fixed price

Send a sample of your file.

You get a fixed price and a delivery date before any work starts.

Get a fixed price hello@northsort.com