Import customer data from Excel

Web Level Basic Role Owner, Admin Module Import & Export Data About 10 minutes
Updated

This feature moves your customer list from an Excel or CSV file into the app. You do not need to type each name and phone number manually.

When to use it:

  • When you switch to Automan and want to bring in old customer data from previous books.
  • When you have a large list of new promotional contacts to add at once.

Good to know:

  • The file must be .xlsx, .xls, or .csv, up to 10 MB and 20,000 rows.
  • Only the Nama Lengkap column is required, while phone numbers are cleaned up automatically.
  • Each row counts as a separate customer without merging duplicate names.

Note

UI screenshots for this tutorial are on their way. You can still follow the guide through the menu, button, and field names given in each step.

Before you start

  • A customer list in an Excel or CSV file is ready on your computer.
  • Know the customer types your shop uses so you can match them during import.

Steps

  1. Open Mitra → Pelanggan then click Impor

    Click Mitra → Pelanggan in the left panel. Then click the Impor button to open the Impor Pelanggan page.

  2. Download the customer template file

    Click Unduh Template Ringkas or Unduh Template Lengkap. Open the file in Excel and copy your customer data into the matching columns.

  3. Upload the file to the box

    Drag your file into the Letakkan berkas di sini box. You can also click to pick a file from your computer. Keep the file under 10 MB.

  4. Match file columns with app columns

    Choose the matching name in the Kolom Automan dropdown for each file column. Columns marked with an asterisk are required before you continue to the next step.

  5. Set customer types for imported data

    Pick one customer type for every row. Alternatively, match the customer type column from your file to your store types.

  6. Check the customer data preview

    Check data rows in the preview table to spot wrong columns or incorrect details. Problem rows appear clearly before any data is saved.

  7. Click Jalankan Impor (Run Import)

    Click Jalankan Impor (Run Import). Wait until it finishes without closing the page. Tip: Change customer types before importing. Afterwards, you must edit them on the Pelanggan page.

  8. Return to Pelanggan and check new data

    Click Kembali ke Pelanggan and search for a few names from your file. Make sure their phone numbers and customer types show up correctly in the list.

What you end up with

All your customer data from Excel is now saved in the app and ready to select when recording transactions.

If something goes wrong

The file is rejected during upload

Make sure the file format is .xlsx, .xls, or .csv. Check that the file size is under 10 MB and has no more than 20,000 rows.

File columns do not match automatically

Open the Kolom Automan dropdown on that row and pick the right column name manually. You can also leave unused columns empty.

Phone number formats change in the preview

The app cleans up phone numbers automatically into a standard format. This is normal as long as the phone digits remain correct.

Customer data appears duplicated in the list

The app treats each row as a separate customer and never merges matching names. Remove duplicate rows in your Excel file before uploading again.

Wrong customer type selected during import

Go back to the previous step and change your selection before running the import. If data is already saved, fix customer types one by one on the Pelanggan page.