Flow.Documentation
BeginnerTables

Table from an Excel file

6 steps± 4 minVideoVerified 22 Oct 2026
  1. Step 1 · Open your development environment
  2. Step 2 · Choose the Excel file
  3. Step 3 · Choose the sheet with the data
  4. Step 4 · Check the kinds
  5. Step 5 · Classification and import
  6. Step 6 · Look at the table

Flow reads Excel files (.xlsx) too. If the file has several sheets, you pick the one with the data. Flow recognises dates, amounts, counts, yes/no cells and times from what Excel stores in them, whatever the language of the spreadsheet. You read in September's services, exported from the till.

Watch the whole guide as a video6 steps in one film
Step 1 / 6

Open your development environment

In the portal, under Environments, click Development, and there Open. Flow opens in a new tab and you are signed in straight away.

  1. Click Development
Open your development environment · Click Development
  1. Click Open ↗
Open your development environment · Click Open ↗
Step 2 / 6

Choose the Excel file

Click ＋ next to General, choose Table from a file and click the box to choose your .xlsx file (dragging works too). Flow opens the first sheet and shows what is on it.

  1. Click Add to General
Choose the Excel file · Click Add to General
  1. Click Table from a file (CSV/Excel)
Choose the Excel file · Click Table from a file (CSV/Excel)
  1. Click the box for your file
Choose the Excel file · Click the box for your file
Choose the Excel file · Two sheets; the first, Notes, is chosen.
Step 3 / 6

Choose the sheet with the data

The sheet Notes only holds an explanation. Under Sheet, click Servicing: Flow reads that sheet and counts the rows and columns. If the column names are not in the first row, untick First row holds the column names.

  1. Click Servicing
Choose the sheet with the data · Click Servicing
Choose the sheet with the data · 8 rows and 7 columns, with a sample.
  1. Click Next
Choose the sheet with the data · Click Next
Step 4 / 6

Check the kinds

Flow proposes a kind for every column based on its cells: dates become Date, a time Date and time, whole counts Whole number, amounts with cents Number and TRUE/FALSE Yes / no. If something is off, choose another kind yourself. Give the table a name.

  1. In Table name, type Servicing September
Check the kinds · In Table name, type Servicing September
Check the kinds · Date, Amount, Parts used, Paid and Pick-up each have their own kind.
  1. Click Next
Check the kinds · Click Next
Step 5 / 6

Classification and import

Choose how sensitive the data is (customer names and amounts: Internal) and go to Import. Every row is checked; a row that does not fit is skipped and reported, with its line number from your file.

  1. Click Next
Classification and import · Click Next
  1. Click Import
Classification and import · Click Import
Classification and import · ✓ 8 rows imported.
Step 6 / 6

Look at the table

Open the table: every column has the right input, such as a date picker and a tick box.

  1. Click Open table
Look at the table · Click Open table
Look at the table · The table counts 8 rows.
Look at the table · Pick-up is a date with a time, as in Excel.

This guide was carried out step by step on 22 Oct 2026 by an automated test on Flow (version 3e563176).