How to use GISGP
Everything you need to import, export and work with ArcGIS Online data — answered in one place.
Find your ArcGIS FeatureServer layer URL
In ArcGIS Online, open Content → click your hosted feature layer → click View item details. Scroll to the bottom and copy the Service URL. It ends with /FeatureServer/0 (or another layer index).
Example: https://services.arcgis.com/abc123/arcgis/rest/services/MyLayer/FeatureServer/0
Connect your ArcGIS Online account
Easiest way: Register or log in with Sign in with ArcGIS Online (the blue button on the login page). Your token is set automatically — no copying required. You can then browse and add your services directly from the Services page.
Manual way: In ArcGIS Online, click your profile avatar → My Profile → scroll down → Generate Token. Set expiry (24 h is enough for testing), click Generate, copy the token, and paste it into the Token field when adding a service in GISGP.
Upload your file and map the fields
Go to Operations → Excel / CSV Import. Upload your file, select your service, and map your columns to AGOL fields using the dropdowns. A Preview & Confirm step shows your first 10 rows before anything is written — then click Confirm & Import. Your data lands in AGOL with no Pro license needed.
…or export your layer instead
Only need data out of ArcGIS Online? Skip straight to Exports. Paste your FeatureServer URL (steps 1–2 above), pick a format — Excel, CSV, GeoJSON, Shapefile or PDF report — optionally set a target coordinate system, and download. No import required.
A FeatureServer URL is the REST API address of your hosted feature layer in ArcGIS Online. GISGP uses it to read and write your GIS data directly.
To find it: ArcGIS Online → Content → your layer → View item details → Service URL (bottom of page). Copy the URL — it should end with /FeatureServer/0.
If you have a MapServer URL (/MapServer/0), you can use it for exports and tools but not for imports (MapServer layers are read-only).
Tokens prove that you have permission to access a private layer:
- Log in to ArcGIS Online (arcgis.com)
- Click your profile avatar → My Profile
- Scroll to the bottom → Generate Token
- Set the expiry (we recommend 24 hours)
- Click Generate Token → copy the result
No. If a layer is shared publicly (Everyone) in ArcGIS Online, leave the Token field empty. You only need a token for layers that are private or restricted to your organisation.
Yes — paste your portal's FeatureServer URL (e.g. https://portal.mycompany.com/arcgis/rest/services/…/FeatureServer/0) and a token generated from that portal. The workflow is identical to ArcGIS Online.
Make sure your token has Editor or higher permissions on the target layer.
It is the easiest way to connect GISGP to your ArcGIS Online account. Click the blue Sign in with ArcGIS Online button on the login page, log in with your usual ArcGIS credentials, and you are done — no token needed.
Benefits vs. manual token:
- Token is set and refreshed automatically — never expires unexpectedly
- Your AGOL services appear automatically on the Services page — one click to add them
- The Import wizard auto-fills your token for any private layer
Go to Services in the left sidebar. You will see a blue banner — Connected to ArcGIS Online — with a Browse my services → button. Click it to see all your Feature Services from ArcGIS Online. Click + Add next to any layer to save it to your profile with your token pre-filled.
If you are not connected via OAuth, you can still add services manually by pasting the URL and token.
Yes — paste your portal's FeatureServer URL (e.g. https://portal.mycompany.com/arcgis/rest/services/…/FeatureServer/0) and a token generated from that portal. The workflow is identical to ArcGIS Online.
Generate a token from your Enterprise Portal: Portal URL → /sharing/rest/generateToken, or from the Portal's web UI under My Profile → Generate Token.
Make sure your token has Editor or higher permissions on the target layer.
No. If a layer is shared publicly (Everyone) in ArcGIS Online, leave the Token field empty. You only need a token for layers that are private or restricted to your organisation.
A dry run validates your data and field mapping without actually writing anything to your AGOL layer. It shows you exactly how many rows would succeed and what errors exist — useful for checking a new import before committing.
The demo import always runs as dry-run. Your own imports push real data to AGOL.
- Excel (.xlsx) — any sheet; first row = headers
- CSV (.csv) — comma or semicolon separated
- CSV / Excel with coordinates — columns named Latitude/Longitude (or X/Y) → creates Point features
- KML / KMZ — Google Earth exports
- Geotagged Photos (.jpg/.jpeg) — GPS EXIF → Point features
Between field mapping and the actual import, GISGP shows a dedicated Preview & Confirm step. It displays your first 10 rows exactly as they will appear in ArcGIS Online — with AGOL field aliases as column headers — so you can verify the mapping before committing.
You also see a summary chip showing the number of mapped columns and the import mode (Add or Upsert). Only mapped fields are shown; skipped columns are excluded. Click ← Back to Mapping to adjust, or Confirm & Import → to proceed.
After you have configured the field mapping dropdowns, click 💾 Save profile and give it a name (e.g. "Monthly Survey"). Next time you import the same format of file to the same service, your profile appears in the Load saved profile dropdown — click it and all mappings are restored instantly.
Profiles are saved per service. You can delete outdated profiles with the 🗑 button.
By default, imports add all rows as new features. If you run the same import twice you get duplicates.
Update / add by key (Upsert) prevents this: choose a key field (e.g. asset_id) and GISGP will:
- Update existing features where the key field value matches
- Add new features for rows whose key is not yet in AGOL
Use this for monthly data refreshes where you want to update existing records rather than duplicate them.
Check the import log shown after the run. Common causes:
- Type mismatch — a text value in a number field. Fix the data in your Excel file.
- Domain violation — a value not in the coded-value domain. Use the free Domain Extractor tool to see valid codes.
- Token expired — generate a new token, or use "Sign in with ArcGIS Online" for automatic token refresh.
- Row limit exceeded — your plan allows a limited number of rows per import. Upgrade or split the file.
- No edit permissions — your AGOL token must have Editor or higher rights on the target layer.
- Excel (.xlsx) — attributes only
- CSV (.csv) — attributes only
- Shapefile (.zip) — geometry + attributes, WGS84 projection
- KML (.kml) — geometry + attributes, for Google Earth
- KMZ (.kmz) — compressed KML
- GeoJSON (.geojson) — geometry + attributes, standard web GIS format
All formats include all selected attributes. Use the WHERE filter in the export wizard to export a subset of features.
No. All 20 free tools are available without registration, including:
- GeoJSON Viewer — view, convert and export GeoJSON/SHP/KML/CSV/Excel/DXF
- REST Explorer — browse any AGOL service
- Health Check — test connectivity and performance
- Domain Extractor — see all coded-value domains
- Field Type Checker — inspect field schema
- SQL WHERE Builder — build and test filter queries
- Coordinate Converter — convert between coordinate systems
- Web Map Layers — inspect all layers in a Web Map
- Survey123 Lookup — find and export Survey123 form data
- Feature Count — count features in any Feature Service
| Plan | Price | Imports / month | Max rows / import | Exports / month | Team seats | Schedules |
|---|---|---|---|---|---|---|
| Free | $0 | 3 | 100 | 5 | — | — |
| Starter | $9 | 20 | 2,000 | 50 | — | — |
| Pro | $19 | 100 | 5,000 | 200 | — | 3 |
| Team | $49 | 300 | 50,000 | 750 | 5 seats | 10 |
| Business | $99 | ∞ | 999,999 | ∞ | 10 seats | 25 |
Limits reset on the 1st of each month. Demo operations never count against your limits.
Scheduled Exports automatically export data from your AGOL Feature Service on a recurring schedule (daily or weekly) and send the file as an email attachment. No manual action is needed after setup.
Available on Starter, Pro, Team and Business plans (Starter = 1 schedule, Pro = 5, Team = 10, Business = 25).
- Go to Schedules in the sidebar (visible on Pro+ plans)
- Select a service, format, and optional WHERE filter
- Choose Daily or Weekly and the UTC hour to run
- Enter the email address to receive the file
- Click Create Schedule
The first run will happen at the next occurrence of the selected time. You can pause, resume or delete any schedule from the same page.
Six formats are available: Excel (.xlsx), CSV, Shapefile (.zip), KML, GeoJSON, and PDF Report. The file is attached directly to the email.
For PDF schedules, select the PDF format and optionally choose a saved PDF Template — the report will use your saved layout, accent colour and basemap automatically on every run.
Yes. The Email Delivery Preview card on the Schedules page shows you exactly what the recipient will receive — From address, Subject line, body text, and the attachment filename — before you click Create Schedule. The preview updates live as you change the service, format, frequency, or recipient address.
Yes. Each schedule has its own Send to email field — you can send to a colleague, a shared inbox, or any address. Your account email is the default but can be changed per schedule.
Each saved service has a dedicated Hub — a tabbed workbench that gives you a complete view of that layer without leaving GISGP. Click the Hub button on the Services page to open it.
The Hub includes:
- Overview — metadata: geometry type, feature count, capabilities, CRS
- Map — interactive Leaflet map with your layer's original AGOL symbology (simple, unique-value and class-breaks renderers). Features display at the correct geographic position.
- Attributes — table of all records; click a row to highlight the feature on the map
- Quick links to Import and Export for that service
This does not happen in GISGP — all map requests include outSR=4326 to ensure coordinates are returned in WGS84, which is what Leaflet expects. If you see features at the wrong location in an external tool, it is likely because the tool is missing this parameter and receiving Web Mercator coordinates instead.
Saved Queries let you store frequently used WHERE clauses (SQL filters) and reload them in one click. Instead of typing status='Active' AND district='North' every time, save it once and load it from any export or filter panel.
Go to Saved Queries in the sidebar to manage your library. You can optionally associate a query with a specific service, or keep it generic.
- In the Exports wizard, Step 2 — build your WHERE filter
- Click Save Query and give it a name
- The query is saved to your Saved Queries library
Next time, click Load Saved Query in the export filter panel and select it from the dropdown.
The PDF Template Builder (PDF Builder in the sidebar) is a visual editor for customising how Feature Report PDFs look. You can set:
- Accent colour — choose from presets or enter any hex colour
- Map aspect ratio — Standard (4:3) or Wide (16:9)
- Basemap — Topographic, Satellite or Streets
- Report title
- Sections — toggle Summary, Location Map, Attributes, Geometry, Notes on or off
A live preview with a real Leaflet map updates in real time as you make changes. When you are happy, click Save Template.
Service Report tool (Tools → Service Report PDF): After loading a layer, open the Saved Templates card and click Load next to any template. The layout, accent colour and basemap are applied to the live preview immediately.
Scheduled PDF export: When creating a schedule with format PDF, a PDF Template picker appears. Select a saved template — every automatic PDF run will use that layout.
Yes. Once you have selected a feature in the Browse Features panel and the preview looks correct, scroll to the Email Delivery card, enter a recipient address and click Send PDF. The PDF is generated and delivered within a few seconds (requires a GISGP account).
Connected Accounts let you store tokens for multiple ArcGIS Online organisations in one GISGP profile. This is useful if you work with more than one AGOL org — for example as a consultant with several clients, or as staff in two organisations.
Go to Connected Accounts in the sidebar to add, check or remove accounts. Each account stores the org URL, your username and a token. The Check Connection button verifies the token is still valid.
No — they are complementary. Your main GISGP login (email + password or Sign in with ArcGIS Online) stays unchanged. Connected Accounts store additional org tokens you can reference when adding services manually from other organisations.
Go to Settings in the sidebar to customise your experience:
- Organisation name & footer text — appear in generated PDF reports
- Default basemap — pre-selects the map background in all tools
- Default export format — pre-selects the format in the Export wizard
- Default PDF orientation — Portrait or Landscape
- Email notifications — toggle alerts for completed imports, exports, scheduled runs and errors
Go to Settings → Organisation name, enter your organisation name and footer text, and save. This text will appear in the header and footer of all Feature Report PDFs you generate from the Service Report tool or via Scheduled Exports.
Team (5 seats) and Business (10 seats) plans let the account owner invite additional users who share the plan's limits. Each invited member gets their own GISGP login and can run imports and exports independently.
The member's usage (imports, exports) is counted against the owner's plan limits. Members cannot manage billing, team seats, or scheduled exports — those are owner-only actions.
- Go to Team in the sidebar (visible on Team and Business plans)
- Enter the email address of the person you want to invite
- Click Send Invitation
The invitee receives an email with an acceptance link. They need a GISGP account with that email address — if they don't have one, they can create it for free and then accept the invitation.
Yes. On the Team page, click the Remove button next to any member. They immediately lose access to the team plan and revert to a Free account.
No. Files you upload (Excel, CSV, KML, photos) are stored temporarily on AWS S3 only to perform the operation. They are automatically deleted from our servers immediately after the import or export completes — typically within 60 seconds.
Your GIS data is written directly from the upload to your own ArcGIS Online account. We do not maintain a copy.
Yes. GISGP is designed for EU compliance:
- Temporary files auto-deleted after each operation
- Infrastructure hosted in AWS EU (Ireland, eu-west-1)
- All traffic over HTTPS/TLS; passwords stored as bcrypt hashes
- A full Data Processing Agreement (DPA) is available — required by GDPR Art. 28 for Controller–Processor relationships
- Sub-processors listed in the DPA; international transfers covered by Standard Contractual Clauses
Not currently. Automatic AI field mapping is planned for a future release. When enabled, only column headers, up to 10 sample rows, and AGOL field metadata would be sent — never the full dataset.
All other operations (import, export, validation, scheduled exports, free tools) are processed entirely within GISGP's own infrastructure. No GIS data is shared with any external AI service.
How to Export ArcGIS Online Data to Excel
Export any ArcGIS Online Feature Service to Excel, CSV, Shapefile, KML or GeoJSON in two clicks — no ArcGIS Pro, no Python. Open Export Studio, paste your Feature Service URL, optionally filter with a WHERE clause, pick a format and export — Shapefile and GeoJSON can be reprojected to any EPSG (target CRS) on the way out. Large exports (Team/Business plans) run in the background and arrive by email.
Full step-by-step guide, supported formats and FAQ: Export ArcGIS Online to Excel →
Export your data now → ▶ Watch: Export to Excel (60 sec)How to Download All Attachments from ArcGIS Online
ArcGIS Online has no bulk "download all attachments" — the only built-in path is a full File Geodatabase export, which needs layer ownership and ArcGIS Pro to extract. The free Attachment Downloader covers that gap: paste a Feature Service URL (add a token for private layers), scan to see how many photos and files the layer holds, and download everything as one ZIP — a folder per feature, named by a field you choose, plus an _index.xlsx mapping every file to its record. Works with Survey123 photo submissions.
Need it recurring? On a paid plan, add a schedule with the Attachments backup format — a fresh ZIP link lands in your inbox daily, weekly or monthly.
Download attachments now →How to Export Survey123 Repeats Joined with the Parent Survey
Survey123 stores repeat answers in related tables, and ArcGIS Online exports them as separate tables — leaving you to match them by GlobalID with VLOOKUP or a script. The free Repeats Export tool does the join for you: paste the survey's FeatureServer URL, scan to see the repeat tables, and download one Excel with a Parent sheet, a sheet per repeat table, and a flattened Joined sheet where every repeat row already carries its parent record.
Join keys are read straight from the layer's relationship definitions, so it works with any related-records layer — not just Survey123. Filter parents with a WHERE clause for large surveys.
Export repeats joined →How to Compare the Schemas of Two ArcGIS Layers
Appends fail and migrations bite when two layers' schemas quietly drift apart — and ArcGIS Online has no schema compare (it's a Pro-only tool). The free Schema Comparator diffs two layers in the browser: added and removed fields, plus type, length, domain and nullable changes, with a copy-ready report for your migration doc.
Compare two layers →How to Schedule Automatic ArcGIS Online Exports
Manually exporting data from ArcGIS Online every week is slow and easy to forget. GISGP lets you schedule recurring exports — daily, weekly or monthly — and deliver the file directly to your inbox as an Excel, CSV or Shapefile attachment. No servers, no Python scripts, no cron jobs.
What you can schedule
- Any ArcGIS Online or Enterprise Feature Service layer
- Any export format: Excel, CSV, Shapefile, KML, GeoJSON — or an Attachments backup (ZIP of all layer photos/files, delivered as a 24h link)
- Any WHERE clause filter — export only today's records, only "Open" status, etc.
- Delta exports — only records changed since the last run
- Multiple recipients — comma-separated email addresses
Setting up a scheduled export
- Go to Schedules and click New Schedule.
- Select your Feature Service and configure the export (format, fields, WHERE filter).
- Set the frequency: hourly (1–12h), daily, weekly or monthly.
- Enter one or more email addresses for delivery.
- Click Save. The first run will happen at the next scheduled time.
💡 Delta mode: enable "Only changes since last run" to export only records edited or added since the previous delivery. Ideal for large layers where you only care about what changed.
Frequency and timing
Schedules run on UTC time. For a daily export at 8:00 AM CET, set the run hour to 7. GISGP checks for due schedules every 5 minutes, so actual delivery is within 5 minutes of the configured time.
Plan limits
- Free: no schedules
- Starter: 1 active schedule
- Pro: 5 schedules
- Team: 10 schedules
- Business: 25 schedules
See also: monitor your ArcGIS Online service for uptime and error alerts alongside your scheduled exports.
How to Import Excel or CSV Data into ArcGIS Online
Update an ArcGIS Online Feature Service from Excel, CSV or KML using GISGP's browser-based Import Studio — field mapping, AGOL dry-run validation, preview and bulk add/upsert, no ArcGIS Pro or Python required. Open Import Studio to get started.
Full step-by-step guide, supported formats, row limits by plan and troubleshooting: Import Excel to ArcGIS Online →
Import your data → ▶ Watch: Import Excel to ArcGIS (90 sec)ArcGIS Online SQL WHERE Clause — Complete Guide
The WHERE clause is the standard way to filter features in ArcGIS Online Feature Services. Whether you're exporting only this week's inspections, querying open work orders, or scheduling a daily report of changed records — you need a valid SQL WHERE expression. This guide covers the syntax, common examples and the free GISGP WHERE Builder tool.
Basic syntax
ArcGIS Online uses a subset of standard SQL for WHERE clauses. The general form is:
field_name operator value
Multiple conditions can be combined with AND / OR:
STATUS = 'Open' AND PRIORITY = 1
Field types and operators
Text fields
- Equals:
STATUS = 'Open' - Not equals:
STATUS <> 'Closed' - Contains:
NAME LIKE '%road%'(case-insensitive) - Starts with:
NAME LIKE 'Main%' - List:
STATUS IN ('Open', 'Pending')
Number fields
PRIORITY = 1SCORE >= 80SCORE BETWEEN 50 AND 100
Date fields
ArcGIS Online uses the timestamp keyword for date comparisons:
- After a date:
EditDate >= timestamp '2026-01-01 00:00:00' - Within a range:
EditDate BETWEEN timestamp '2026-01-01 00:00:00' AND timestamp '2026-06-30 23:59:59' - Today's records: use the WHERE Builder date presets — it generates the correct timestamp automatically.
NULL values
- Is empty:
NOTES IS NULL - Has a value:
NOTES IS NOT NULL
Common examples for GIS teams
- Open work orders:
STATUS = 'Open' - High priority items:
PRIORITY IN (1, 2) AND STATUS <> 'Closed' - Last 7 days:
EditDate >= timestamp '2026-05-30 00:00:00' - Specific inspector:
INSPECTOR = 'J.Smith' AND INSPECTION_DATE >= timestamp '2026-06-01 00:00:00' - All records: leave the WHERE clause empty
💡 Use the free SQL WHERE Builder — paste your FeatureServer URL, pick your fields from dropdowns and the tool writes the SQL for you. No typing required.
Testing your WHERE clause
Before exporting or scheduling, test your filter in the WHERE Builder:
- Go to tools/where-builder
- Paste your FeatureServer URL
- Build your conditions using the field dropdowns
- Click Preview — see the matching record count instantly