Import Excel files - advanced settings

See the advanced settings to Import Excel files in Productsup.

What is an Excel Spreadsheet and how do I import one?

An Excel spreadsheet is a spreadsheet file format used by Microsoft Excel. It has an XLSX format.

You can import your Excel files via URL or via a local upload.

Import an XSLX spreadsheet

If your file is created with the .xslx extension, you will enable an additional setting to import it correctly.

You can import XSLX spreadsheets via the Feed URL or local upload data source using the following steps:

  1. Go to Data Sources from your site's main menu.

  2. Set up your Feed URL or local upload data source.

  3. Select the settings wheel for your data source.

  4. Select the Advanced Settings tab.

  5. Select I/O Settings.

  6. Add the transform Excel (XSLX) to CSV option found under the available I/O settings section.

    excel_io.png
  7. Enter the name of the sheet you wish to import under the sheet name field.

  8. Select Save.