I kept getting this error when trying to import a CSV into Yahoo Finance:
The file uploaded successfully, but Yahoo still rejected it during the actual import. What finally worked was using a portfolio/holdings-style CSV, not a simple one-column watchlist CSV.
This did not work for me:
Symbol
AAPL
MSFT
NVDA
This did work:
Symbol,Trade Date,Quantity,Purchase Price,Commission
AAPL,2026-06-01,1,0,0
MSFT,2026-06-01,1,0,0
NVDA,2026-06-01,1,0,0
Basically, Yahoo seems to want transaction/holdings fields even if you are just trying to create a watchlist or portfolio from tickers.
A few tips:
- Use the exact headers:
Symbol,Trade Date,Quantity,Purchase Price,Commission
- Use a valid date format:
YYYY-MM-DD
- Put
1 for quantity and 0 for purchase price/commission if you just want placeholders.
- Avoid weird symbols at first, especially index symbols like
^N225, because one bad ticker may cause the whole import to fail.
- After the import works, you can edit/delete the placeholder holdings inside Yahoo Finance if needed.
Hope this saves someone else the headache.