📸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.
Excel with the Image Import feature is available in the Scale plan only! Feel free to reach out in case 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,
Have any doubts? Shoot us a message directly on Discord.
Last updated
