Fix Microsoft Bookings Contact List Import Errors from Excel or CSV
Question details
Users are experiencing issues when importing customer contact lists via Excel or CSV into Microsoft Bookings, resulting in missing records or file rejection errors.

- Product
- Microsoft Bookings
- Device & OS
- not provided
- Scenario
- Importing a large customer contact list into Microsoft Bookings.
- Observed behavior
- The import process either rejects the edited CSV/Excel file or reports a successful completion but only displays a fraction of the imported records in the Bookings dashboard.
Ensure your contact list is saved in a standard UTF-8 CSV format, and verify that you have administrative access to your Microsoft Bookings calendar to perform bulk customer imports.
Use and Format the Official Microsoft 365 Template Properly
Microsoft Bookings is strict about file formats. Using the official template and preserving its exact structure prevents file rejection and missing data.
Microsoft Bookings requires specific column headers to map customer data correctly. If you create your own Excel file or alter the template's headers, the system will reject the file.
Additionally, hidden formatting in standard Excel workbooks can cause CSV conversion errors. Pasting your data as plain values into the official template is the safest approach.
Go to your Microsoft Bookings dashboard, select 'Customers' from the left menu, click 'Import customers', and download the provided CSV template.
Open your original contact list in your spreadsheet software. Copy the customer data, then open the official template. Right-click the first empty cell under the appropriate header and select 'Paste Special > Values' to avoid bringing over unsupported formatting.
Ensure you do not change, delete, or rearrange any of the column headers in the top row of the template.
Go to 'File' > 'Save As'. In the format dropdown menu, explicitly choose 'CSV UTF-8 (Comma delimited) (*.csv)' before uploading the file to Bookings.

Split Large Imports into Smaller Batches
Large imports often timeout or hit backend limits in Bookings, causing only a fraction of customers to appear despite a 'success' message.
Prepare Your Bookings CSV Files Flawlessly with WPS Office
WPS Spreadsheet provides a robust and user-friendly interface to manage, clean, and format your large customer lists before importing them into Microsoft Bookings.
- 1. Open your data in WPS Spreadsheet: Launch WPS Office and open your raw customer contact list.
- 2. Clean your contact data: Use the 'Data' tab tools to highlight duplicates and ensure all required fields (like Name and Email) are properly filled.
- 3. Transfer to the Bookings template: Copy the cleaned data. Open the official Bookings template in WPS Spreadsheet, right-click, and choose 'Paste Special -> Values'.
- 4. Export as CSV: Click 'Menu' > 'Save As', and select 'CSV (Comma delimited)' to generate the final import file for Microsoft Bookings.

Frequently Asked Questions
Why does Microsoft Bookings say my import is complete, but I only see a few hundred customers?
This usually happens due to background processing limits or timeouts in Microsoft Bookings when handling massive lists (e.g., over 10,000 records). Splitting the file into smaller batches of 500-1,000 records typically resolves this data dropping issue.
Can I use my own Excel spreadsheet instead of the Bookings template?
No, Microsoft Bookings requires specific column headers and structures to map the customer data correctly. You must copy your data into the official Bookings CSV template for a successful import.
Why am I getting an error when saving my Excel file as a CSV?
This can happen if your Excel file contains multiple sheets, complex cell formatting, or macros. Ensure you are only saving the active sheet containing plain text data, and select the 'CSV UTF-8 (Comma delimited)' format from the save menu.
Does WPS Office support saving files in CSV UTF-8 format?
Yes, WPS Spreadsheet fully supports saving and exporting documents in CSV format with UTF-8 encoding, ensuring your spreadsheet data is ready for upload to Microsoft Bookings without character encoding errors.




