WikiQuick · CSV → QuickStatements

Paste or upload your data

Copying from Excel or Google Sheets uses tabs as separators. For CSV, the tool detects , ; and tab automatically.

Formatting guide

Column headers: The first row holds the property IDs (P31, P569…) or the reserved names below. A column named qid sets the item to edit; leave it empty to create a new item (CREATE).
Labels, aliases, descriptions: Lit Len Lfr Lde (labels), Ait Aen … (aliases), Dit Den … (descriptions). Multiple aliases in one cell are separated by | and become separate entries.
Sitelinks: itwiki enwiki frwiki dewiki commonswiki itwikisource enwikisource. The page title is used as-is (underscores become spaces).
Monolingual text: Header pattern Pxx_MONO_it — the language code goes in the header, the value in the cell. Produces it:"…".
Dates — point in time: Full dates: 1523, 1523-06, 1523-06-15 (also 15/06/1523). Partial dates use X for the unknown trailing digits: 152X (decade), 15XX (century), 1XXX (millennium). The precision is inferred from how many digits are known — this stays a point-in-time value, not an EDTF string.
Dates — EDTF: Free date forms are normalized to YYYY-MM-DD when recognized (15 Jan 2024, 2024/03/07). The output is a quoted string. Unrecognized values are passed through unchanged.
Numbers, coordinates, items: Numbers accept a comma or dot decimal separator. Coordinates: latitude,longitude. Items: a QID (Q42) or a full entity URL.
Qualifiers: Columns whose header starts with S (e.g. S1) attach as qualifiers to the statement immediately before them in the row.
Type suffixes: Force a type from the header: _STR _NUM _DATE _EDTF _GEO. Any other column lets you pick the type in step 2.

Set the type for each column

Columns will appear here once the data is read.

Copy the result