Gallery
Share
Explore

icon picker
Email Transformer

Thomas Schranz
Tools for working with emails. Extraction, transformation, grouping and more.
⁠
email-logo.jpeg
⁠
⁠
Email Transformer is the swiss-army-knife of email transformation.

If you are working in marketing or customer support you sometimes have to work with a csv file including a lot of email addresses. Transformations of email columns into something else is useful but a lot of manual work.

For example you might want to extract the domain of the emails to check for domains of competitors or internal databases, to check for privacy preserving proxies (also called relays) from Apple and Facebook or to group emails by country. While not perfect: transformations of emails can be a surprisingly effective heuristic.

Another use case is to turn an email address into an md5 checksum to look it up in vulnerability databases. If you want to address a person by its name but only have their email address sometimes it is sufficient to transform the username part of the address into a capitalized name.

Email Transformer gives you various columns for your tables in Coda documents to extract, transform and group tables with email columns. To save time and get more out of the email csv files you are already working with.

Learn more by browsing the list of functions and column formats included in Email Transformer:
⁠
Email Transformer Documentation
⁠
⁠

Here is an table with synthetic example email addresses from a csv file provided by
letterhub
⁠
using transformations powered by Email Transformer:
Example Table with duplicated Email columns
email
md5
Name
Domain
Private
1
jbutt@privaterelay.appleid.com
764359bdd807e62ed65488eeafd6acef
Jbutt
privaterelay.appleid.com
yes
2
josephine_darakjy@darakjy.org
1a56fcccb62ea349b2a240af34c25b27
Josephine Darakjy
darakjy.org
no
3
art@venere.org
927ca2c6b20ce8f72f645715299da5b9
Art
venere.org
no
4
lpaprocki@hotmail.com
3bd5b329d175d85bb46b78623153e083
Lpaprocki
hotmail.com
no
5
donette.foller@cox.net
60c65234eb12198a102261911ec60fac
Donette Foller
cox.net
no
6
simona@morasca.com
b00cc3487bce69b13854779af4cb465a
Simona
morasca.com
no
7
mitsue_tollner@yahoo.com
fb778b1ccdede07fc8656fe6e6c5c6a7
Mitsue Tollner
yahoo.com
no
8
leota@hotmail.com
0e40896cce848beb4237f1e4fef5204e
Leota
hotmail.com
no
9
sage_wieser@cox.net
e22db494c00830bccc15b0b4415217db
Sage Wieser
cox.net
no
10
kris@gmail.com
830d2342ce8166f53f569ec822eea115
Kris
gmail.com
no
11
minna_amigon@yahoo.com
02d695a819461ba56acb4edb2b304ad8
Minna Amigon
yahoo.com
no
12
amaclead@gmail.com
7576e09f8eaa7b9030fe898cc3247a87
Amaclead
gmail.com
no
13
kiley.caldarera@aol.com
870ed6f54626eb7b0191e8d54dc09704
Kiley Caldarera
aol.com
no
14
gruta@cox.net
7dcd171e969517460c88a5bae40a28a0
Gruta
cox.net
no
15
calbares@gmail.com
d2ec5a9c5fb7c3802c9dfb65e17a52c4
Calbares
gmail.com
no
16
mattie@aol.com
931256559e0f69a7e85c5f951b7ee281
Mattie
aol.com
no
17
meaghan@hotmail.com
1321e3b811f46d603933ca63e6c547af
Meaghan
hotmail.com
no
18
gladys.rim@rim.org
f7d202f817e03275d7649b2952063e87
Gladys Rim
rim.org
no
19
yuki_whobrey@aol.com
2229eef349226401c1e3a5c224b70d10
Yuki Whobrey
aol.com
no
20
fletcher.flosi@yahoo.com
e706fe33ba7f6ccb98ab682023a11154
Fletcher Flosi
yahoo.com
no
21
bette_nicka@cox.net
138ecbdbc831c20706723c6b46ccbbbf
Bette Nicka
cox.net
no
22
vinouye@aol.com
3f55972cbadad3d917b5b6be76dae839
Vinouye
aol.com
no
23
willard@hotmail.com
c811d8422820f1bb76a33f113de61939
Willard
hotmail.com
no
24
mroyster@royster.com
bff4fd29414af5ffe82a360ee2b088b8
Mroyster
royster.com
no
25
alisha@slusarski.com
9f4490ee8a84d54fd004e3229cbc0194
Alisha
slusarski.com
no
26
allene_iturbide@cox.net
eb5e77db628971b9881fba19faa48b14
Allene Iturbide
cox.net
no
27
chanel.caudy@caudy.org
c3a3070f3b18eea3d344fe2d0ff3f930
Chanel Caudy
caudy.org
no
28
ezekiel@chui.com
5c41680194595429af46ba978bd2b41b
Ezekiel
chui.com
no
29
wkusko@yahoo.com
f76e0025447b30acbaacf0ab458e94d1
Wkusko
yahoo.com
no
30
bfigeroa@aol.com
e8e83573145fa2c51a9a8f466a111714
Bfigeroa
aol.com
no
31
ammie@corrio.com
b78868c6c5832b01214353b1e78cba33
Ammie
corrio.com
no
32
francine_vocelka@vocelka.com
bc8a83046bec9a15d8c7ba14b15893b0
Francine Vocelka
vocelka.com
no
33
ernie_stenseth@aol.com
04a00a59e16d1f2a5462c808ab50db87
Ernie Stenseth
aol.com
no
34
albina@glick.com
664bb525f6d954224f4310823b1ddd39
Albina
glick.com
no
35
asergi@gmail.com
ded90787328e8ab191c13c4314c5b611
Asergi
gmail.com
no
36
solange@shinko.com
3d5fad6eb5854d1ab3737db847866c9f
Solange
shinko.com
no
37
jose@yahoo.com
822ecf9d984ab2015b07f64575996295
Jose
yahoo.com
no
38
rozella.ostrosky@ostrosky.com
863578105dc47d0fcffc9bc1b422c117
Rozella Ostrosky
ostrosky.com
no
39
valentine_gillian@gmail.com
49ccaeb4187920729cc33b1ea7fa4982
Valentine Gillian
gmail.com
no
40
kati.rulapaugh@hotmail.com
478ba725b416ff42a2156852a51d4e9a
Kati Rulapaugh
hotmail.com
no
41
youlanda@aol.com
83ab56923f8e56fef05310bf4273294b
Youlanda
aol.com
no
42
doldroyd@aol.com
4af24e8dcdc52359d32ea77dfcc0c374
Doldroyd
aol.com
no
43
roxane@hotmail.com
260ec229cd594c7c3cd977a14be53bd2
Roxane
hotmail.com
no
44
lperin@perin.org
637ec9775227930c8f7d4a5c376d433c
Lperin
perin.org
no
45
erick.ferencz@aol.com
fd730440eda9a8c9d89ccabde5eeee2b
Erick Ferencz
aol.com
no
46
fsaylors@saylors.org
70965123f26b427d54d94c33f042ba02
Fsaylors
saylors.org
no
47
jina_briddick@briddick.com
386a6d097a490c48d5bbb3e238e8236e
Jina Briddick
briddick.com
no
48
kanisha_waycott@yahoo.com
2ca92929a1d8402c7d04e35c34a2fe27
Kanisha Waycott
yahoo.com
no
49
emerson.bowley@bowley.org
64627b92225a7ea0680adae51d0cbbd1
Emerson Bowley
bowley.org
no
50
bmalet@yahoo.com
3ddffe580628862886b99d44516cb323
Bmalet
yahoo.com
no
51
bbolognia@yahoo.com
cd45457980f5739264ead34c9a0402a2
Bbolognia
yahoo.com
no
52
lnestle@hotmail.com
e469c43e5bca91c06bd203dfe74106d1
Lnestle
hotmail.com
no
53
sabra@uyetake.org
a9f48c7faf806a2bb61c8c97338a9a01
Sabra
uyetake.org
no
54
mmastella@mastella.com
fb62ce1da08b21ec776925ecb119cf47
Mmastella
mastella.com
no
55
karl_klonowski@yahoo.com
6d11daa7b82485e7d7134ba69ba8d02d
Karl Klonowski
yahoo.com
no
56
twenner@aol.com
5ab3398e92832e21ff85cdf3e353395a
Twenner
aol.com
no
57
amber_monarrez@monarrez.org
f2ae92f5217ba3b919e28048682b98ef
Amber Monarrez
monarrez.org
no
58
shenika@gmail.com
2beb2ad4982fdcf39f59a48239c15e58
Shenika
gmail.com
no
59
delmy.ahle@hotmail.com
a8d6e005815ed2825ffee7ba8c941941
Delmy Ahle
hotmail.com
no
60
deeanna_juhas@gmail.com
53867a716a16f3ae1c1888416f59f6d4
Deeanna Juhas
gmail.com
no
61
bpugh@aol.com
0d4883a1ec96c9946dd49f25018005bc
Bpugh
aol.com
no
62
jamal@vanausdal.org
da0ebf186b5d92df97c6c98adaaeb478
Jamal
vanausdal.org
no
63
cecily@hollack.org
6c3642a0210c40cb638a5030ce88c91c
Cecily
hollack.org
no
64
carmelina_lindall@lindall.com
1c95a020145b011159d9b330f7050cae
Carmelina Lindall
lindall.com
no
65
maurine_yglesias@yglesias.com
f8f5b8f735fc2da3ade65feed2eaac1c
Maurine Yglesias
yglesias.com
no
66
tawna@gmail.com
2f0c548675d507966074c9b0431c8cfb
Tawna
gmail.com
no
67
penney_weight@aol.com
804eb86d8a51e2b6358861338a3316af
Penney Weight
aol.com
no
68
elly_morocco@gmail.com
9fc22d22aebd140c29125940a4f5a82c
Elly Morocco
gmail.com
no
69
ilene.eroman@hotmail.com
4e04b1afd13c48cbaff43ebe7a5c7de7
Ilene Eroman
hotmail.com
no
70
vmondella@mondella.com
36dc26475dda58ab3eacf6d24003cdf6
Vmondella
mondella.com
no
71
kallie.blackwood@gmail.com
106e61ad67effb6af7d1f4e6de8f7374
Kallie Blackwood
gmail.com
no
72
johnetta_abdallah@aol.com
943636b4e03bd2fc39f14a633da296bb
Johnetta Abdallah
aol.com
no
73
brhym@rhym.com
bd648d8dec0bf2d8fde7629d4f53421d
Brhym
rhym.com
no
74
micaela_rhymes@gmail.com
4dc60898566d6b33eba555a44cccff9a
Micaela Rhymes
gmail.com
no
75
tamar@hotmail.com
8d4f383778dbe36f238656ef43755cb2
Tamar
hotmail.com
no
76
moon@yahoo.com
a05d5e4cc92459d0060db08eb4fb66ea
Moon
yahoo.com
no
77
laurel_reitler@reitler.com
41b8882f457b7f7445d70b045cb560e4
Laurel Reitler
reitler.com
no
78
delisa.crupi@crupi.com
98542b13dcd88dd31caaee1c118ddb00
Delisa Crupi
crupi.com
no
79
viva.toelkes@gmail.com
72310bf61fa55e9b909ac4e797ee5b5b
Viva Toelkes
gmail.com
no
80
elza@yahoo.com
7b7fe52849305111b7511c5a8587315a
Elza
yahoo.com
no
81
devorah@hotmail.com
fa85aaaa98c9134a49abb70469a9159f
Devorah
hotmail.com
no
82
timothy_mulqueen@mulqueen.org
4066198d7a1aa51c4dd9771b560bba06
Timothy Mulqueen
mulqueen.org
no
83
ahoneywell@honeywell.com
5bfde3bcd95c7137f2e73901672cf5f3
Ahoneywell
honeywell.com
no
84
dominque.dickerson@dickerson.org
4bace9284cb382d34f4410c7cfb4b466
Dominque Dickerson
dickerson.org
no
85
lettie_isenhower@yahoo.com
1a10f780a8d47836f66729d33adb69f3
Lettie Isenhower
yahoo.com
no
86
mmunns@cox.net
7d9cb4265d76e1f72f538f69f68c023f
Mmunns
cox.net
no
87
stephaine@barfield.com
6f5ece8c6fecba7e23557524ebd2c9b8
Stephaine
barfield.com
no
88
lai.gato@gato.org
c3bfa25d297bf9715ba86e01a2cc8b70
Lai Gato
gato.org
no
89
stephen_emigh@hotmail.com
cb10a8246adfc9e2d2a2cc81ff89db6f
Stephen Emigh
hotmail.com
no
90
tshields@gmail.com
6ee04f1d306fad2f6c17d2cfe21064ea
Tshields
gmail.com
no
91
twardrip@cox.net
1fee04bf28cb4e3f59269afbffe6aa89
Twardrip
cox.net
no
92
cory.gibes@gmail.com
54915a50eeb16c2bbb4099da7f8870d4
Cory Gibes
gmail.com
no
93
danica_bruschke@gmail.com
c91e3bff4ba20d9f7d0f3f826ce19617
Danica Bruschke
gmail.com
no
94
wilda@cox.net
cf2d0ced5de3fb3601413b858a4d606d
Wilda
cox.net
no
95
elvera.benimadho@cox.net
5d8f0c17d0399a128dc0529af4ab2a2d
Elvera Benimadho
cox.net
no
96
carma@cox.net
4acdcefde46a3e958b8fd99b39c45138
Carma
cox.net
no
97
malinda.hochard@yahoo.com
c8dc95268a89bb5cc9c1917f61028ff9
Malinda Hochard
yahoo.com
no
98
natalie.fern@hotmail.com
4b2d8d1c60a39cb4e0d4b9a2be6e691f
Natalie Fern
hotmail.com
no
99
lisha@centini.org
cf7432ea67f28bcd0a02af35450f65ef
Lisha
centini.org
no
There are no rows in this table
⁠

Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.