- Knowledge Base
- Troubleshoot
- Imports
-
Getting Help
-
12.3 Specific changes
-
Installation
-
Learn
- Business Activities
- Business Activity Manager
- Business Alerts
- Configuration
- Customer
- Database
- EDI
- General
- Inventory
- Manager Windows
- Mobile
- Picklists (Advanced Picking)
- Product
- Purchasing
- Purchase Order Manager
- QuickBooks & Acctivate Basics
- QuickBooks Desktop Sync
- QuickBooks Online Sync
- Reporting
- Sales
- Sales Order Manager
- Sales Tax
- Server
- Shipping
- Startup
- User Interface
- Webstore
-
Troubleshoot
-
Specs
-
FAQs
"Too many field defined." when importing a spreadsheet
When importing from an Excel file, you may receive the error "Too many fields defined." if more than 255 columns are in use.
When importing data from a spreadsheet, it's possible to receive the following error:
Cannot open spreadsheet. Make sure the file is in the Microsoft Office Excel Workbook format, the workbook is not protected, and you have the proper file permissions to read the data. The error was: Too many fields defined.
The Excel workbook may only have data in some columns, but there could be more than 255 columns. This sometimes happens when data has been deleted from columns, but the columns themselves remain without data.
To fix this
- Open the file in Excel
- Select all the blank columns that you do not need.
- Right click the selected column headers and choose "Delete"