Upload files to Wikimedia Commons. The Spreadsheet Way.
Pattypan is a desktop uploader that enables a high amount of flexibility when proper, detailed image descriptions are important for the images' reuse on Wikimedia projects.
Choose a user-generated wikicode for file description and license information;
It supports the input of wikicode in any field
It makes uploads from one source faster (all repetitive information needs only to be copied across)
It offers users a preview of the files' descriptions on Commons before uploading, and lists any errors or empty fields
The program generates a spreadsheet in a folder containing files to be uploaded. The users then select their desired description template/fields, and fill in the spreadsheet with relevant information (and wikicode where necessary).
It offers the option to deselect unnecessary fields, and to pre-fill selected fields for all files.
Screenshots
Basic requirements
Running. Pattypan uses the Java Runtime Environment (JRE) which can be downloaded for free on most platforms (Windows, Linux, Mac). Installing it requires administrator privileges on your system. Java 11 or higher is necessary for running Pattypan.
Pattypan can be downloaded as an EXE file for Windows. This includes the JRE and doesn't require Java to be installed separately. Note that this functionality is unofficial and not maintained by the Pattypan-team.
Editing. To edit the spreadsheet data, you will need to be able to edit an XLS file (different from more modern XLSX files). Editing XLS files can be done easily using the paid version of Microsoft Excel. There are some free options:
Both Microsoft Office and Google Docs have free spreadsheet editors, but export in the newer XLSX format only. You can find sites and utilities to convert from XLSX to XLS files.
