You should stop using Excel’s Import Wizard and use this instead
https://www.makeuseof.com/stop-using-excels-import-wizard-and-use-this-instead/
- IMPORTCSV is a faster, formula-based alternative
Its syntax only has one required argument - IMPORTCSV also handles web-hosted CSV files
Replace the file path with a URL, and Excel fetches the data for you - Filter imported data without loading the entire file
Nest IMPORTCSV inside FILTER and CHOOSECOLS for targeted results - IMPORTCSV pairs well with Excel’s other dynamic array functions
A few combinations worth trying
Zie ook:
IMPORTCSV function – Microsoft Support
https://support.microsoft.com/en-gb/office/importcsv-function-cc1da653-d238-4162-b1fd-1f9006329fab
De functie IMPORTCSV – Microsoft Ondersteuning
https://support.microsoft.com/nl-nl/office/de-functie-importcsv-cc1da653-d238-4162-b1fd-1f9006329fab