> For clean Markdown of any page, append .md to the page URL. > For a complete documentation index, see https://docs.laposta.org/llms.txt. > For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://docs.laposta.org/_mcp/server. # Importing a file with subscribers from Excel or CSV > Add new subscribers to your list all at once or update the data of your existing subscribers. Via Subscribers → your list → Add → ‘Import’, you can expand your list all at once using an Excel or CSV file. You can also use it to modify or complete the data of all your existing subscribers. In addition to email addresses, the file may contain other subscriber data, such as first name, last name, gender, age, city, and telephone number. With this extra data, you can [personalise](/hoe-personaliseer-ik-mijn-nieuwsbrief) your newsletters and [segment](/hoe-segmenteer-ik-op-basis-van-relatiegegevens) your lists. The file must end with `.xls`, `.xlsx`, or `.csv`. Preferably save it as `.csv`: formatting, formulas, and extra worksheets will then be removed automatically. > **Note** > > Select the right list first before you start importing. Only import subscribers to whom you are [allowed to send newsletters](/kan-ik-iedereen-zomaar-een-nieuwsbrief-versturen). To prevent spam, you must first confirm on the start screen that all your new subscribers fall into the Good category. ![Import subscribers start screen with the Good and Wrong categories and the confirmation checkbox](/_fern-files/_img/6e668342b51154a4841ae79ba98ccbb94c6593e4a0454f737236942266f6bf11.webp) ## Importing a file #### Select your file Choose the file on your computer via ‘Select file’. You can read about which details you can include in [Choosing subscriber data](/welke-gegevens-van-mijn-relaties-voer-ik-in). If you want to see the best way to format the file, download a sample file as [.xlsx](https://laposta.email-provider.eu/download/4KLEJJ0puC/BQ6z0mHFe5?file=Voorbeeld_Import+Laposta.xlsx\&direct=1) or as [.csv](https://laposta.email-provider.eu/download/4KLEJJ0puC/vdgiF684AQ?file=Voorbeeld_Import+Laposta.csv\&direct=1). ![Step 1 of the import: selecting the Excel file on your computer](/_fern-files/_img/91f45701d1eaede1c9ad4639ceac44fcd0ada475ed5d8359aae117909f6398f4.webp) #### Choose what you want to do with the subscribers Tick what should happen to the subscribers in your file. You can choose one or more options: * ‘Add new subscribers’: subscribers that are in your file but not yet in your list will be added. * ‘Modify existing subscribers’: data of subscribers that are already in your list will be overwritten or (if empty) completed with the data from your file. * ‘Unsubscribe’: subscribers that are in your list but no longer in your file will be unsubscribed and moved to the ‘unsubscribed’ tab. ![Step 2 with the three actions ticked and the warning for unsubscribing](/_fern-files/_img/5bb093d7a9debb81e7769aded78f6833d4ebc02053b6cc4414668f79a4972b9d.webp) You do not have to limit yourself to your new subscribers: you can simply import all your subscribers. Subscribers that are already active are automatically deduplicated, so the same email address never appears twice in a single list. Laposta filters out addresses from your file that have previously unsubscribed or that have resulted in a hard bounce in the same list. This way, you do not run the risk of unsubscribed or bounced subscribers receiving a newsletter again. > **Warning** > > Do not create a new list for every newsletter to import all your subscribers into it. This takes extra work and unnecessarily creates more active subscribers, which could place you in a higher pricing group. Moreover, you then run the risk of unsubscribed or bounced subscribers accidentally receiving a newsletter again. Always work with the same list(s). #### Match the columns and start the import For each column in your file, choose whether you want to import the data and which field in your list it should go into. Import all subscriber data that is relevant to your newsletters straight away: you can use this to personalise and segment later on. ![Choosing for each column whether and into which field the data is imported](/_fern-files/_img/ea4dbe642c29525682560fd5a84fa7b9ef24efb2504742eecd2c6ed93575508b.webp) If you want to import multiple values into a single field (a multiple choice field where multiple selections are possible), separate the values in your file with a comma. For example, for the ‘Favourite holiday destination’ column: * `john@johnscompany.co.uk`: `Greece, Italy` * `rob@robscompany.co.uk`: `Sweden, Denmark, Greenland` If you want to assign [labels](/labels) straight away, link a column to ‘Labels’. If that column is called `labels` or `tags`, it will be linked automatically. Separate multiple labels in a single cell with a comma or a vertical bar. Labels that are not yet in your list will be created automatically. Click ‘Start import’. You will see the progress in the sidebar on the left while you can simply continue working in the programme. Importing a file of up to around 1000 subscribers takes just a few seconds. Larger files take a little longer. ![Status block in the sidebar showing the progress of the import and the View results link](/_fern-files/_img/f7f4033f19cdf23996d6e1fe1f0544274fb33c6a54e219e9482abb438ea11eec.webp) #### View the results Click ‘View results’ once you see in the sidebar that the import is finished. You will then see how many existing subscribers have been updated, how many new subscribers have been added to your list, and [why certain rows were skipped](/hoe-weet-ik-het-resultaat-van-het-importeren-van-een-groot-relatiebestand). ## The import is not working If your file cannot be read, please check the following: * Laposta only reads the first worksheet of an Excel file. Put the data you want to import on the first worksheet if your file has multiple worksheets. * Formulas or cell references are not always recognised properly. Copy the worksheet you need and paste it into a new worksheet via Paste Special → ‘Values’. You can also save the file as `.csv` via ‘Save As’ → file type `CSV (Comma delimited) (*.csv)`. ## Related articles #### [Why were rows skipped during the import?](/hoe-weet-ik-het-resultaat-van-het-importeren-van-een-groot-relatiebestand) After importing, you can see in step 4 how many subscribers have been added or updated… #### [Exporting subscribers to Excel](/kan-ik-mijn-relatiegegevens-eenvoudig-exporteren) Download a list, segment or campaign result as an Excel file, including unsubscribed… #### [Moving subscribers to another list](/hoe-kan-ik-relaties-verplaatsen-naar-een-andere-lijst) You can manually copy and paste a single subscriber, or move a large group by exporting… #### [Importing existing contacts from PerfectView](/hoe-werkt-de-uitwisseling-van-gegevens) Read which data the PerfectView integration transfers and how to import existing…