Send to CSV DO NOT OPEN!!!
| Step 1. Run excel price book and Save to CSV | Do NOT open the CSV!!!! | |||||
| Step 2. Open new excel | ||||||
| Step 3. Import data | 1. open a new excel | 2. Data | Get Data | From File | From Text/CSV | |
| Choose from downloads: | ecdistpricelist2011 (1).csv | Import | ||||
| Delimiter | Custom | ~ | ||||
| Data Type Detection: | Do Not Detect DataTypes | |||||
| Step 3. Change delimiters | Transform Data: | |||||
| Step 4. Change to: not detact data types | Use first row as headers | if you skip this, the headings will not be correct | ||||
| Step 5. Transform Data option | Data Type: | if you skip this: | part codes will not have leading zeroes | UPC will be invalid | ||
| leave alone! | BasePrice thru Weight -leave these as they are!!! | |||||
| Step 6. Change - recognize 1st row is the headings | Change to "TEXT" | Product_Group thru | Quantity_Break | Replace Current data type | ||
| Step 7. Change Data Type - TEXT begin thru QtyBreak | Change to "TEXT" | pH thru | Note 2 | Replace Current data type | ||
| Step 8. Change Data Type - TEXT BasePrice thru Weight | Close & load | |||||
| Step 9. Change Data Type - TEXT PH thru Note2 | Format / Format Cells / Number | |||||
| Step 10. Close & Load | ||||||
Find Replace characters
| 9. Find/replace | ||||
| Find | " | " | Replace All | " |
| Find | & | & | Replace All | & |
| Find | < | < | Replace All | < |
| Find | | | Replace All | space |
| Find | ® | ® | Replace All | space |
| Find |   |   | Replace All | space |
| Find | â„¢ | â„¢ | Replace All | space |
| ™ | ™ | Replace All | space | |
| Find | 7777 | = ERRORS!!! | ||
| Find | 0.00 | = ERRORS!!! | ||
| Find | 9999 | = ERRORS!!! | ||
Format numbers
| Number 2 decimals | From Columns Base_Price | to Weight | ||
Delete other 2 Sheets
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article