Create Certificates in 5 Minutes on Canva

Through the Bulk Create feature available in Canva, users can merge data from Microsoft Excel files directly into certificate templates.

Article

Universitas Sumatera Utara (USU) continues to push for the acceleration of digital transformation to provide administrative services that are more modern, efficient, and responsive. One innovation now being implemented across various work units is the integration of Canva and Microsoft Excel for the automated creation of certificates in large quantities.

Traditionally, the certificate creation process was often done manually by editing each recipient's name one by one. This method was not only time-consuming but also prone to typing errors and design inconsistencies. With the increasing need for certificates for academic activities, seminars, training, and competitions, a more effective and standardized method is required.

Through the Bulk Create feature available in Canva, users can merge data from Microsoft Excel files directly into certificate templates. Data such as participant names, institutions, positions, or ID numbers can be filled in automatically based on pre-prepared columns. Consequently, hundreds or even thousands of certificates can be processed in a short time with uniform and professional results.

This process involves several simple steps:

1. Organizing certificate recipient data in Excel according to the required column format.
2. Uploading the Excel file to Canva via the Bulk Create feature.
3. Linking each data column to the relevant text section on the certificate design.
4. Generating certificates automatically and downloading them in the required format.

This method offers numerous benefits for the academic community (sivitas akademika), including time efficiency, reduced risk of errors, design consistency, and increased professionalism in event organization. Furthermore, this digital approach supports the university's efforts to provide modern administrative governance aligned with technological developments.

USU is committed to continuously encouraging digital adaptation across all work units, including in routine and mass administrative processes. By utilizing technologies like Canva and Excel, this transformation becomes a strategic step in creating a work environment that is efficient, innovative, and supportive of the academic community's productivity.