4.2 Importing from Excel

Importing data from Excel is as easy as importing from a CSV file.

Configuring an Excel import

Databridge supports *.xlsx resources out of the box. All you need to do is specify the worksheet name and the sheet to use in the resource descriptor for your import project:

{
  "name": "charities-resource",
  "resource": "import/excel/charities.xlsx",
  "sheet": "Sheet1"
}

In fact, the only difference between an Excel import and a CSV import is the resource descriptor. In other words, you can export your spreadsheet to CSV, change the resource descriptor accordingly, and the import will run identically.

Note: Currently it is not possible to import data from more than one sheet at a time.

Example

The charities demo provides an example of an import from Excel.