Skip to main content

Import custom fields via CSV or Google Sheets

Add custom data fields like Store Number or Manager Name to locations through import.

Custom fields let you store extra information on each location that doesn't fit the standard fields (like a store number, manager name, or product availability).

Column format

Add a column with this exact format:

Field: Store Number

Replace "Store Number" with your field name. The cell value is the data for that location.

Example CSV

name, address, Field: Store Number, Field: Manager
Store 1, 123 Main St, S001, John Smith
Store 2, 456 Oak Ave, S002, Jane Doe

Multiple fields

Add a separate column for each custom field. Each column header must start with Field: followed by the field name.

Auto-creation

If a field name doesn't exist in your project yet, StoreRocket creates it automatically during import. You can find your fields under Location Data > Custom Fields.

Important notes

  • The column header format must be exact: Field: Name (with the space after the colon)

  • Field values can be any text

  • If a location doesn't have a value for a particular field, leave the cell empty

  • Works the same for both CSV import and Google Sheets sync

  • When you upload a CSV or Excel file at Location Data > Import, StoreRocket reads Field: columns automatically. A column without the Field: prefix isn't read as a custom field. It appears under To match, where you can only choose StoreRocket's built-in fields or Leave it out. Rename the column in your file and upload it again

  • In a CSV or Excel upload, fields already on a location stay as they are when your file has no column for them

Custom fields vs search filters

  • Custom fields display information but can't be used for filtering/searching

  • Search filters let visitors filter locations by category

If you want visitors to be able to search by a value (like "Has Drive-Through"), use a filter instead.

Questions? Message us on live chat.

Did this answer your question?