Importing data from a spreadsheet

If you already track your alliance in Google Sheets, Excel, or another tool, you don't have to re-type any of it. Last Command reads plain CSV and XLSX files with human-readable columns, so the data you keep today maps straight across.

• Roster — members with names, ranks, power (total, hero and squad), kills, HQ level, and aliases. New names become placeholder members on confirm; existing members are matched by name or Player ID so a re-import updates the same people.
• Event rankings — Alliance Duel (VS), Donations, Kills, Marshal's Guard, Sandworm Battle, and Zombie Siege, imported per date and written into every member's history.
• All-in-one workbook — a single XLSX with one tab per dataset (roster and every event). Fill in the tabs you have and commit the whole migration in one upload.

Importing your roster and event rankings from CSV is free — it's how you get your alliance set up, and we don't gate that. The all-in-one XLSX workbook, which commits every dataset in a single file, is a Pro feature.

• Free — roster CSV import, per-event CSV imports, and roster CSV export.
• Pro — the multi-sheet workbook import, and the full alliance workbook export that round-trips back through it.

Uploading writes alliance data, so imports are run by officers (R5/R4). Event-ranking imports in particular are officer-only.

1. 1

   Download a template

   Grab the CSV for the data you want to bring from the migrate page — no sign-up needed to download. Each template has the right columns and an example row. Pro users can grab the all-in-one workbook instead.
2. 2

   Fill it in (or paste from your spreadsheet)

   Type your data in, or copy it across from whatever you use today into the matching columns. Values are plain numbers (no commas or units) and dates are YYYY-MM-DD. Leave the Player ID column blank for new members.
3. 3

   Upload and preview

   Sign in as an officer and upload the file. Last Command shows you exactly what will be created, updated, or skipped — so you can catch a mis-mapped column before it touches your alliance.
4. 4

   Confirm

   Nothing is saved until you confirm the preview. New names become placeholder members; matched members have their history updated in place.

The templates use plain-English column headers — Name, Rank, Total Power, Kills, HQ Level — not internal field codes. You can read the file, edit it in any spreadsheet program, and hand it to another officer without a data dictionary. The same headers are used on the way out, so an exported file re-imports cleanly.

Import isn't a one-way door. You can export your roster to CSV (free) or a full alliance workbook to XLSX (Pro) at any time. Because exports use the same friendly headers as the templates, you can export, edit in a spreadsheet, and import straight back — a quick way to make a bulk change across the whole alliance.

• Up to 1000 rows per file.
• Up to 100 entries per date, per event.
• Upload caps of 5 MB for CSV and 10 MB for XLSX.

If your alliance is larger than a single file allows, split the data across a few uploads — each one runs through the same preview-and-confirm step.