Others

Fix Microsoft Bookings Contact List Import Errors from Excel or CSV

Aamir Naveed AkramAamir Naveed Akram Oct 22, 2026 873 views

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.

Fix Microsoft Bookings Contact List Import Errors from Excel or CSV
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.
Before you start

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.

Solution 1Recommended

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.

1
Download the official template

Go to your Microsoft Bookings dashboard, select 'Customers' from the left menu, click 'Import customers', and download the provided CSV template.

2
Paste data without formatting

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.

3
Preserve template headers

Ensure you do not change, delete, or rearrange any of the column headers in the top row of the template.

4
Save as CSV UTF-8

Go to 'File' > 'Save As'. In the format dropdown menu, explicitly choose 'CSV UTF-8 (Comma delimited) (*.csv)' before uploading the file to Bookings.

Use and Format the Official Microsoft 365 Template Properly
Format Preserved: Keeping the exact column structure ensures Bookings parses your customer data without throwing format rejection errors.
Manage CSV Files

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. 1. Open your data in WPS Spreadsheet: Launch WPS Office and open your raw customer contact list.
  2. 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. 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. 4. Export as CSV: Click 'Menu' > 'Save As', and select 'CSV (Comma delimited)' to generate the final import file for Microsoft Bookings.
Seamless CSV UTF-8 encoding support to prevent Bookings format errors.High compatibility with Microsoft Excel formats (.xlsx, .csv).Powerful data cleanup tools to quickly remove duplicates and blank rows.Free and lightweight alternative to Microsoft Excel for bulk data management.
microsoft office alternative - wps office

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.