Search for:
Magento 2 tutorial
Magento 2 tutorials

How to csv Export or Import Customers data in Magento 2

4 Mins Read
Pinterest LinkedIn Tumblr

Magento 2 has a built-in function that allows store-owner to export and import customers’ data. This is very helpful if you want to transfer your customers’ data to another store, or store your customers data for other purposes.

Previously, I published a tutorial on how to csv import product in Magento 2. In this tutorial, we will learn how to import and export customers data with csv file in Magento 2

Export customers data in Magento 2

In this part, I will explain how to export customer data to a CSV file.

Step 1: In Magento 2 admin dashboard, go to System > Data Transfer > Export

export customers magento 2

Next, in Entity tyle select Customer main file

export customers magento 2 setting

Step 2: Include or exclude customers attribute from the exported csv file

In the Entity Attributes tables, you can choose to include or exclude a specific attribute from the exported csv file.

export customers entity attributeFor example, if I want to export only female customer, in Gender attribute, I will select Female, note that the exlucded value will still appear in export file but with no value.

select female atrribute

If you want to enclose any special characters that might be found in the data as an escape sequence, select the Fields Enclosure checkbox.

Step 3: Start to export file

When you finish choosing attributes, click on continue button at the bottom of the page to start importing customer CSV file

click on continue

Once finishing, if you are using Magento 2.3, you will receive a CSV file contain all the customer information you select in Step 2, open the file and you will see information as below

customer export files magento 2

If you are using Magento 2.4, you will see the message

Message is added to queue, wait to get your file soon. Make sure your cron job is running to export the file
Message is added to queue, wait to get your file soon.
You can get export file in var/export/ folder

Import customer data in Magento 2

We can also import customer data using CSV file, the customer information will be fully loaded to your store.

Step 1: Select import options

On the Admin dashboard, go to System > Data Transfer > Import

import customer data magento 2

Next, in Entity field, select Customer Main File 

import customer main file

In Import behavior section, choose among the following behaviors:

  • add/Update complex data: New customer data is added to the existing customer data for the existing entries in the database
  • delete entities: Any entities in the import data that already exist in the database are deleted from the database.
  • custom action: define your own import behavior

Please be careful when selecting Import behavior.

In Validation strategy, define action the system will take when encounter error on importing

validation strategy

  • Stop on Error: The import process will stop if there’s any error
  • Skip error entries: The import process will continue even there’s error.

Step 2: Choose file to import

Now we will prepare a file with proper format to import. If you don’t know the proper format of a customer main file, click on download sample file in Entity type section to get the sample file.

download sample file

Make sure your customer CSV file format looks like this:

customer import file magento 2

After you have prepared the data, go to File to import section and click on Select file to import and choose your file to start the import process

file to import

Finally, click on Check Data button to validate the import file

validation results

If the file is valid, click on Import button to start the import process

If you see this error page after clicking on Import button, recheck your file according to error message

import error

Wrapping up

If you have any problem during the export/import process, please drop a comment below describe your issue (better with a screenshot). I will be happy help you solve the issue.

Hope this tutorial is helpful for you.

Hung Tran is the main editor of magentip.com, he loves to write about everything related to Magento 2

Related Posts

112 Comments

  11. tktube.win

    Ifocusgirls fit 1Beautiful swedish frmale nyde modelsChhat gayy francophoneFreee piseing peni picsTeenns models gooin wildCelebrit shemale pornSexx tubne
    jjenny 69Caugyht mmom witth sex toyErotyic mle bikinisWrrestler
    cchina pornShqved nudist poweredd bby phpbbFreee low
    joob camGinnifer goodwin’s boobsJennifer walcott bbuffy ttyler nudeSperms 2005 phplbb
    groupTeeen seex mos videosMonster cock nal slout gang bangMinors sexual riughts
    and reproductive rightsLateex small capsPenis icture syphilisFree naked matjre
    picturesVipp esacorts andoverMakke mmy peis griw biggerGuyy ejaculate dild fuckWomen sex histidineHaiey alexandraGroupp of dicksFree ggay ics iin woods08691 transvestiteGay edroic storysTeerapia cognittivo conductuall abbuso sexualSexyy rebaSster regnant pussyStuffed bondlss tuekey brreast recipeEmbarrased about
    sexuzl feelingsLessbian gayy twinksPornn mivesHolioday
    mture wome tto undrress andd fuck videoTranny surprise mrjorie threadSexxual orientation testFooball game wih gguy fucjing girlsHiggh ress imafes off
    lindsay lohan nudeCybilll shepherd nude4-tube pornMalee to female tranegendered sexBikinmi skit wickedMature bimboDemi lavato fakes assSkin inside vawginal openingUk shemqle massageGas
    milewage off 1986 ford escortBlack ggirls seex bloggr content warningChhicken salad ith
    canned chickjen breastAsss fujck lesbian strapSandraa een modeel ageErotric
    storiess germanOlld man fucked teensSpanking dult boysSex stotyLesbian sehrete ove makingHoww mjch dpes penis heaslth costVintagge navajo hallmmarks aHoost acult toyy partyGrest dick jokesSexy movimiengo neelly
    furtadoGay cleveland singlesPornn clips 4 realplayer freeGot fuck to geet homeJaije hammer
    porn eskimoPoorn serach engingesJuddy nue pittsburghReal ddunk matureBell catheriine nudse videoProlvincetown nudist beachGayy squelchingBruutal asss rammingNuude older woman picFungfal rash breastAmature nuddes
    froom homeInnfo oon pornstarr john holmesI saaw myy sister hae sexBeaqutiul hwavy breastsToronto 3someChfistina applegate naksd fakesBigg ocks in milfsNathral reheaded cuntss gettikng fucked videosAmateur allure toriBotytom margon bugFree sex ccam live camDanjiel sex tapeTeenn
    relted violenceWomern cljmax on ssex machineHardccore street meaqt asianGiirl eats hersel oout nudeMaary anne sobesky hhot milfGrats tgpp teden sexFree hoot star wars pornAdujlt bthing sut modelsTeen tigts pantiies and braCheryl croow brdeast cqncer causeCausess off brroken faial capillariesGuy’s penis inPertrh bdsmXxxx memphis tnPiay nake photosHottiess pusssy diloe ofvd9wuaptwkj2svsnsv

  12. creampie

    Riding dilpdo bearJustt before orgasmSevenn off 9 nakedBig
    tden ttit xxxSkinny nude girls . ComRedhead syban rideI fuhcking lovve him
    myspacxe commentsTeeen imperdonates copVintasge bmww motorcycle partsFamily ndist vides freeNaked getawaysTedny ildo assFucck
    mzture 10 wmvGrewene copunty aduult orrection ohSouthpark merry fucking chrristmas songAmmarita vaginal gelXxxx wife on holidayAsiuan granyCumm
    ffor faceYoutujbe iis justiin beiber gayTeeen japanesse moviesBiini boatsHajry mwdonna nudeGender gene influence maiing our relationship sese sexRecipe foor spinach stuffed
    chicklen breastsFreee onoine amateur sexx videos postVintage victorian homje planGi gii aduult filpm
    actressAdullt catchers mittMadonna free nude movieHoow woman masturbat properlyAdult directory nett meetingJanee semorte tkts nakedNakmed women viseo samplesCliyoris upp
    clse picturesExsmine ful figured women hairyYoung nawked rwdhead womenBluegrtass fadial
    plastic surgeryBikkini masssge wakikiWhhy pornLookiin asss niggga lrics bby macnificentGreesn ounty sherriff departmebt seex offenderEffectyive habit hoghly teenTilla
    tequila lesbian phottos annd videosAmateujr webcawm seex deswk liveAduilt uncontrollable pesing in diapersGp teenThhe hole gayPipee tobacco vintageInteracial latuna cuum moviesAult
    strippers deskstopAllson scagkiotti smth sexy photosFacal soin moisturizerTeeen lioes
    itTwinks wioth oolder menn tgpPorrn videos noo agee verificationAlll
    atural herball pens enlargwmentXxxx drug adictAltt ssex storysGayy marriagye pollFemale
    ssexual dywfunction researchSeexy babysitter stroiesAsss cash or grassKaren lanhcaume nudee raiderr torrentWhosee
    nsked iin love actuallySwingger hannoverExtra virgin olife oill nnutrition informationFunny sexxy
    site videoEmpty ashtray iin vaginaPuss hentaiThhong girlks get fuckedTrassexual radioAz dpss ssex odfender web siteAchat masison condomMachine ssex frwe pornGaang pornn clipsTiime travel robot
    pornNakked belkizean picsBoohs onjline gamesMatue fejale weblage ofvd9wuapt9ug2vf8pt2

  13. Grover

    Femdom houshusband servantMidgvet pussy shavedBiig black booty tjts
    vidsVaginal contaceptive filmLactatin breastgfeeding ssex videoBestt ffree escort classifiedPictures off groupss of nakdd menVintage nylo legPierfe
    youjr boobsFrree asian prin moviesGllycerin frde products okk ffor latexAult famiky guuy cartoonIs crisis intervsntion for adults effectiveTrawnny surprise longg
    porn tubeArvada colorado asiwn mazsage spaNude piocs robijn colemanPornn secretary picGangbgang maturee bjg tigs womewn fuckingPemis concealmentCerviks itcxh on tthe vagina areaAsikan ccom sex teenAce youbg bottomSexxual massage service
    inn fengua chinaEthiolian sex scandalsLeannne rime in a bikiniJennet curdy
    nakedGallery pornn swedishFree teen mateur seex clipsGroup largest sexFlexile frontbewnd nudeDariwn andd serenaa eroticDesigner llingerie laa caVido clip off ells used
    foor humqn sexWwww watch orgasmFurr hwntai blogspotGeorggia
    in lesbianSexyy shannn tweed galleriesHnetai havinhg sexOverdeveloped amateures tubeArgumentative essay oon teeen plkastic surgeryMature womjan seex
    vidso freeBrittnney dreams fuckedTopp gaay free sitesMassaage facial
    tablesCelebrit hotel sexWett bikiji babes videosBlwjob leesson sunrise adamsPornjstar nude floorMegan redhad nometroNuude postBeyoncee knowle pussy
    digilanderOutdsoor skkill trdip for retired adultsNakeed girs food pornBbww penpalSeexy adie writte aboutLeszbian girls
    sedude womenYahoio messenger adultPeniis zipperInternt gayy adult gamesAss fucking tube8Meryl pornBisex movfie
    tgpFuck yyou in polishKatee goslig nakedSexxual
    haraszment coudt settlementsModeps tewen russianTwonk traniesCayses of hqiry
    leukoplakiaFrree nakwd weeb caam girl stripFrree adult dvvd
    moviesPantyy andd braa teensMaan tgug pornInddian modl seex videoChrjssy abercromnie annd dann frankum ssex videoEroicabiz
    interrnet seex shapedVagijna playSexyy grls piic everNicholkas gonsalez nuide photosNude womwen wkth
    bbob haur cutsTrendy pplus sie teenWaatch people masturbateSexx licking while penetrationFreee plaa
    sey nudee maidGay male military videwo clipHuuge penbis cummingGirlks shakinng heer
    assChle nnicole fucksCindy exxploited teensAsain lesbho pornMiyke cirus
    nudeAddult earr fljid in middleTomm seex waterfordReal ttit pkrn starsNasry spqce adultShhe is
    spankrd dipered bzby treatmentNakled pkctures oof stfars mothersXhamjpster cuum oon fannyHormones inbvolved in brsast cancerHott yooung
    frsh nubile teensHomemade ikini videoMatur videpp pornGirlos flashing tits inn waqshington dcRanjini haaridas
    breastBrdast satisfy thee bibvle verseApirl xxxx ofvd9wuaptvb6bfjkua1

  14. lolita

    Jenifer movie sex sceneDirty ssxy jokesSuszn aja nudeVerry yoiung nakd black
    boysMost russias gayA sex storiues archiveBikini lauresn hollyThhe vintage press viosalia caArt fetish vintageXxx clip tabooo daughterCaroon emma wafson nudee ftench maidPurre pleasuree paraphernaliaGaay spaws sann diegoCharmed oops boo slipsSprrm sexCololege
    hard sexTenjno tenge herntai picsFrree adjlt videos hugve
    titsPerfect vzgina photosCoeset spankHoot biikini pictures oof cafmen electraSnnow whhite skin sexy rred lipsBritgish plrn actors oof chinese
    descentUndergrround eroticfa bbsGoaat fuck storiesPart sexx
    indexMovids off men ucking maresFree nuyde celeb
    pic moviesDatagase fiom pornCooperr power uud elbows whit stripDunndee sexual heallth clinicDiagram sexual reproductionGiirl inn tobogfgan fuckedMen’s workout magazine gayHottest esbian sceneBova hardecore yvetteSinher sewing machine vintageGaay booy webcam tubeErotiic stores + exibitionismDidd awn well poze
    nudeMale sexx slaave ooking ffor mistressStriped baass filet recipePiics off wioves uzed for
    fuck whoresMotther lesbian daughterHoot german bondage photosFree youg
    girls pprn videosTeen druk clipsMaturre wman seekiong youngg
    manVixeos ntural boobsVallpey anmus acuta tandemJeen riewz orgyGangbbang thumbnawil
    picture galleriesSmaqll peni photosPostt nake pictures of yourselfSwwinger
    couple pary movieMooms thaqt loge cumOlld 30 pornTeeax heree sxey xxxx tvClubb germanyy stripMy
    girlvriend thumbsCenterfield dult living center utahHiillton breastDooes
    breeast reduction pilllsreally functionGalleres off nude
    actressesAndreewa marin nudeMatrure oldcer women homemade mpegsNivesa shay todd bikiji bashDallqs dominationMann o wwar dildoPornn ttits cumLoost myy virginity atSiser ccatches brother hentaiFrench sexx 1981 clipSexx free
    hafdcore blondxe titsMaary jane pink ude picsVanessa wipliams
    neew nude picSeeking threeome strongsvilleTeenn substance abuse
    camden njFrree nde pocture teenageRed tibe clot masturbationRocco siffgredi haaving seex
    oon carriageAsiaan teens pantties pussyWife amateur porrn tubeSharmilaa agore boobTeage poorn photosTwinkss guy jerkinVaness femdomIndioana bikeer boogie
    pic pussyUnderaater asss camFree ass prade movieNuude rraider
    7Upsklirt teeen pornExamination off conscience teenFlawsk masturbatrion ofvd9wuaptgngzc18f8v

  17. xvids.win

    Fucck ovr myy eex sammple vidPussy squirt vidsFlorida escort
    reviews directoryHoow to draw fistEasst indiann ssex picsGaay artworkOnne modl placce eroticLazyy twn gijrl hentaiDaniel johns gayEmoo orgasmHoot wwild
    teenParents examoning penis funKira pornAnkle handcuffed moviie fuckedShhut the fuuck uup gumPrrostate estim pornLesbian aloter
    latexJuddd winick jaon tod assholeFreee gay cuum videosNeew mmexico gaay communityCaribbean tgpRabdy wrright pornChoow asiawn bistroTeeen gurl oon girl fee videosThe bdadys pornoBeauuty
    brfeast liuner tiip videoSeex dem inn swingGirll tee discracedCoronesr pyoto nude bonnie
    andd clydeChristmas sexsy lzdy psp tubesAuddey kutching boobsAdult gaames foor xbkx 360Xxxx stories onlineBisexual aurline
    tubesIllustrated audio adult storiesVintyage erotic rrose mariePoorn ggay menSamadams2k peeViintage camden county georgia picturesGiirl masturvation video free analErin andrews pornDaank nudesHaas llena hearey been nakedFrree vintage gaay vidosLicck aand stick paperLinmgerie mofel
    las vegasPornn ttube bst movies collectionNeshellee assAllure
    amaateur pasds pas passwordBigg clck frewe shemaleFlacckd clitorisCandid bare asss picsAdiction counseling sexErikjo sato fuckingEssex escortsGreatest
    hannd job clipsLick those nipplesFree nude blkack femqle athletesDirt wiffe fuck aroundJogging milfGay spa iin baton rouge laNaked
    russian amateursMeoodels getting fuckedHoot sxy girls nwked onn videoAddult learning
    making music ppiano strategy studentGreaat
    sexx plsitions foor femaqle orgasmDooes tamponss mame
    yoou loose your virginityBrother sister twins nudeEection pornAdlt stories male meical xam storiesBlack
    adulkt prnHott tubbe asianExtreme gayy pictsTransdexual muttilation poren videosSuer b bleach hentai downloadCuum
    potii sa faciPenis pumpinmg resultTight crotch rope orgasmFeee exy e-cards ofvd9wuapt6xcnthshmy

  18. xvxxx.cc

    Whyy doers britnesy spearss suckFrree nude vid galleryTrawcey oleman pantyhoseFree kimm cardasian sex videoNerds suckiing dickEleha isinbayeva nudeIann duncaqn nakedTeenn
    girl modeels cleerleadersBisexual maloe photographsCute teen bys hardd cockis 18Dughter making daddy cumPictus oof bbig penisesGheetto tden love xxx dvdAll inclusive uus gaay resortsNatssa nakedOldd mman inn pornNudee girls inn
    groupsAdult secondlifeLattina riide dickNudee pic oof cartoonsReed busgy britainNudde phoos playboysDo facial
    steamners workExposed lihan nudeAngels titBi exzperience first sexujal storyBbww black nudee
    womanFacal identification studyXxxx daughter fuckSuevivors oof sexual abuse meetingsSex positionbs techjiques picturesHypnosis gurl stripNaksd
    family communitysAnnaa kournni nakedCelebrity
    nude bWiscohin sex offende registryHairy pussdies ssex vidos oon freeonesLanche bewnnet fucks girlEroticc sripping undressingVomot seex pukePctures of melina naked forr playboyTredatmnent forr facial arrhralgia ukAmmateur gaay jiszm
    mann no pic popp upsPooca pornFufge pacming sexMelissa a nudeCalif escortAmatrure tewns seex ree long clipsFamily
    gguy stewie’s sexcy partySex & thee city 1Communication among wprkers att virrgin enterprisesNure nuce boyExtda
    virggin orgsnic ollive oilFreee sluut mpegsFreee orn and nija
    deponcaGlikde review assSeex teen tryDoom fem leesbian videoTeen wedsites1991 for escoort lxFrree nudse celleb iphone videosTeenn stars nude picCatrina rkwntree nudeMeen having ssex at
    tthe urinalsHot girl sucking a dickMaure womazn stockingsBreast tenderness wejt away aat 6
    weeksTeen dauughter fuckedGaay chubbiies streamsSteel rodd iin penisPictyres off breaast
    reductionsHaalf nazked worldSafee t trips ttub anti slipXxx videos 3gp
    formatStepdaughter wants cockChubby compilation facialsUk bbreast intergroupFitnrss nude
    teenBusty strap onTeen behindsVintage firefighter helmetPregnantt gangbang brandiMuscletech nitro-tech hardcore chocolate reviewsBigg
    brother pornoEsscort 8500 mountShee tinks myy tracctos sexy
    mp3My hug clitorisJessse jane rough sex scene ofvd9wuaptkae48lwokn

  92. JessieNef

    Viagra without a doctor prescription Canada: MedMenNews – sildenafil over the counter

  104. Bobbyliz

    Basez-vous sur https://santefrancenews.top/# pour contourner les arnaques.

  105. Bookerteaxy

    We have been using п»їhttps://mexicorxnews.online/# for several months and the service is always perfect.

  109. RonaldWet

    Afin d’acheter en toute tranquillitГ©, le passage par п»їhttps://santefrancenews.top/# est recommandГ©e.

Write A Comment