As a first step, you'll convert your sales team’s customer spreadsheet into a FileMaker Pro database file. This is easy – just drag and drop!
Create a new FileMaker Pro database file from an Excel spreadsheet.
- Open FileMaker Pro.
If the Launch Center window opens, go ahead and close it – you don't need it for drag and drop.
- Locate the Landscaping.xslx spreadsheet file located in the Spreadsheet folder of your sample data.
- Drag the Landscaping.xslx spreadsheet file onto the FileMaker Pro icon in the dock (Mac) or the task bar (Windows).
The Specify Excel Data dialog box appears (this only happens when your spreadsheet has more than one workbook).
- Choose the Customers worksheet and click the Continue button.
The First Row Option dialog box appears.
- Choose the Field names radio button.
Use this option whenever your spreadsheet includes a header row that provides field names.
- Click the OK button.
The "Create a new file named:" dialog box appears.
- Locate the Save As field at the top of the dialog box.
FileMaker Pro suggests the filename Landscaping Converted.fmp12.
- Change the filename to Landscaping.fmp12.
This is the name of your converted file.
- If necessary, use the left-hand panel to navigate to the Desktop.
- Click the Save button in the lower right of the dialog box.
Your converted database file is displayed, showing your data similarly to how it appears in your spreadsheet.
If you’re used to Excel, you might expect to see record numbers down the left of the screen. FileMaker Pro doesn’t do this: the numbers you see in the first column are actual data, and depend on which records you are viewing.
Here is the same data as displayed in Excel and FileMaker Pro:
Congratulations, you have just created a new FileMaker Pro database file from a spreadsheet!
In the next section, you’ll learn to work with the data in this file.