How to place a meal voucher order using a CSV (Excel) file?

On Swile, you can place your meal voucher orders by adding your recipients and the number of days to be credited manually, or via a CSV file. Here’s how to do it using a CSV file:

  • Go to your meal voucher admin area
  • Click on New order
  • Click on Import via file at the top right. Then, you have two options: 

1) You can use the template provided by Swile. In this case: 

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

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

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

💡 You must specify the HRIS and/or payroll software when uploading an order file (CSV/Excel). 👉 This information is mandatory and self-declared, and it allows you to continue with your order.

✅ This choice is saved for future orders: you’ll only be asked once.

Finally, choose the date you want your recipients to be credited with meal vouchers, select your payment method, and click on Finalise my order!

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

Here are some tips for filling in your file:

TITLE Write out MR or MRS in full
FIRST NAME/SURNAME No accents (special characters are not allowed)
EMAIL Enter only one email per recipient
DATE OF BIRTH Day/month/year
FACE VALUE Amount in Euros (do not write "euros" or the € symbol)
DELIVERY POINT ID Only fill in if you are in charge of ordering cards for your recipients (unlike: Create a recipient and let them order their own card). Enter D for home delivery, otherwise it will be delivered to the default delivery point
ADDRESS

Our labelling limits this to 38 characters

Use the address line 2 if needed.

EMPLOYEE NUMBER Unique identifier to easily distinguish each recipient (not required)
MEAL VOUCHER SUNDAY Write YES only for people working on that day
ORDER PHYSICAL CARDS

Write YES if, as the administrator, you want to order the cards.
Write NO if you want your recipients to order their own card.

👩‍💻 You can enter YES and NO in the same file, depending on the recipient. 
📌 Important: Once recipients are created, for your next CSV file order, this column will show NO by default (even if you previously entered YES). Don’t worry, this is just a display and does not affect your existing recipient. You can leave it as NO or delete the text. You can also remove the column if you don’t need to add a new recipient. 

 

🧐 Found any errors? 

If, after importing, you see error messages, we’ll show you exactly which line the error is on so you can fix it. Edit it directly in your file, save it again, and re-import it.

You have not found an answer to your questions?

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

Was this article helpful?
34 out of 61 found this helpful

Comments

0 comments

Article is closed for comments.