Hello world!

Welcome to WordPress. This is your first post. Edit or delete it, then start writing!

  1. Hi, this is a comment.
    To get started with moderating, editing, and deleting comments, please visit the Comments screen in the dashboard.
    Commenter avatars come from Gravatar.

Comments are closed

File Type Description
CSV Comma-Separated Values
XML Extensible Markup Language (nested)
XLSX Microsoft Excel Format
JSON List of JSON elements (nested)
geoJSON geoJSON file format - basically the same as the JSON version but made for mapping software. All localities are represented as POINTS.
SQL Text file containing INSERT statements for TABLE, COLUMNS and DATA.
Types used - VARCHAR, TEXT, NUMERIC, BIGINT, JSONB.
All columns are unconstrained.
Compatible with Postgres, SQL Server 2022, Azure...

Alternative column INSERT commands are also included for databases that aren't happy with the above types or lack of constraints:
Types used - VARCHAR, NUMERIC, BIGINT. All columns constrained to maximum size\/length occuring in the table.

If neither work for your specific database software then the CSV might be your best option.