BSC Designer reads the file and shows the list of available spreadsheets. Choose a spreadsheet from the list and click the Next button.
On the next step mark the column that contains values, the column that contains dates, the column that contains target values (if any), and so on.
Click the Next button to preview the results.
To reuse this import profile later check the Save settings as ... check box. Click the Finish button to finalize data import.
Troubleshooting
Date is not recognized. Dates might be represented in PC using different formats like yyyy-MM-dd (2016-10-23) or dd MMM yy (23 Oct 16). BSC Designer is able to recognize most formats, but sometimes you might need to specify date format manually. To do this use the "Date format" drop list. Use one of predefined formats; advanced users might want to define their own format (format guidance).
I'm using import profile and the data is not correct. Most likely you have updated the structure of your Excel Spreadsheet, so BSC Designer cannot recognize columns and rows according to the information saved in a profile. Do a manual import once again and create a new import profile.
I see data on preview step but I don't see it on KPIs tab. If the data was displayed correctly on the "preview" stepit means that BSC Designer has recognized the data and its formats. Make sure that when you are searching for the data on KPIs tab and that you choose a correct KPI and a correct date in the calendar.