1. Help Center
  2. Collaboration Features

How to export data from Plural

Export data from Plural for further reporting and analysis

To turn on closed captions, click the "CC" icon towards the bottom right of the video

Plural’s export feature allows you to export your bills of interest into a .csv file. 

To create an export, begin by clicking on the “Export” button found at the very bottom of the left sidebar menu in Plural.

red arrow pointing to export button in bottom left sidbar menu of Plural

In the “Export” pop-up window, depending on your permission levels, you can select whether to export:

  • All bills that your organization is tracking in Plural;
  • All bills that a particular Workspace is tracking in Plural;
  • Or all bills that have been assigned a particular tag.

bill export selection menu in Plural

You can also make multiple selections among each of these export options.

Once you have selected your export criteria, scroll to the bottom of the pop-up window and select “Next.” 

On the next screen that appears, you can select which bill properties to include in your export. The file will export as a .csv file that can be opened in Microsoft Excel or Google Sheets. The bill properties you select will be the column headers of your spreadsheet.

Once you have selected your bill properties for export, scroll to the bottom of the pop-up window and select “Export.”

bill properties selection menu in Plural

The exported .csv file of your selected bills will be listed sequentially and alphabetically by jurisdiction.

How to open a .csv file in Excel or Google Sheets

Excel

If the exported .csv file does not automatically open in Excel once downloaded, you can open Excel and then select File > Open. If you did not save the file to your desktop, you will find it in the "Downloads" folder of your computer. Select the file and then click "Open."

Google Sheets

1. Go to your Google Drive

2. In the top left corner of Google Drive, click the "New" button

top left corner of google drive menu

3. From the "New" menu select "File upload"

new menu in google drive

4. Select bill export file from your computer (if you did not save it to your desktop, it will be in the Downloads folder of your computer)

 

5. Once the file has uploaded, double click on it to open it in Google Drive

example of uploaded file listed in google drive

 

6. Once your file has been opened in Google Drive, click the "Open with" menu found in the top center of the page and select "Google Sheets"

example of exported bill file opened in google drive

 

7. Your file will now be opened in a separate Google Sheet and automatically saved to your Google Drive as a Google Sheet.

example of exported bill file in google sheets

list of exported bill files in google drive file list

Note: This feature is only available with premium plans. Explore plan options >>