So the problem that I'm facing is that I'm extracting dates for events and it is extracting the text form the website. But it is just text and not in a format that can be read by excel. my question is, is there any way to extract this text and automatically put it in a format that can be read by excel?
If the data you are extracting is in a date format, for example: 6/13/2020, you will extract it with text and export it to CSV and Excel will normally recognize the format as a date; otherwise, you only need to format the cells for the date format. Or you can export everything as text and perform an excel treatment to make it date format.