Book a demo Open Datablist

Guides & Tutorials

Learn how to grow your business with our guides.

How to remove and merge CSV duplicates online
You have exported your data from an application in a CSV file and want to eliminate duplicates? You have concatenated several CSV files into a big list and now need to deduplicate it? You are looking to deduplicate CSV files online on one or several...
October 14, 2024
Data Cleaning
Florian Poullin
Founder
Free online tool for Data Cleaning
Data cleaning (cleansing) is no longer restricted to data analysts. If you are dealing with a list of prospects, if you use scraped data in your processes, or if you consolidate multiple source of data, you know the importance of effective data...
September 8, 2024
Data Cleaning
Florian Poullin
Founder
How to scrape WhatsApp group members for free?
Follow this step by step guide to extract WhatsApp group members and export them into a CSV file. For free!
July 10, 2024
No Code Scraping
Florian Poullin
Founder
How to clean web-scraping data online
If you build prospect lists from scraping data, you will face this problem: How do I clean and normalize my data? If you have tried cleaning it with Google Sheets you know the tool is not made for this. With this guide, you will learn how to fix 99%...
May 25, 2024
Data Cleaning
Florian Poullin
Founder
How to merge duplicate leads without losing data
Leads Deduplication is part of a good data hygiene routine. Having duplicates impacts your leads' data quality. Your sales productivity drops and the problem only grows until you start doing leads deduplication regularly. This guide will help you...
May 24, 2024
Data Cleaning CRM Hygiene
Florian Poullin
Founder
How to merge duplicate rows in an Excel file without losing data?
Excel built-in "Remove duplicates" feature permanently deletes duplicate rows. Learn how to find and combine duplicates in an Excel file without losing information.
May 11, 2024
Data Cleaning
Florian Poullin
Founder
How to detect disposable domains in a list of email addresses
Learn the drawbacks of disposable email addresses, learn how to detect and remove them from your email lists.. And for free!
May 26, 2023
Data Cleaning CRM Hygiene
Florian Poullin
Founder
How to convert a TXT file to CSV online
Some applications export data into text files with a .TXT extension. Because plain text files are generic, they are an easy format to export data. This guide shows you how to use Datablist to parse your TXT file and export it into a standard CSV...
August 4, 2022
Data Cleaning
Florian Poullin
Founder
How to edit big CSV files online
Spreadsheet tools open CSV files but will crash on big files. Google Sheets shows an error when uploading a big CSV file and the user experience is terrible once you reach a few hundred thousand lines. Then, how to edit big CSV files when you are not...
August 1, 2022
Data Cleaning
Florian Poullin
Founder
How to join CSV files by a unique identifier
The CSV file format is a standard to exchange structured data between companies or different software applications. When it comes to manipulating CSV files, the go-to solution is spreadsheet. However, to join CSV files by a unique column or...
April 8, 2021
Data Cleaning
Florian Poullin
Founder