Opening Exported SharpSpring Files
CORRUPT LOOKING EXPORTED FILES
If your exported files look odd when opening, similar to the screenshots on the right, you'll need to follow the steps below to open it correctly, either in Google Docs or Excel. This happens when your spreadsheet application doesn't correctly recognize the file format.
Instructions for Excel
- Open Excel (do not open the file)
- Select the Data tab
- Select From Text
- Open the file
- Select Delimited in the section Original Data Type
- Select Unicode (UTF-8) in the option File Origin
- Click Next
- Select Comma
- Under Text qualifiers, select none
- Click Finish
- Click OK
Instructions for Google Docs
- Upload the file to Google Drive (skip if already there)
- In Google Drive, click New > File Upload
- Select the .CSV file.
- Click Open.
- Opening the file:
- Right-click the uploaded file.
- Select Open With Google Sheets.
- Splitting the columns:
- Select Column A
- In the menu bar, click Data > Split text to columns...
- In the separator menu that appears will display, select the appropriate punctuation separator (the same character between each of the fields).
- If you need to download the file, click File > Download As > Comma-separated values (.csv, current sheet).
Note: If there are quotation marks around the beginning and end of words, use Edit > Find/Replace to remove them. Rows containing commas as data—and not as record separators—should have their fields encased in quotation marks to avoid this data being misinterpreted as a delimiter.
Written By: Sam Koekemoer