Object Creator for extending objects
Key Takeaway
When spreadsheet data must become records on a new custom object, use Lightning Object Creator ("Create > Custom Object from Spreadsheet"). It builds the object and its fields and loads the rows as records, so you don't create them by hand.
Lightning Object Creator is a low-code tool that turns a spreadsheet into a new custom object in Salesforce. The spreadsheet columns become the object's fields. The spreadsheet rows can also become records. You don't have to create the object and fields by hand and then fill in the data.
When to use Lightning Object Creator
Lightning Object Creator is the right choice when data already lives in a spreadsheet and the company wants that data in Salesforce without creating the object and fields manually. Supported files include Excel (.xlsx) files, .csv files and Google Sheets.
A volunteer coordinator at a food bank keeps shift sign-ups in a Google Sheet. Each row is one shift, with columns for Volunteer, Shift Date, Location and Hours. The coordinator wants the shifts in Salesforce as records on a new custom object. The slow way is to create a Volunteer Shift object, add each field by hand, and then load the rows. Instead, the admin runs Lightning Object Creator on the Google Sheet. The columns become fields on the new object. The rows become Volunteer Shift records.