LVD Import

Overview

The LVD Import screen allows partners to upload Excel files containing property and LVD data for bulk import into the system. It supports client-side Excel parsing, MMDA selection, data preview in table or kanban view, and row-level editing before submission.

Navigate to: Sidebar → LVD Import or Dashboard → Property Rate Import

LVD Import

Upload Section

Upload Area

Element	Description
File upload zone	Drag-and-drop or click to upload `.xlsx` or `.xls` files
MMDA selector	Dropdown populated from `GET /sys/allmmdalist` — select the target MMDA
Entry type toggle	Radio buttons: New Entry or Changed — indicates whether data is new or an update
Note field	Optional text field for import notes
Instructions panel	Contains a sample file download link and a Google Sheets template link

!!! info "Supported File Types" Only .xlsx and .xls Excel files are supported. The file is parsed client-side using the XLSX library — no data is sent to the server until the user clicks Submit.

Data Preview

After uploading a file, the parsed data is displayed for review before submission.

Table View

Displays all parsed rows in a standard table with sortable columns.

Kanban / Card View

Kanban View

Displays parsed data as a grid of cards for visual review.

Toggle between views using the view switcher.

Parsed Data Columns

The import preview displays 25 columns of property/LVD data:

#	Column	Description
1	Account No	Property account number
2	Block ID	Block identifier
3	Digital Address	Ghana Post digital address
4	Property Address	Full physical address
5	Zone	Zone classification
6	Use	Property use type (e.g. Residential, Commercial)
7	Rateable Value	Assessed rateable value
8	Rate Impost	Rate impost percentage
9	Min Rate	Minimum rate payable
10	Max Rate	Maximum rate payable
11	Property Owner	Owner full name
12	Owner Type	Individual or Organisation
13	Contact Number	Owner phone number
14	Email	Owner email address
15	ID Type	Identification type
16	ID Number	Identification number
17	Region	Region name
18	MMDA	Metropolitan/Municipal/District Assembly
19	GPS Address	GPS coordinates
20	Land Size	Property size in square metres
21	Assessment Type	Assessment classification
22	Property Type	Property category
23	Structure Type	Building structure type
24	Year	Assessment year
25	Exempted	Tax exemption status

Row-Level Actions

Action	Description
Delete row	Remove a single row from the preview before submission
Edit row	Modify individual cell values in the preview table

Submission

Element	Description
Submit button	Sends all preview data to `POST /lvd/lvdimport`
Cancel button	Discards the upload and returns to the empty import screen

Submission Payload

The submission includes:

MMDA — selected from the dropdown
Entry type — New Entry or Changed
Note — optional import note
Data rows — all parsed Excel data (25 columns per row)

Instructions Panel

The instructions panel provides:

Resource	Description
Sample file download	Download a template Excel file with correct column format
Google Sheets link	Open a Google Sheets template for data entry

!!! tip "Things to check" - .xlsx and .xls files are accepted; other file types are rejected with a clear error - Large Excel files (1000+ rows) parse without freezing the browser - MMDA dropdown loads all available assemblies from GET /sys/allmmdalist - Changing MMDA selection after upload correctly updates the submission payload - Toggle between New Entry and Changed persists correctly through submission - Deleted rows are excluded from the final submission payload - Table and kanban views show identical data - The Note field is included in the submission payload even when left blank - Submit button is disabled until a file is uploaded and MMDA is selected - After successful submission, the import screen resets to its initial state