LogoLogo
WebsiteCommunity
  • Overview
    • Introduction
    • How to use it? In 5 steps
  • Importer
    • React Embed
    • Angular Embed
    • Bubble.io Embed
    • HTML & JS Embed
    • Text Customization
    • Directly Enter your Data
    • Select Header Row
  • Data Retrieval
    • Using Webhook
    • Using Frontend Callback
  • Validations
    • Base Validations
    • Advanced Validations
  • Features
    • Data Seeding
    • Import Excel with Image
    • Automated Import
    • Runtime Schema
    • Custom Validation
    • Default Value
    • Column Description
    • Freeze Columns
    • Multiselect Dropdown
    • Output Customization
  • Platform
    • Email Alerts
    • Activity Page
    • Manage Project
    • Make Your Team
    • How subscription works?
  • Additional Resources
    • FAQs
    • Architecture
    • Data Migrations
    • Selfhost Impler
    • Run Impler locally
    • Writing effectively into .xlsm files
  • Changelog
Powered by GitBook
On this page
  • How do I enable Image upload in Import?
  • How does Image Import work?

Was this helpful?

Edit on GitHub
Export as PDF
  1. Features

Import Excel with Image

Impler allows importing data files with images. Image import is useful in scenarios like Employee data with profile photos, Products with images, or Assets with pictures.

PreviousData SeedingNextAutomated Import

Last updated 6 months ago

Was this helpful?

Excel with the Image Import feature is available in the Scale plan only. Feel free to contact us if you want to try it out!

How do I enable Image upload in Import?

The first step for image import is to add or update a column with the Image type. In case providing Runtime Schema keep column type as Image and importer will be ready to import images.

How does Image Import work?

Once the import is configured to import data with Image. We can start importing data with Images. Here is the image import flow,

1. Generate a Template with Images,

The first step is to upload all images and generate a template with uploaded image names. All columns with the type Image will appear in Select Column dropdown and Uploaded images will be shown below Upload Image section.

Once all image files are selected, click on Generate Template to generate an Excel file holding the names of all uploaded images.

2. Upload Excel with data and image names.

Clicking on Generate Template will download an Excel file and Importer will move to the Upload section. You can enter data in the downloaded Excel file and select image names for image columns.

It's possible to generate a template again by clicking on Generate Template.

Once selected click on Map Columns.

3. Do mapping for columns

Click on Review Data to verify data getting imported.

4. Review Data

The review step checks if image columns contain the name of the uploaded image. If not shows a validation error.

Click on Re-Review Data to complete the import, once all records are valid.

5. Complete Import

6. Get Imported Data

Imported data will be sent to a webhook with an endpoint to download and access the uploaded file.

7. Download or Access the uploaded file

The download file endpoint is secured using accesskey which is available in Settings section on the left side. Here is the CURL for a review,

curl --location --request GET 'https://api.impler.io/v1/upload/66b759d087a854c817cd3e98/asset/logo-icon.png' \
--header 'accesskey: <ACCESS_TOKEN>'
Add Column with Type Image
Upload Images and Generate Template
Upload data file with image cell values
Do and verify mapping for columns
Review data getting imported
Data Imported Confirmation
Import Webhook Response

If you have any questions, suggestions, or comments. Feel free to reach out to us over . We’re constantly improving to deliver the best Data Importer for your product, and we value your input.

Discord