SpecStream for Microsoft Excel

What you get

• Starts below your last rowNew matches go under the last row that holds data, in the worksheet and columns you matched, and a changed record rewrites the row it went to.
• ZIP codes keep their zerosEach cell is set to Text before the value goes in, so 02134 stays 02134 and a long registry number never turns into 1.2E+15.
• Your workbook on a mapLink a workbook of addresses from OneDrive or SharePoint and SpecStream puts every row on a map for free, then rereads the file daily for new rows.

Where it works

• Send to a workbookIn OneDrive or SharePoint, kept in sync.
• The Excel add-inComing soonA task pane to ask and import lists inside Excel.

Set it up

1. 1In SpecStream, open Connections, choose Microsoft Excel, and sign in with the Microsoft account that holds the workbook.
2. 2Pick the .xlsx file and the worksheet, then match each detail to a header in row 1, keeping one column for the export reference.
3. 3Read the preview of the first row, send, and turn on Keep sending so new matches join below and changed ones update their row.

The full setup guide has every step, with what to do if something doesn’t arrive.

• Google SheetsRows under your own headers, kept in sync
• AirtableRecords in your base, every detail in its own field
• NotionA page per match in your Notion database
• monday.comItems in the board group you pick
• SmartsheetRows at the bottom of your sheet, updated in place
• TrelloCards on your Trello board, one per match