Import and live data
Import new Excel rows without Unique IDs
Where
Import / export then Choose file to import
Let Prevue create IDs for new point or house records.
Steps
- Start with a current Prevue Excel export so the expected workbook structure is present.
- Add each new record to the appropriate Points or Houses worksheet.
- Leave Unique ID blank on new rows and fill the supported data fields.
- Import the workbook and check that those rows are listed as New in the review.
- Confirm the import, then re-export the workbook to obtain the generated IDs.
- Place any new points on the map and publish their placements.
Expected result
Prevue generates a new identity for each non-empty new row. Completely empty rows are skipped.
Tips and limits
Do not invent IDs for new records. Reimporting the same blank-ID rows as a new import creates additional records; use the re-exported IDs for later updates. Retrying the same import operation is protected separately against duplicates. Google Sheets has a different ID requirement.
Effect on the published viewer
New points start unplaced. They need a published placement to appear publicly.