User Agents Database - Frequently Asked Questions

How to import the SQL dump file

Here are two guides from other websites which will show you how to import the MySQL dumps into your MySQL server. You can ignore the "export" sections and just concentrate on the "import" sections of these articles.

We are working on our own guides for this. In the mean time we hope these links help.

The CSV file is too big!

Our database contains over 410 million user agents. Unfortunately normal spreadsheet programs like Microsoft Excel or Apple's Numbers App simply can't handle that many records in individual CSV files and so you won't be able to use them to work with our CSV export.

We are aware of several work arounds you can use:

Don't "open" the CSV with Excel, instead "connect" to it

The CSV of user agents has hundreds of millions of rows of data, which is far more than Excel is able to handle. As you may have already discovered, it's not possible to "Open" the CSV file in Excel like you might normally do. Instead, you can make Excel behave more like a proper database, by "connecting" it to the CSV instead of opening it. This causes Excel to only load the data you actually request from it.

There's a good tutorial on Officetuts.com to show you how to connect to CSV files with Excel. Hopefully this solves your problem.

Import the CSV into Microsoft Access or SQL Lite

In the event that you're not able to use a MySQL system, we've found that importing the CSV into Microsoft Access (on Windows PCs) works well. It lets you search and modify the data quite easily. You could also investigate using SQLite to import a CSV file if you don't have access to a full MySQL system.

Can I buy/get the user agents for just one browser/OS/platform?

We're sorry, there's no way to buy or download user agents for just one browser, operating system or platform. You'll need to download the whole database, import it into a database system and extract the user agents you need.

This is because the data set is so large and can be searched in so many different ways that it's really just not feasible for us to provide them all in seperate files.

It's actually pretty straight-forward to import the user agents yourself; and once you've got them in your database, you can search it again and again in as many different ways as you need.

Why is the Parquet file not compressed as a .tar.gz like the others?

Some customers requested that we share the parquet file uncompressed, as it simplifies their workflow - they don't need to extract it, they can load it straight in to their systems.

Please note that you are not allowed to access the .parquet file directly from our S3 bucket with your data analysis tools - you must still copy the file to your local machine or to your own data processing servers. We monitor access to the S3 bucket and will block this activity when it's detected.

Why are there lots of user agents created in October 2019?

In October 2019 we loaded a list of useragents provided to us by a customer. Unfortunately the dataset didn't include any meta data (eg the date that they first saw it) so we've had to set the day in October 2019 that we imported it as the creation date. There was also no "times seen" meta data in their dataset, so we started off setting the "times seen" as "1". Keep that in mind if you use this info for risk analysis or other types of statistics.

Why doesn't the database include the is_abusive/is_restricted/is_spam/is_weird fields?

Our user agent parsing library detects user agents which appear abusive/malcious, restricted (swear words etc), spammy or just plain "weird" and will tell you that via the API. This feature is great to help keep your systems and users safe.

However you won't find this information in the database dumps - this is because we use this information to prevent those user agents from being included in the database dumps. In other words, our database is "clean" and doesn't contain dangerous, restricted, spammy or weird user agents.

If you need to detect dangerous or spammy user agents then use our API instead. Remember, the database isn't for detecting user agents, it's for searching and finding groups/types of user agents.

Payment options

We accept MasterCard, VISA and AMEX payments for purchasing copies of the database.

We don't accept PayPal, or Bitcoin or other crypto-currencies.

Do you have a DUNS number, for US Government contracts?

Yes, if you are from a US Government Department and wish to buy a copy of the database, we have a DUNS number which can be used. We also have an NCAGE number. Please contact us for more information.