Manual CSV/Excel Import¶
If you don't use a supported PMS, or need to import bookings from another source, you can upload a CSV or Excel (.xlsx) file directly.
Supported file formats¶
| Format | Extensions | Notes |
|---|---|---|
| CSV | .csv |
Comma or semicolon delimited |
| Excel | .xlsx, .xls |
First sheet is used |
European CSV files
Many Portuguese and European systems export CSV files using semicolons (;) as delimiters instead of commas. FaturaSync detects this automatically — no configuration needed.
How to upload¶
- On the main dashboard, select Manual Upload as your import source
- Click Upload and choose your file
- FaturaSync reads the file and displays the data in the booking table
Column mapping¶
FaturaSync automatically detects common column names. If your columns don't match exactly, you can map them manually.
Recognized column names include:
| Field | Accepted column names |
|---|---|
| Guest name | Guest, Name, Guest Name, Cliente |
| Check-in | Check-in, Checkin, Arrival, Data Entrada |
| Check-out | Check-out, Checkout, Departure, Data Saída |
| Amount | Amount, Total, Price, Valor, Montante |
| Platform | Platform, Channel, Source, Canal |
Column headers matter
Make sure your file has a header row. FaturaSync uses the first row to identify columns.
Number formats¶
FaturaSync handles European and international number formats:
| Format in file | Interpreted as |
|---|---|
1,256.00 |
1256.00 (international) |
1.256,00 |
1256.00 (European) |
1256,50 |
1256.50 (comma decimal) |
1256.50 |
1256.50 (dot decimal) |
Preparing your file¶
For the smoothest import, your file should include at minimum:
- Guest name — Who the booking is for
- Check-in date — Arrival date
- Check-out date — Departure date
- Amount — The total booking value
Optional but useful:
- Platform/Channel — So FaturaSync can apply the correct commission
- Commission amount — If you want to provide it directly instead of using percentage-based calculation
Troubleshooting¶
- File won't upload — Check that it's a
.csv,.xlsx, or.xlsfile - Dates look wrong — Ensure dates are in a recognizable format (DD/MM/YYYY, YYYY-MM-DD, or similar)
- Amounts are incorrect — Check for mixed number formats within the same column
- Empty table after upload — Verify the file has data below the header row