Guides

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 - Florian Poullin

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 cleaning. With this guide, you will learn how to deal with messy data.

September 18, 2023 - Florian Poullin

How to extract the City and Country from a list of addresses

Whether you're dealing with a list of addresses in a spreadsheet, or with CSV files containing scraped data. You end up with a list of unstructured addresses. Read this guide to split your locations in structured parts: City, Country, GPS coordinates.

April 19, 2023 - Florian Poullin

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% of scraped data issues.

May 25, 2023 - Florian Poullin

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 merge your duplicate leads to clean your CRM.

May 24, 2023 - Florian Poullin

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 file. In the process, you will be able to select the CSV delimiter, and your export will be encoded with the UTF-8 international standard.

August 4, 2022 - Florian Poullin

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 a technical person?

August 1, 2022 - Florian Poullin

How to translate CSV files online for free

CSV files are perfect to store structured data and are used by most applications to export your data into a generic format. But you can't translate all the CSV as a simple text file. Some column might be names, or dates and must be kept unchanged. How do you translate some columns in a CSV file?

May 18, 2022 - Florian Poullin

How to scrape Facebook group members and enrich them with LinkedIn profiles

With thousands of thematic Facebook Groups available, follow this step by step guide to extract Facebook group member profiles. Enrich them with LinkedIn profile url to build your perfect leads database.

January 10, 2023 - Florian Poullin

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.

January 11, 2023 - Florian Poullin

How to clean an email list for free

Looking for a free tool to clean your email list? This guide will show you how to remove duplicate emails, check email addresses syntax, find addresses from disposable providers and detect email addresses with unreachable domains. And for free!

May 25, 2023 - Florian Poullin

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 columns? CSV deduplication can be hard with spreadsheet tools. Learn how to remove duplicates automatically in this guide.

February 14, 2023 - Florian Poullin

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 deduplicate CSV entries, they show limitations.

April 8, 2021 - Florian Poullin