# CSV Exports Both tally reports and ballot count reports can be exported in comma-separated values (CSV) format. ## Tally Report CSV Structure In the CSV tally report, the vote total for each candidate or contest option is listed in a single row. In addition, there are rows for overvote and undervote totals for a contest. For example, here is an excerpt of a tally report including the results for one contest: ```csv Precinct,Precinct ID,Contest,Contest ID,Selection,Selection ID,Total Votes West Lincoln,20,Mayor,mayor,Sherlock Holmes,sherlock-holmes,0 West Lincoln,20,Mayor,mayor,Thomas Edison,thomas-edison,0 West Lincoln,20,Mayor,mayor,Write-In,write-in,0 West Lincoln,20,Mayor,mayor,Overvotes,overvotes,0 West Lincoln,20,Mayor,mayor,Undervotes,undervotes,0 ```

Formatted version of the above CSV excerpt

The "Precinct" and "Precinct ID" columns are [metadata fields](#shared-metadata-structure) that are included because this example export groups results by precinct. The other fields are standard fields:

Header	Values
Contest	The title of the contest
Contest ID	The internal identifier of the contest in the election definition
Selection	The candidate name for candidate contests, the option label for yes-no contests, or "Overvotes" or "Undervotes"
Selection ID	The internal identifier of the contest option, or "overvotes" or "undervotes"
Total Votes	The vote count for the selection

If manual results were entered, two additional columns will be added - "Scanned Votes" and "Manual Votes." These columns denote which votes for each selection came from the scanners vs manual entry. The results of write-in adjudication are always included in the CSV exports. All write-in candidates will appear with their adjudicated name and a UUID assigned by VxAdmin. Unadjudicated write-in candidates will appear as "Unadjudicated Write-In" with the ID "write-in". Unlike in the printed reports, write-in candidates are never consolidated. ## Ballot Count Report CSV Structure The ballot count report CSV is the same as the table presented in the [printed ballot count reports](/vxsuite-tdp-v4/system-overview/vxadmin-results-exports/ballot-count-reports.md). For example: ```csv Precinct,Precinct ID,Voting Method,Total West Lincoln,20,Precinct,0 West Lincoln,20,Absentee,0 East Lincoln,21,Precinct,0 East Lincoln,21,Absentee,0 South Lincoln,22,Precinct,0 South Lincoln,22,Absentee,0 North Lincoln,23,Precinct,0 North Lincoln,23,Absentee,0 ```

The "Precinct", "Precinct ID" and "Voting Method" columns are [metadata fields](#shared-metadata-structure) that are included because this example export groups results by precinct and voting method. The "Total" field is a standard field on all ballot count CSV exports, but other ballot or sheet count fields may appear depending on the election and loaded results:

Header	Values
Manual	The ballot count of manually entered results.
Scanned	The count of all ballots loaded as cast vote records. The field appears if there are manual ballots or if the election is multi-sheet. In a multi-sheet election, this is the count of the first sheet.
Scanned Sheet {N}	The count of a subsequent ballot sheet. The count of the second sheet of all ballots would be "Scanned Sheet 2".
Total	The total ballot count.

## Shared Metadata Structure Any filters or groupings which apply to each row will be indicated in the row itself by metadata columns. For example, in the example export above, the "Precinct" column lists which precinct group each row represents. If a row is filtered by a single attribute value (e.g. represents one precinct rather than multiple precincts) then the following basic metadata fields are used:

Header	Value
Precinct	The name of the precinct
Precinct ID	The identifier of the precinct from the election definition
Party	The short name of the party e.g. "Republican". Included by default if the ballot style is included, in a primary.
Party ID	The identifier of the party from the election definition
Ballot Style ID	The identifier of the ballot style
Voting Method	"Absentee", "Precinct", or "Provisional"
Scanner ID	The serial number of the scanner. Included by default if the batch is included.
Batch	The label of the scanned batch
Batch ID	The scanner-assigned UUID of the scanned batch

If a row is filtered by multiple attribute values, the following columns may be used:

Header	Value
Included Precincts	The precinct identifiers separated by commas
Included Parties	The party identifiers separated by commas
Included Ballot Styles	The ballot style identifiers separated by commas
Included Voting Methods	The voting method labels ("Precinct", "Absentee", or "Provisional") separated by commas
Included Scanners	The scanner serial numbers separated by commas
Included Batches	The batch identifiers separated by commas

In cases as above, where a row value includes comma-separated values, those values will be wrapped in quotation marks per typical CSV formatting in order to allow consumers to properly differentiate columns. --- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://docs.voting.works/vxsuite-tdp-v4/system-overview/vxadmin-results-exports/csv-exports.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.