I was trying to use the csv exported file on Prestashop on Excel.
The problem is the user readability.
I need to have some user readability to be able to work on the csv file using Google Sheets or Excel.
Unfortunately removing the tags won’t get me anywhere because once I’ve finished I’ll have to do an import on PrestaShop to apply the changes to the current version.
Is there any correct way of doing this?
What I tried:
- importing on Google Sheets with a Separator type of
";"
- Changing the exported csv file extension to .txt, then importing on Google Sheets with a Separator type of
";"
- Removing all the HTML tags using a Regex on Sublime
<\s*[^>]*>
(Replacing all the occurrences with a space)
Another Problem: Once I’ve finished I’ll have to do an import on PrestaShop to apply the changes