Skip to content
Premium Feature

Import Excel with Image

In today’s fast-paced digital landscape, efficient data onboarding is crucial for businesses and developers alike. With Impler’s, “Import Excel with Image” feature you can transform how you onboard data that contain images.

Traditionally, importing data from Excel has been limited to rows & columns, often requiring separate processes for handling images. Now, with Impler, users can import Excel files with images in one process. Let’s explore how this functionality works.

Add Columns with Image Type

Create a new Import and add a column with the type “Image”.

Image Column

Start Importing with Images

The importer will ask for images from the user first. Users can upload all necessary images and Impler will generate an Excel file holding image names in respective image columns.

Start Importing with Images

Fill Data in the Generated Template

After selecting all images, an Excel file will be generated with image names in the image columns. The end user can fill data into the Excel file and upload it to the importer.

Fill Data in the Generated Template

Complete the Import

Users can now upload the filled Excel file in the Importer. The next steps look similar to the import process. Users can check mappings and if it seems correct they can review imported data. The review step shows throws errors if any records fail validation. For example, If a user has entered some random image name in the image column in the case also Impler will show an error to the user. Here, user can update their value or delete unwanted records.

Data Import Process

Imported Data will be sent to the application

Once all records are valid user can complete the import and sanitized data will be sent to the application Imported Data will be sent to the application receiving imported data, and the image column will have a link to the file uploaded by the user.

Imported and Sanitized Data along with image url
Documentation and Further Reading

For a more detailed technical overview and implementation guide for text customization in the Import Widget, please refer to our official documentation:

Build Powerful CSV & Excel
Importer
in 10 Minutes

Features Enhancing Data Import Experience

Impler Validation Hooks
Validation Hooks
Write your own validation logic to implement complex validations in importer. Even call your API to implement checks with data in the database.
Know More
Auto Import
Auto Import
Automatically on scheduled intervals import Data from various destinations without need for manually importing data every time.
Know More
Excel Template Generator
Excel Template Generator
Automatically generate excel template based on schema provided in importer. Validations included in the generated template.
Know More