Export Data
Export data from Piracymeter.
Once you have gathered data in Piracymeter, you can opt to export it in CSV.
Copyright infringing URLs can be exported via the Links (/link) or Reports (/report) pages.
1. Exporting Data from Links
To export links from the Links page, first select your project, then use the Export button to download the links in CSV format. This option allows you to export all the links related to a specific project.
2. Exporting Data from Reports
On the Reports page, you will have the opportunity to select one or multiple projects, as well as the time period for which you want to export the data.
Please take note of the limitations regarding the number of rows in Excel. Excel can support up to 1,048,576 rows. If your file exceeds 300k rows, it will be queued until it is created. You can close the page and return to it later to download the file. The link to the file will be available on the Reports page.
3. Report Contents
The exported file will contain the following information for each link:
ID: Link ID
Project: Project name
Link: Copyright infringement URL
Source: Search engine domain where the URL was detected. For example, google.de for Germany.
Search Query: This is the phrase used for the search.
Search Region: This is the country of the search query.
Search Language: This is the language of the search query.
Position: This is the ordinal number in the search output. For example, 1 means that the link was found in the first position for the specified search query and country.
Detected Time: The detection time in DD:MM:YY HH:MM format, e.g. 23.7.23 6:25.
Domain: The domain of the copyright infringement URL.
4. Opening a CSV File in Excel
To open CSV data with Excel, follow these steps:
Open Excel.
Click the Data tab.
In the Get & Transform Data group, click From Text/CSV.
In the Import Data dialog box, locate and select the CSV file you want to open, and then click Import.
In the Text Import Wizard dialog box, select Delimited, select the Unicode (UTF-8) and click Next.
In the Step 2 of 3 dialog box, select Comma as the delimiter and click Next.
In the Step 3 of 3 dialog box, review the data preview and make any necessary changes to the data format.
Click Finish to import the CSV data into Excel.
Once you have imported the CSV data into Excel, you can save the Excel file as a regular Excel workbook (.xlsx). This will make it easier to edit and analyze the data in Excel.
5. Opening a CSV data with Google Drive
You can easily open and work with CSV files using Google Sheets within Google Drive. Here are the methods:
Method 1: Direct Import
Upload the CSV:
Click on "+ New" -> "File Upload".
Locate your CSV file and select "Open".
Open with Google Sheets:
Once the file is uploaded, right-click on it.
Select "Open with" -> "Google Sheets".
Method 2: Import into an Existing Sheet
Open a Google Sheet: Create a new Google Sheet or open an existing one.
Import Option:
Go to "File" -> "Import".
Upload your CSV:
In the "Upload" tab, select your CSV file from your computer or Google Drive.
Import Settings:
Choose how to import the data (e.g., create a new spreadsheet, replace an existing sheet).
Click "Import Data".
Google Sheets will import the CSV data into a new spreadsheet.
Once you have imported the CSV data into Google Sheets, you can save the spreadsheet as a regular Google Sheets file (.gsheet). This will make it easier to edit and analyze the data in Google Sheets.
Last updated
Was this helpful?