How do I get 100,000+ sitemap URLs into Excel?

Excel can technically handle 1,048,576 rows per sheet, but real-world performance degrades past ~200k rows — opening, filtering and saving slow down dramatically. For a 100k-URL sitemap, three options. First: convert to .xlsx and open it — works for analysis, save changes only when needed. Second: import the CSV via Power Query (Data → Get Data → From File → From Text/CSV) which streams data and is faster than the legacy importer. Third (best for huge sets): keep the data in Google Sheets, BigQuery or DuckDB and skip Excel entirely. xmlsitemapmaker.com handles sitemap-index files up to several million URLs in one conversion — the bottleneck is downstream, not the converter.