How to place an order using a csv file (Excel)

On Swile, you can place your orders by manually adding your beneficiaries and the number of days to be credited, or by CSV file. Here's how to do it using CSV:

Go to your meal vouchers administrator area

  • Click on New order
  • Click on Import via file in the top right-hand corner. There are then two possibilities:

1) Either you use the template provided by Swile. In this case :

  • Select the data you need and click Generate import file. A file will be downloaded to your computer.
  • Fill in the file and save it on your computer.

2) Or you use a file downloaded from a compatible HRIS (Payfit, Lucca...). In this case :

  • Click on Import an existing file
  • Import the file provided by your HRIS

Finally, choose the date on which you would like your beneficiaries to be credited with meal vouchers, your payment method and click on Finalise my order!

 

✍️ How do I fill in and import the file?

Here are a few tips for filling in your file:

 

GENDER

Please write MR or MME in full

FIRST NAME/LAST NAME

Without accents (special characters are not permitted)

EMAIL

Only one email per beneficiary

DATE OF BIRTH

Day/month/year

FACIAL VALUE

Amount in Euros (do not use ‘euros’ or the abbreviation €)

DELIVERY POINT ID

To be filled in only if you are in charge of ordering cards for your beneficiaries (as opposed to: Create a beneficiary and delegate card ordering to him/her). Enter D if home delivery, otherwise it will be the default delivery point.

ADRESS

Our labelling requires us to limit the number of characters to 38.

Use the additional address if necessary.

VENDOR

Unique identifier for easy identification of each beneficiary (not compulsory)

Meal vouchers day off

Write YES only for people working on that day

 

🧐 Finding errors?

If you receive an error message after importing, we'll tell you which line contains the error you need to correct. Modify it directly on your file and then save it again to import it.

You have not found an answer to your questions?

You have not found an answer? Don't worry, send us a message

Submit a request
Was this article helpful?
1 out of 3 found this helpful