Import spreadsheet notes
This topic explains how to format your spreadsheet data so it imports correctly into Asset Panda Pro. Before importing, confirm that the values in your spreadsheet match the formats described here for each field type. Most import errors are caused by formatting mismatches.
Formatting notes
Supported file types: CSV (.csv) and Excel (.xlsx)
Header row: Your spreadsheet must include a header row with column names that match the field names in your collection. You can choose which row (1–10) contains your headers during the import process.
Required fields: Any field marked as required in your collection must be included in your spreadsheet and have a value in every row.
System fields: System-generated fields (such as Created Date or Modified Date) cannot be updated through imports.
Date & Time fields
Date fields are one of the most common sources of data import errors. To avoid issues, your spreadsheet dates must match the Date format configured for the field in your collection.
To check your field's date format, access the field's settings and review the Date format setting.
Supported date formats
MM-DD-YYYY
MM/DD/YYYY MM/D/YYYY M/D/YYYY
03/15/2024 02/5/2025 3/15/2026
MM-DD-YYYY
MM-DD-YYYY MM-D-YYYY M-D-YYYY
03-15-2024 02-5-2025 3-15-2026
DD-MM-YYYY
DD/MM/YYYY D/MM/YYYY D/M/YYYY
15/03/2024 5/02/2025 15/3/2026
DD-MM-YYYY
DD-MM-YYYY D-MM-YYYY D-M-YYYY
15-03/-2024 5-02-2025 15-3-2026
If your spreadsheet does not support a listed date format, you can format the cells at Text in the spreadsheet and enter the date in a supported format.
If your field expects MM-DD-YYYY but your spreadsheet has DD-MM-YYYY, the values may be swapped. For example, 03/05/2024 could be read as May 3rd instead of March 5th during the import.
Input types
Based on the date field's Input type, you may need to provide a date, a time, or both:
Date only: Enter only the date in the format configured on the field. For example:
03/15/2024Date & Time: You must enter both the date and the time (in 12-hour format with AM/PM). For example:
03/15/2024 02:30:00 PMTime only: Enter the time in 12-hour format (with AM/PM) or 24-hour format. For example:
02:30:00 PMor14:30:00
The import uses the timezone from your user profile to process dates. Make sure your profile timezone is set correctly before importing, especially if your spreadsheet contains times.
Currency fields
Currency values should be entered as numbers. You can optionally include a currency symbol at the beginning.
Accepted formats
Plain number
1234.56
Yes
With symbol
$1,234.56 / £100 / €0.99
Yes
Negative value
-$50.25
Yes
Text currency code
USD 100
No
Trailing text
1,234.56 USD
No
Currency rules
Currency symbols only: You can use symbols, such as
$,£,€,¥, or₹. Text codes (for example, USD or GBP) are not supported.Thousands separators: Commas can be used to groups of three digits (for example,
1,234,567). Spaces or periods are not supported.Decimal separators: Period (.) is the only supported decimal separator.
Phone number fields
Phone numbers can be entered in several common formats.
If you are using the native CSV import (not OneSchema), phone numbers are accepted in any format.
Digits only
5551234567
With dashes
555-123-4567
With dots
555.123.4567
With parentheses
(555)123-4567
With plus sign
+5551234567
With country codes
+15551234567
You should avoid spaces between digit groups (for example, 555 123 4567) or full contry codes with spaces (for example, +1 555 123 4567).
Pull From fields (Parent/Child Relationships)
Pull From fields link records in your collection to records in another collection or category. Issues can occur when importing into these fields.
Pull From field types
When you configure a Pull from another collection field, two types of fields are created:
Primary (parent) field: The main lookup field that contains the value the system uses to find the matching record in the related collection.
Secondary (child) fields: The additional fields that automatically populate with data from the matched record. You do not need to enter these values manually because they are populated after the primary field finds a match.
Import rules for Pull From fields
The primary (parent) field is required when importing secondary data. If you include any secondary (child) fields in your spreadsheet, the primary field must also exist and be filled. The system needs the primary field to identify the related record to look up.
You can import the primary field by itself. If you include only the primary field in your spreadsheet (and exclude the secondary fields), the system will look up the matching record and automatically populate all secondary fields after the import.
This approach is recommended for most imports.
If you include secondary fields, their values narrow the search. When both primary and secondary fields are included in the spreadsheet, the import searches for a record in the related collection that matches ALL of the values exactly before updating the record.
You can leave secondary field cells blank to avoid having to include them as matches.
The import lookup must find exactly one matching record. Otherwise, an error is logged:
No match is found: "pull from collection value does not match with any record"
More than one match is found: "pull from collection value match with more than one record"
Exact matches are required, so ensure that capitalization, spacing, and punctuation is formatted accurately.
For category references, the value must match the category name exactly. If the primary field refers to a category and the value in your spreadsheet does not match any Category value, an error is logged: "Mapped value does not exist"
Field types
Text
Any text value (up to 256 characters)
Laptop Model X
Long Text
Any text value (unlimited length)
Detailed description here...
Numeric
Plain numbers (decimals allowed)
1234.56 or -42
Percent
Number with optional % symbol
75 or 75%
URL
Full web address
https://www.example.com
Address
Single line of text, with commas between street, city, and state (no comma after state) Separate columns are not supported for city/state/zip.
123 Main St, City, ST 12345
GPS Coordinates
Latitude and longitude separated by a comma (for example, 33.4484,-112.0740)
Latitude: -90 to 90
Longitude: -180 to 180.
33.4484,-112.0740
Single Select List
Text that exactly matches one of the predefined options. New options are not created during import.
Active
Multiple Select List
Options separated by the pipe character (do not use commas). Spaces around the pipe are trimmed automatically.
Option A|Option B|Option C
IP Address
Standard IPv4 or IPv6 format
192.168.1.1
Auto-Increment
Cannot be updated via import (auto-generated)
—
Link to User
Email address of an existing, active user. The email search is not case sensitive.
Common import errors
"Invalid date format. Please use the format [format] for this column"
The date in your spreadsheet doesn't match the format configured on the field.
Check the field's Date format setting and adjust your spreadsheet to match.
"Primary field: [name] is not mapped"
You included a secondary (child) Pull From field but didn't map the primary (parent) field.
Add the primary field column to your spreadsheet, or remove the secondary field columns.
"pull from collection value does not match with any record"
The value you entered for a Pull From field doesn't match any record in the related collection.
Verify the value exists in the related collection. Check for typos, extra spaces, or capitalization differences.
"pull from collection value match with more than one record"
Multiple records in the related collection match your Pull From value.
Add more specific secondary field values to narrow the search, or make the primary field values unique in the related collection.
"Mapped value does not exist"
A category reference value doesn't match any existing category.
Check that the category name is spelled exactly as it appears in the system.
"Multiple records found matching field"
During an update import, the identifier field matched more than one existing record.
Use a more unique identifier field, or clean up duplicate values in your collection.
"No records matching duplicate field(s) found"
During an update import, no existing record was found matching the identifier field value.
Verify the identifier value exists in the collection. It must be an exact match.
"No user found"
A Link to User field value doesn't match any active user's email address.
Check that the email address belongs to an active (non-deleted) user in the module.
Last updated