Retracing my steps for PayPal CSV import to MySQL

1.) Sort records in Google Spreadsheets by those that have Shipping Address and delete the rest.
2.) Find and replace commas with asterisks, i.e. Find "," Replace in This sheet "**"
3.) Export CSV from Google
4.) Import CSV to MySQL
5.) Export SQL
6.) Drop Table
7.) Open SQL in TextWrangler, Find and Replace "**" with "\,"
8.) Import SQL into MySQL

Google Spreadsheets
Edit ->
Find and replace…

Leave a Reply

Your email address will not be published. Required fields are marked *

Shares